Am I thick? lookup from table

[GDXAHD]

I have a simple table with height measurements as the headers and
value measurement down the left column. At the intersection of the tw
figures is the body fat % from the height and value measurement (wais
less neck size). All I want to do is have two entry cells, one fo
height the other for value and get it to look up the fat% from th
chart.

I tried the various look up types but they seem to want you to run
wizard each time or know which column the answer is in. I really wan
to make this simple for others to use and not display the table. S
really all that the enterer should do is enter height and value i
seperate cells and let excel find the answer. I thought this would b
easy (I regularly use vlookup for 2 column tables).

Any help is gratefully received.

Steve

 

[Ardus Petus]

Say your table (with headers is in A1:G10
Say height entry cell is A12
say value entry cell is B12

Enter formula:
=INDEX(B2:G10,MATCH(A12,A1:A10,1),MATCH(B12,A2:A10,1))

HTH

 

[Dave Peterson]

I think you want to use =index(match(),match())

Take a look at Debra Dalgleish's instructions:
http://contextures.com/xlFunctions03.html
especially:
http://contextures.com/xlFunctions03.html#IndexMatch2

 

[GDXAHD]

Thanks to you both. This seems to be what I need. I will know soo
when I try it out. I'll be back if I struggle!

Thanks again

 

[Alan Beban]

If the forms of your headers and value measurements are acceptable as
names, it is quite simple. On an Excel spreadsheet the space is the
intersection operator

Hence, highlight your table, click on Insert|Name|Create and check Top
row, Left column.

Then =header1 valuemeasurement3 will return the fat percentage for the
corresponding header and value measurement. And if the header name and
value measurement name are to be entered into Cells M1 and N1

=INDIRECT(M1) INDIRECT(N1)will return the corresponding fat percentage.

Alan Beban