VLOOKUP?????

[Bob]

Not sure if I use vlookup or something else for the following:

I have a table with the following:

column "A" = Hieght -1000 to 6000
Header (Row1) = Temperature 0 to +50 degrees C

I am after by inserting temperature and hieght in two seperate cells (Sheet1
"A1" & "A2") cell "A3" will give the result.
Any ideas?

 

[Dave Peterson]

You'll want to use =index(match(),match())

Debra Dalgleish explains it here:
http://contextures.com/xlFunctions03.html

especially examples 2 and 3
http://contextures.com/xlFunctions03.html#IndexMatch2
http://contextures.com/xlFunctions03.html#IndexMatch3

 

[Bob]

Thanks Dave works well.
--
Bob

You'll want to use =index(match(),match())

Debra Dalgleish explains it here:
http://contextures.com/xlFunctions03.html

especially examples 2 and 3
http://contextures.com/xlFunctions03.html#IndexMatch2
http://contextures.com/xlFunctions03.html#IndexMatch3