need a formula

suyankjain 

As variant, the regular formula is

=LOOKUP(2,1/(B:B="TINA"),A:A)