How to get rid of #notmatch in Vlookup


I am using =VLOOKUP([Production Order]@row, {Test 1 Range 1}, 20) and it works but when there is no match it has a #nomach message on the cell. I would like to remove that. How can I do that?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!