INDEX MATCH working on one sheet but not another



I have set up an example sheet with an index match formula that looks up an invoice to see if it appears on another sheet. If it doesn't it will bring back the value "New". This formula is working on the example sheet but when it is copied to the master sheet, it doesn't work . See screen shot:

Example sheet:

Master sheet:

Where the blank cells in New Invoice Helper column are, we are expecting a value of "New" to be returned as per the example sheet.




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!