Doug Van
asked on
Comparing a list of names against a list of names/email addresses?
One more question regarding my spreadsheet.
I need a way to compare a list of email addresses against a list of names.
Using: =IF(ISNA(MATCH(R2,sort(FIL TER({$K$2: $K$93}, LEN({$K$2:$K$93}))),0)), "Not Found", "Found")
And comparing a column K, which contains: Alayna Sergio
... against column R, which contains: Alayna Sergio <alayna.sergio@group.com>
Results in "not found". That is because it is looking for a precise match. Is there a way to search for just the name?
Here is the sample spreadsheet:
https://docs.google.com/spreadsheets/d/1Q2nN-MVD_iwJi2Se-PFWcNbMGb-EF6gQWQCruhnWW-Q/edit#gid=0
See the Grid to List tab.
Thank you. :)
I need a way to compare a list of email addresses against a list of names.
Using: =IF(ISNA(MATCH(R2,sort(FIL
And comparing a column K, which contains: Alayna Sergio
... against column R, which contains: Alayna Sergio <alayna.sergio@group.com>
Results in "not found". That is because it is looking for a precise match. Is there a way to search for just the name?
Here is the sample spreadsheet:
https://docs.google.com/spreadsheets/d/1Q2nN-MVD_iwJi2Se-PFWcNbMGb-EF6gQWQCruhnWW-Q/edit#gid=0
See the Grid to List tab.
Thank you. :)
Perhaps not exactly what you are looking for but perhaps will spark some thought: =if(iserror(find(K2,R2,1)) ,ʺNot Foundʺ,ʺFoundʺ)
ASKER
Thank you Steven.
Not exactly because it needs to search the entire K column. but I am wondering if this is the clue needed.
Not exactly because it needs to search the entire K column. but I am wondering if this is the clue needed.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you so much. :)
You're welcome!