Vlookup - Final Occurence

ian_a91

Board Regular
Joined
Apr 23, 2014
Messages
63
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,),"-")
 

Some videos you may like

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.

Weazel

Well-known Member
Joined
Dec 24, 2011
Messages
3,155
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
 

Watch MrExcel Video

Forum statistics

Threads
1,108,614
Messages
5,523,906
Members
409,542
Latest member
Shezz01

This Week's Hot Topics

Top