Formula Errors with Index match

tammyramosb

I'm trying to get an index formula to look up the employee ID and return the project they are assigned to on another sheet. The issue is that if the ID is blank, its returning the first project in the list with no ID #. I thought the IFERROR would take care of that but it isn't. Any suggestions?

=IFERROR(INDEX({Proj_Name}, MATCH([*]@row, {Primary Super_ID}, 0)), "")

Here is the formula I have ^^

Jeremy_D

You could use an ISBLANK formula to say that if the ID is blank then to produce a blank result. So it would look something like this:

=IF(ISBLANK([*]@row), "", INDEX({Proj_Name}, MATCH([*]@row, {Primary Super_ID}, 0)))