INDEX/Match, to not display "#NO MATCH"

Options

=INDEX({ Range 1}, MATCH([Column0]19, { Range 2}, 0))


How can I get this to NOT display "#NO MATCH" if there is no match?

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!