Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lookup function
I would like to create a look up functin for a table with x and y values.
I will have a series of calculations in excel for stormwater runoff calcualtions. What I would like is to take two numbers from my calculations ( an x and y value) look each in a given table to obtain a 3rd value correlating to the intersection of x and y value in the table. Hopefully this isn't too confusing but I would appreciate any help if possible. Think of it this way. I would lilke to look in a table to find my ideal weight. I have my height (x) and age (y). Based upon these to data points I can find my ideal weight. How can I create a lookup function to do this and export the number into additional caculations? Thank you, LB |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lookup function
=INDEX(Table_Range,MATCH(A2,Y_Range,0),MATCH(B2,X_ Range,0)
so if your table is A10:F100 A2 is the cell where you put in the age and B2 the weight =INDEX(A10:F100,MATCH(A2,A10:A100,0),MATCH(B2,A10: F10,0)) should do it -- Regards, Peo Sjoblom "LB" wrote in message ... I would like to create a look up functin for a table with x and y values. I will have a series of calculations in excel for stormwater runoff calcualtions. What I would like is to take two numbers from my calculations ( an x and y value) look each in a given table to obtain a 3rd value correlating to the intersection of x and y value in the table. Hopefully this isn't too confusing but I would appreciate any help if possible. Think of it this way. I would lilke to look in a table to find my ideal weight. I have my height (x) and age (y). Based upon these to data points I can find my ideal weight. How can I create a lookup function to do this and export the number into additional caculations? Thank you, LB |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to combine an IF Function with a lookup function to determine | Excel Worksheet Functions | |||
Using Lookup function | Excel Worksheet Functions | |||
Lookup Function | Excel Discussion (Misc queries) | |||
Pivot table doing a lookup without using the lookup function? | Excel Discussion (Misc queries) | |||
An in between lookup function | Excel Worksheet Functions |