Home |
Search |
Today's Posts |
#1
|
|||
|
|||
vlookup
Is there anyway to search a table indexing on a column that is to the left of
the column I am indexing on? e.g. I want to find the Number (in case being 1) that is associated with "A" in this table: 1 A 2 B 3 C |
#2
|
|||
|
|||
vlookup
=INDEX(A1:B3,MATCH(A5,B1:B3,0),1)
.... where your sample data is in A1:B3 and the letter A is in cell A5. |
#3
|
|||
|
|||
vlookup
Another version:
=INDEX(A1:A3,MATCH(A5,B1:B3,0)) Debra Dalgleish's has some notes you may like at: http://www.contextures.com/xlFunctions02.html (for =vlookup()) and http://www.contextures.com/xlFunctions03.html (for =index(match())) rrucksdashel wrote: Is there anyway to search a table indexing on a column that is to the left of the column I am indexing on? e.g. I want to find the Number (in case being 1) that is associated with "A" in this table: 1 A 2 B 3 C -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using single cell reference as table array argument in Vlookup | Excel Worksheet Functions | |||
VLOOKUP Limitations | Excel Worksheet Functions | |||
Have Vlookup return a Value of 0 instead of #N/A | Excel Worksheet Functions | |||
vlookup data hidden within worksheet | Excel Worksheet Functions | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |