Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLookUp - Does the VLookUp return the exact information? | Excel Worksheet Functions | |||
Vlookup in vlookup - taking the result as array name | Excel Worksheet Functions | |||
Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP | Excel Discussion (Misc queries) | |||
Vlookup -=VLOOKUP(F9,LookUp1!$A$2:$B$1504,2,FALSE) | New Users to Excel | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |