Thread: Can VLookup return the LAST value in a range?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Steve Steve is offline
external usenet poster
  
Posts: 1,814
Default Can VLookup return the LAST value in a range?
If I have a list:
A 10
B 3
C 5
A 8
D 6

How can I get VLookup to return to value associated with the last occurance
of A instead of the first (i.e the value 8)?
Reply With QuoteReply With Quote