Inputting Data

[digger200]

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

 

[SteveGregory]

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.

 

[digger200]

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

 

[electricpete]

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.

 

[digger200]

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