Index Match Formula Not Working

I have a customer ID table (sheet 1) with two columns, Customer ID and Customer Full Name. On a separate sheet (sheet 2), we have entered customer projects using the same column, "Customer ID". To prevent double entering and typos, I have a column on sheet 2 I have a column for the customer's full name and I use an index match formula. It works for 3 of the customers, but the other 7 values either come up as #no match or the wrong customer name, despite it being correct on sheet 1.

This is the formula I am using: =INDEX({Full Name}, MATCH([Customer ID]@row, {Customer ID}))

Can someone help me figure out why the formula works sometimes but not always?


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!