Index Match Formula Not Working

swaldon2

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?

Carson Penticuff

Give this a try:

=IFERROR(INDEX({Full Name}, MATCH([Customer ID]@row, {Customer ID}, 0)), "")

Carson Penticuff

Give this a try:

=IFERROR(INDEX({Full Name}, MATCH([Customer ID]@row, {Customer ID}, 0)), "")

swaldon2

@Carson Penticuff That worked perfectly, thank you so much!

Carson Penticuff

Glad to help!