The ANTI-VLookup

Pankman · Mar 26th, 2002, 07:21 AM

Hey folks,

I know how to use VLOOKUP, but how do I use it the other way around. I want to look in a range of cells in the rightmost column, and when I find the thing I want, to return the value in the left most column. Sort of VLOOKUP reversed.

Can anyone help me?

Ian Mac · Mar 26th, 2002, 07:29 AM

Use Index/Match

e.g.

=INDEX(A1:C100,MATCH(D1,C1:C100,0),1)

where A1:C100 is the table your looking at

MATCH(D1,C1:C100,0) find the row number from the criteria presented in D1

and 1 being the Column number

Mar 26th, 2002, 07:29 AM	#2
Ian Mac MrExcel MVP Join Date: Feb 2002 Location: Newcastle, UK Posts: 1,174	Use Index/Match e.g. =INDEX(A1:C100,MATCH(D1,C1:C100,0),1) where A1:C100 is the table your looking at MATCH(D1,C1:C100,0) find the row number from the criteria presented in D1 and 1 being the Column number __________________ "Have a good time......all the time" Ian Mac

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 26th, 2002, 07:21 AM	#1
Pankman New Member Join Date: Mar 2002 Posts: 7	Hey folks, I know how to use VLOOKUP, but how do I use it the other way around. I want to look in a range of cells in the rightmost column, and when I find the thing I want, to return the value in the left most column. Sort of VLOOKUP reversed. Can anyone help me?