Vlookup and Countif
 

Alright, I have an odd question/desire.

Data would be something like this



In the F column, I would like it to display the other person attached to the duplicate data from Data3.....

So, in F5, since Jim and John have the same Data3, I would like F5="John Smith".

I had a complex formula to the idea of:

=IF(COUNTIF(E:E,E2)1,VLOOKUP($E2,$A$2:$E$5,B,FALS E),""))

Something like that. My understanding is that the COUNTIF portion identifies the duplicates, then processes the condition, the VLOOKUP. But my VLOOKUP is identifying the current cell's row.

So, F5 displays Jim Wilson, not the desired John Smith.

Is this even possible to do?

Regards,

bbkdude