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

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