Livin404
Well-known Member
- Joined
- Jan 7, 2019
- Messages
- 743
- Office Version
- 365
- 2019
- Platform
- Windows
Good evening, I'm confident this should be straight forward, but nonetheless I find myself stuck. I have a formula I'm currently using =SUMPRODUCT(--ISNUMBER(SEARCH(Special_Account,$G2))). The special account is in the image. It is the letter preceded by a space. I want it limited to just that-(two characters- the space then the letter. If I get something like H1952035 it will not highlight because the letter H is in the name range. I'm looking for one space and one letter found in the name range and nothing else.
As always much appreciated.
As always much appreciated.