Thread: [Solved] Matching last in a list
View Single Post
 
Old 06-08-2016, 12:13 PM
xor xor is offline Windows 10 Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,100
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default

You could try:

=LOOKUP(2;1/(A1:A5="Bill");B1:B5)
Reply With Quote