INDEX AND MATCH FORMULA, TO RETURN "0" WHEN THE VALUE IS "NO MATCH"

Options

Hi,

I'm trying to use the formulas both INDEX and MATCH, and trying to pull the budgeted revenue, by comparing the two project numbers in the sheets and returning the corresponding value.

See below formula:

=INDEX({Budgeted Revenue - November 2020}, MATCH([Project Number]@row, {Budgeted Revenue - Project Number}, 0))

Based on this formula,

If the project number is not present in the sheet, from where it is trying to pull the Budgeted Revenue - November 2020. It returns "NO MATCH".

How to ensure that the number 0 is returned instead of "NO MATCH".

TIA.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!