Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 Last edited by bbkdude : July 10th 13 at 01:18 AM Reason: error in text |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
countif and vlookup | Excel Programming | |||
Countif/Vlookup | Excel Discussion (Misc queries) | |||
COUNTIF and VLOOKUP | Excel Worksheet Functions | |||
countif w/vlookup | Excel Discussion (Misc queries) | |||
vlookup and countif??? | Excel Worksheet Functions |