tupdegrove
New Member
- Joined
- Dec 22, 2020
- Messages
- 2
- Office Version
- 365
- Platform
- Windows
Need help figuring out N/A in c7, c8, and c10. Looks like it has something to do with concatenation for the search term.
Notes: Cell b2 has one leading space which is why trim() is used. No other cells have leading or trailing spaces.
Notes: I tried clean() around concatenate but it didn't help.
Notes: Cell b2 has one leading space which is why trim() is used. No other cells have leading or trailing spaces.
Notes: I tried clean() around concatenate but it didn't help.