VLOOKUP?????
 

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?


--
Bob

VLOOKUP?????
 

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

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

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

Bob wrote:

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?

--
Bob

--

Dave Peterson

VLOOKUP?????
 

Thanks Dave works well.
--
Bob


"Dave Peterson" wrote:

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

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

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

Bob wrote:

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?

--
Bob

--

Dave Peterson