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.