Two Way Look up

Thanks can it be done without adding, any new column.

Originally Posted by SDCh

Add column helper to the left before Person Type, so you have format column like this:
Column Helper (A)|Person Type(B)|Person Name(C)|Date of Joining(D)

on "Column Helper" A2 add this code and copy down

=B2&C2

So you can use this vlookup:

=VLOOKUP(F4&G4,$A$2:$D$19,4,0)