79355905

Date: 2025-01-14 17:50:45
Score: 3
Natty:
Report link

The answer was a combination of comments from Tim Williams and BigBen. What was being searched for was a part number and there are descriptions for each part, one of which included mention of the part causing the issue. Using LookAt:=xWhole to look for cells containing exactly and only the search string solved the problem. Thank you!

Reasons:
  • Blacklisted phrase (0.5): Thank you
  • No code block (0.5):
  • Self-answer (0.5):
  • Single line (0.5):
  • Low reputation (1):
Posted by: Josh Carr