Vlookup - Final Occurence

[ian_a91]

Hi I need a vlookup or something similar that I will return the final occurrence or match. The data I'm using has a lot of duplicates but i only need to return the last value.

This is what I'm currently using if that helps.

=IFERROR(VLOOKUP(B19,'Login - Logout'!$1:$1048576,6,),"-")

 

[Weazel]

its kinda hard to say exactly you don't specify a column in your range but something like...

=LOOKUP(2,1/('login - logout'!$A$2:$A$10=B19),'login - logout'!$B$2:$B$10)

would return the last value from column A based on the criteria in B19 assuming its not a blank