Vlookup that returns look up if a cell on the same row has a specific value

Table 9

A B C
1 john 1/1/12 P
2 Steve 12/1/12 A
3 Khan 1/4/13 A


with the above mock table I'm looking for a vlookup formula or vba that comprises a lookup value that matches the name and looks up the date only if the value in column C is 'P'.



Vlookup example.xlsx

Ive attached a sheet for your viewing.

Many thanks