# 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.

• ✭✭✭✭✭✭
Options

You'd use the IFERROR function to change what is shown.

Something like this.

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

Did that work/help?

I hope that helps!

Have a fantastic day & Happy New Year!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

SMARTSHEET EXPERT CONSULTANT & PARTNER

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

• Options

Works, perfect.

• ✭✭✭✭✭✭
Options

Excellent!

You're more than welcome!

SMARTSHEET EXPERT CONSULTANT & PARTNER

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!