Remove #NO MATCH return from VLOOKUP query
Options
SYSPK
✭✭✭✭✭✭
Is there a way to make a cell blank if there isn't a match? I know I can do an IF statement where IF the value I'm trying to match doesn't appear in the table at all, do nothing, otherwise VLOOKUP. But seems like that may slow the sheet down because it's looking through that table twice, so doing twice the work.
Is that not true? Is there a simpler way?
Thank you
Tags:
Comments
-
You can wrap your formula in an IFERROR function.
=IFERROR(Your formula, "")
-
PERFECT thank you.
-
You're welcome! If at any point you want to change that blank cell into a message or point of instruction, just add text between the " marks.
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!