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
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
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 422 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 143 Just for fun
- 59 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!