INDEX/MATCH on Blank and No Matches

Hi all,
Working on using Index/Match to pull through a Single Select Dropdown (Y or N) if the corresponding PO exists. As standard, I'm using IFERROR to populate to ensure if there are errors it shows a more user friendly message.
=IFERROR(INDEX({QC sheet Range 1}, MATCH([Product PO#]@row, {QC sheet PO Number}, 0), "Task Not Complete"))
However, this gives an incorrect argument message. I'm guessing its because some of the rows on my source sheet for the dropdown column (QC Sheet Range 1) are blank and not Y or N.
With the additional issue if there is no PO to match.
I'm guessing I need to replace my IFERROR with an IF and NOT BLANK formula?
Thanks,
Jack
Best Answer
-
Your syntax is off. The "Task Not Complete" portion is actually set in the column_number portion of the INDEX function, and you don't technically have an output established for the IFERROR. Take one of the closing parenthesis from the end and move it to before the comma prior to "Task Not Complete" to close out the INDEX function first.
Answers
-
Your syntax is off. The "Task Not Complete" portion is actually set in the column_number portion of the INDEX function, and you don't technically have an output established for the IFERROR. Take one of the closing parenthesis from the end and move it to before the comma prior to "Task Not Complete" to close out the INDEX function first.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives