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

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.

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