Hi All,
First off al, sorry for my bad English.
My question :
A Vlookup searches for the first hit with the lookup_value.
Is there a possibility to search for the last hit with the lookup_value?
For 15/02/2017 the value returned by the vlookup is 220.
Is there a way to return 230 (the last hit for 15/02/2017)?
Another formula? Vlookup? ...
Capture.PNG
Try this
=LOOKUP(2,1/(A2:A8=D1),B2:B8)
v A B C D 1 2/15/2017 2 2/2/2017 100 230 3 5/2/2017 500 4 10/2/2017 600 5 11/2/2017 700 6 2/15/2017 200 7 2/15/2017 220 8 2/15/2017 230
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Thanx a lot!
Last edited by jonas-martens; 02-20-2017 at 10:01 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks