need a formula

suyankjain This formula will find the value in A for the last entry "TINA" in B.

=INDEX(A:A,MAX((B:B="TINA")*ROW(B:B)),1)

If you have an older version of Excel you may have to confirm entry with Ctrl-Shift-Enter. That will put "curly brackets" around it. Not sure though.