Hi All,
Hoping there's some really smart people out there that can help with what I need.
I'm trying to do VLOOKUPS from one sheet to another. Very easy, when there's only 1 match. Unfortunately, I have lots of matches.
I'd like to (if possible) have some sort of check that checks all matches in a VLOOKUP, and if they're all the same (or all the same but some are blank), return the value. If they're NOT all the same, return some sort of flag to make me manually check it. (you'll note that John returns Smith, because all are the same except for the blank one. Whereas Peter returns CHECK because one of the surnames does not match at all).
An example of my hopeful outcome is below, with the cells highlighted in yellow being the expected outcome.
In essence, the yellow cells would each be a Vlookup that searches for the first name, and if all the last names are the same, it returns that last name. If not, it returns a CHECK (this is arbitrary, it can be anything, so long as it's easily identifiable that manual checking is required).
Cheers,
ABGar
Hoping there's some really smart people out there that can help with what I need.
I'm trying to do VLOOKUPS from one sheet to another. Very easy, when there's only 1 match. Unfortunately, I have lots of matches.
I'd like to (if possible) have some sort of check that checks all matches in a VLOOKUP, and if they're all the same (or all the same but some are blank), return the value. If they're NOT all the same, return some sort of flag to make me manually check it. (you'll note that John returns Smith, because all are the same except for the blank one. Whereas Peter returns CHECK because one of the surnames does not match at all).
An example of my hopeful outcome is below, with the cells highlighted in yellow being the expected outcome.
In essence, the yellow cells would each be a Vlookup that searches for the first name, and if all the last names are the same, it returns that last name. If not, it returns a CHECK (this is arbitrary, it can be anything, so long as it's easily identifiable that manual checking is required).
Client_Final with ZCRM.csv | ||||
---|---|---|---|---|
A | B | |||
1 | John | Smith | ||
2 | Paul | CHECK | ||
3 | Craig | Simons | ||
4 | Carly | |||
5 | Peter | Holmes | ||
6 | ||||
7 | ||||
8 | John | Smith | ||
9 | John | Smith | ||
10 | John | Smith | ||
11 | John | |||
12 | Paul | Jones | ||
13 | Paul | Peters | ||
14 | Paul | Jones | ||
15 | Craig | Simons | ||
16 | Carly | |||
17 | Peter | Holmes | ||
18 | Peter | Holmes | ||
Sheet2 |
Cheers,
ABGar