REVERSE VLOOKUP
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.
--
Biff
Microsoft Excel MVP
"FARAZ QURESHI" wrote in message
...
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?
--
Best Regards,
FARAZ A. QURESHI
|