davids4500
New Member
- Joined
- Jan 14, 2023
- Messages
- 21
- Office Version
- 365
- Platform
- Windows
I have a excel spreadsheet and i need to lookup all itemcodes on worksheet "ChreosdataA", that have either "AFR" or "CCH" in column A:A, and have the words "Air Freshener" in column C. And display them in the worksheet "Corestock" in column A with no blank rows between them. Also the words are only partial matches as all codes are unique except for the prefix. I hope you can help please. David