Hi,
This type of Vlookup will display the last value in column B
=VLOOKUP(9.99999999999999E+307,B:B,1)