79703785

Date: 2025-07-16 17:17:06
Score: 1.5
Natty:
Report link

Found from a reddit post that adding &"XX" or any other text right after the second variable in Search fixes it, as such: =ISNUMBER(SEARCH(E5, Sheet2!A1:A510))*ISNUMBER(SEARCH(E8, Sheet2!B1:B510&"XX"))

Reasons:
  • Low length (0.5):
  • Has code block (-0.5):
  • Self-answer (0.5):
  • Low reputation (1):
Posted by: Jeanne Perreault