79136579

Date: 2024-10-29 09:42:22
Score: 0.5
Natty:
Report link

By checking blanks in ConsolCodes first:

=IF(ISBLANK(ConsolCodes),0, IFERROR(INDEX(Jul2024Totals,XMATCH(ConsolCodes,Jul2024Codes,0)), 0))

Result

Reasons:
  • Probably link only (1):
  • Low length (1):
  • Has code block (-0.5):
  • High reputation (-1):
Posted by: nkalvi