"Domenic" wrote...
=INDEX(B:B,MAX(IF(A1:A1000="Jack",ROW(A1:A1000))) )

..entered using CONTROL+SHIFT+ENTER.

Be more efficient to use

=LOOKUP(1,1/(A1:A100="Bob"),B1:B100)