REVERSE VLOOKUP

[FARAZ QURESHI]

Hi everyone is there any technique of vlookup whereby the very last entry is
first considered. In other words "=VLOOKUP(A1,B:C,2,0)" shall look for a
match of A1 in column B and return the corresponding value in C for the FIRST
case.

But How can I achieve the corresponding value of the LAST matching entry?

 

[T. Valko]

Try this:

=LOOKUP(2,1/(B1:B20=A1),C1:C20)

Note that you can't use entire columns as range references in (B1:B20=A1)
unless you're using Excel 2007.

 

[FARAZ QURESHI]

XClent
--

Best Regards,
FARAZ A. QURESHI

Try this:

=LOOKUP(2,1/(B1:B20=A1),C1:C20)

Note that you can't use entire columns as range references in (B1:B20=A1)
unless you're using Excel 2007.

 

[T. Valko]

You're welcome!

--
Biff
Microsoft Excel MVP

XClent