Index Match - INCORRECT ARGUMENT error

System

This discussion was created from comments split from: Index/Match Formula - No Match to show Blank.

katie.mcelroy

I know this is an old post but I'm trying to do the same thing, return a blank cell if the index matches don't return the correct value but I get an incorrect argument error. My formula is below. If I remove the "" at the end it returns no match so the formula is somewhat correct. What am I missing?

=IFERROR(INDEX({Projects Tracker (intake) - Job Name}, MATCH([Job / CSP / WO]@row, {Projects Tracker (intake) - Job #}, 0)), INDEX({CSP Management Tracker - CSP Name}, MATCH([Job / CSP / WO]@row, {CSP Management Tracker - CSP #}, 0)), "")

Melissa Yamada

Hello @katie.mcelroy

It looked like your formula has 2 INDEX/MATCH logic statements. If you're trying to Index 2 different columns you might need to create 1 formula for each column.

Try this:
Job Name Column:
=IFERROR(INDEX({Projects Tracker (intake) - Job Name}, MATCH([Job / CSP / WO]@row, {Projects Tracker (intake) - Job #}, 0)),"")
CSP Name Column:
=IFERROR(INDEX({CSP Management Tracker - CSP Name}, MATCH([Job / CSP / WO]@row, {CSP Management Tracker - CSP #}, 0)), "")

Paul Newcome

@katie.mcelroy Just add another IFERROR( to the beginning.

katie.mcelroy

Thank you both for your replies. @Paul Newcome that did the trick.

Paul Newcome

Happy to help. 👍️