View Single Post
  #1   Report Post  
M Skabialka
 
Posts: n/a
Default How do I find a value in an array (VLOOKUP? HLOOKUP?)

I have a height, weight and body fat table. The columns are height, the
rows are weight, and the info between is body fat.

I would like to on a separate worksheet, enter the height and the weight and
have Excel find the bodyfat from my table and enter it on this sheet so I
can print it.

I think I need a VLOOKUP or a HLOOKUP, but I can't seem to be able to get
either to look at both height and weight and return the body fat.

B4 is the height, C4 the weight
=HLOOKUP(B4,Women!B1:AO1,1) tells me the height.
=VLOOKUP(C4,Women!A2:A71,1) tells me the weight, but I already know these.
The value I need is in cell F30

Thanks,
Mich