79158266

Date: 2024-11-05 08:45:41
Score: 4.5
Natty:
Report link

same issue =>

=IF(SEARCH("[C1]";D40;1);XLOOKUP("[C1]";Sheet3!A:A;Sheet3!B:B;;2);IF(SEARCH("[TFS]";D40;1);XLOOKUP("[TFS]";Sheet3!A:A;Sheet3!B:B;;2)))

the values on C1 are ok. the values on TFS return #VALUE!

the mapping I am using in excel is: enter image description here

Reasons:
  • Blacklisted phrase (1): enter image description here
  • RegEx Blacklisted phrase (1): same issue
  • Low length (0.5):
  • No code block (0.5):
  • Self-answer (0.5):
  • Low reputation (1):
Posted by: Akis Athanassiadis