No Match...but the formula works
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!
Best Answer
-
All the 1s that you have in the third portion of each MATCH function should be 0s.
Answers
-
All the 1s that you have in the third portion of each MATCH function should be 0s.
-
Huh, so simple and it fixed it! thank you!
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 464 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!