B
bbkdude
Alright, I have an odd question/desire
Data would be something like thi
[image: http://i42.tinypic.com/2wpifjl.jpg
In the F column, I would like it to display the other person attached t
the duplicate data from Data3....
So, in F5, since Jim and John have the same Data3, I would like F5="Joh
Smith"
I had a complex formula to the idea of
=IF(COUNTIF(E:E,E2)>1,VLOOKUP($E2,$A$2:$E$5,B,FALSE),"")
Something like that. My understanding is that the COUNTIF portio
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
bbkdud
Data would be something like thi
[image: http://i42.tinypic.com/2wpifjl.jpg
In the F column, I would like it to display the other person attached t
the duplicate data from Data3....
So, in F5, since Jim and John have the same Data3, I would like F5="Joh
Smith"
I had a complex formula to the idea of
=IF(COUNTIF(E:E,E2)>1,VLOOKUP($E2,$A$2:$E$5,B,FALSE),"")
Something like that. My understanding is that the COUNTIF portio
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
bbkdud