Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Table Array in VLOOKUP Relies on Data Validation | Excel Worksheet Functions | |||
How to use a cell value as Table Array in VLOOKUP worksheet function | Excel Discussion (Misc queries) | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
vlookup data hidden within worksheet | Excel Worksheet Functions | |||
Excel has a "Find Next" command but no "Find Previous" command. | Excel Discussion (Misc queries) |