No Match...but the formula works

H.Woods

Can someone help me with this? I have a formula which works but it's finding NO MATCH for two lines but I don't know why as the formula has no problem finding a different line on the same sheet…

This is the formula:

=IFERROR(IFERROR(IFERROR(INDEX({IQA Log Record Closed?}, MATCH([Primary Column - IQA Ref]@row, {IQA Log IQA Ref No}, 1)), INDEX({Daily Quality Inspections Record Closed?}, MATCH([Primary Column - IQA Ref]@row, {Daily Quality Inspections IQA Ref No}, 1))), INDEX({Re-Make Log Record Closed?}, MATCH([Primary Column - IQA Ref]@row, {Re-Make Log IQA Ref No}, 1))), INDEX({CNC Mistakes Log Record Closed?}, MATCH([Primary Column - IQA Ref]@row, {CNC Mistakes Log IQA Ref No}, 1)))

The sheet and range in question is the "Daily Quality Inspections ***"

Any help would be appreciated!

Paul Newcome

All the 1s that you have in the third portion of each MATCH function should be 0s.

Paul Newcome

All the 1s that you have in the third portion of each MATCH function should be 0s.

H.Woods

Huh, so simple and it fixed it! thank you!

Paul Newcome

Happy to help. 👍️