INDEX/MATCH on Blank and No Matches

Options

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

Answers