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



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?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!