VLOOKUP and HLOOKUP

[Mike M]

Here is the scenario. I have a record with two values, for example: Height
and weight.

I need to reference a grid of data with standard heights on the Y axis
(first column) and standards weights across the top on the horizontal X axis
(row). Where the two intersect, going down then across (or vice versa) is
the value I need to retrieve.

Can anyone provide any assistance?

Thanks,

Mike

 

[Dave Peterson]

Debra Dalgleish can.
http://contextures.com/xlFunctions03.html
Especially examples 2 and 3.

 

[M Kan]

INDEX-MATCH is always a good one. If you have a discrete set of Heights and
Weights, you can also use combo boxes and the INDEX function or pair up a
VLOOKUP/HLOOKUP with a variable Column reference

 

[Jan Bolluyt]

Hi, Mike
This formula worked for me ( in this case, in cell D5)

=INDEX($F$4:$Q$20, MATCH(B5,$F$4:$F$20,), MATCH(C5,$F$4:$Q$4,))

Your weight would be in B5 and your height in C5, the table would be an
array from F4 to Q20

Hope this helps,

JB


Here is the scenario. I have a record with two values, for example: Height
and weight.

I need to reference a grid of data with standard heights on the Y axis
(first column) and standards weights across the top on the horizontal X axis
(row). Where the two intersect, going down then across (or vice versa) is
the value I need to retrieve.

 

[Mike M]

Dave, Jan, M Kan,

Thank you all! The speed and replies are great thank you.

Mike