Thread: REVERSE VLOOKUP
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
FARAZ QURESHI FARAZ QURESHI is offline
external usenet poster
 
Posts: 553
Default REVERSE VLOOKUP

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