wanderingsand
New Member
- Joined
- Jun 27, 2018
- Messages
- 5
Hello,
I am currently trying to clean up contact information at my firm. The goal is to search client names on sheet A [e.g. Waltham City of (MA)] for state abbreviations in parenthesis. If an abbreviation exists, match this to state abbreviations in parenthesis listed on sheet B and pull (via INDEX function) a corresponding office assignment for the given state abbreviation on sheet B.
The formula I have written is: =IFERROR(INDEX('Office Assignments'!F:F,MATCH("*"&R815&"*",'Office Assignments'!D:D,0))," ") I am getting all spaces and no offices using this formula. Can anyone point out where I have gone wrong and how to troubleshoot this? I have looked up a series of wildcard help responses, but these tend to be searching for one specific word or number, not searching an entire column for a match.
Thank you!
I am currently trying to clean up contact information at my firm. The goal is to search client names on sheet A [e.g. Waltham City of (MA)] for state abbreviations in parenthesis. If an abbreviation exists, match this to state abbreviations in parenthesis listed on sheet B and pull (via INDEX function) a corresponding office assignment for the given state abbreviation on sheet B.
The formula I have written is: =IFERROR(INDEX('Office Assignments'!F:F,MATCH("*"&R815&"*",'Office Assignments'!D:D,0))," ") I am getting all spaces and no offices using this formula. Can anyone point out where I have gone wrong and how to troubleshoot this? I have looked up a series of wildcard help responses, but these tend to be searching for one specific word or number, not searching an entire column for a match.
Thank you!
