This will return the last match, assuming your lookup value is in A1 and your return results are contained in column D….change as necessary. =LOOKUP(2,1/($C$1:$C$5201=A1),$D$1:$D$5201)

This is like using a vlookup from the bottom up.