If Error Vlookup multiple sheets

This is the formula i am using now.

=IFERROR(VLOOKUP([Co#]@row, {Master Accounting Tracker 2022}, 4, false), VLOOKUP([Co#]@row, {Master Accounting Tracker Range 2}, 4, false))

How can I make this return a blank instead of #NO MATCH? Also, can you attach a third sheet to search if first two are errors?



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!