Remove #NO MATCH return from VLOOKUP query

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

Mike Wilday

You can wrap your formula in an IFERROR function. 

=IFERROR(Your formula, "")

• https://help.smartsheet.com/function/iferror

SYSPK

PERFECT thank you.

Mike Wilday

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.