×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Inputting Data

Inputting Data

Inputting Data

(OP)
I want to use equations that use data from a table (on the same worksheet would be nice)
So how do I go about it. Imagine my equation for a certain model is 2 x A, where A is situated in the data file (row?) and depends on what type the base model is.


(I can't seem to find what I want in the help files or by using search. I'm probably using the wrong terms)
Thanks

RE: Inputting Data

Put all of the data for each model in a row with the model number in the first column. Then use the INDEX function in your equation to get the value of A.

RE: Inputting Data

(OP)
Thanks for that. I've decided to write a macro with the data in that.

RE: Inputting Data

It is also pretty easy to do with lookup functions.

The attached file computes: Y = A + B*t + C*t^2 + D*t^3

where A, B, C, D are different depending on the model (model1, model2, model3, or model4).

The values of A, B, C, D are stored in a table which is named "mtable" (named range).

The values are retrieved from the table using hlookup function.

= hlookup(mtable, lookupvalue, rownumber)
where the model is used as a lookupvalue.  The hlookup finds the correct row for the model and reads down the number of rows you tell it to find the correct coefficient.

The second version (labeled "more elegant", but actually a little more complicated) uses match function to determine the correct row number for A, B, C, D)

=====================================
Eng-tips forums: The best place on the web for engineering discussions.

RE: Inputting Data

(OP)
Thanks Guys, now I've seen your HLOOKUP method I've used that.
Thanks again

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources