Creating a blank value based on Criteria within an INDEX/MATCH Formula

Todd Smelser

Hi,

I have build an Index formula to return a value from a long SKU list.

=INDEX({sku list for todd Range 2}, MATCH([index Match]@row, {sku list for todd Range 3}, 0))

This formula works very well but I have entires in the sheet that should leave the field blank if the match is not met, instead of "No Match".

Is this possible?

John Pudar

Hi @TSmelser,

Try adding an IFERROR to your formula:

=IFERROR(INDEX({sku list for todd Range 2}, MATCH([index Match]@row, {sku list for todd Range 3}, 0)), "")

John Pudar

Hi @TSmelser,

Try adding an IFERROR to your formula:

=IFERROR(INDEX({sku list for todd Range 2}, MATCH([index Match]@row, {sku list for todd Range 3}, 0)), "")

Todd Smelser

That works a treat. Thanks John!

I will learn to work with IFERROR.