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?

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!