using VLOOKUP to match or ignore unmatched strings
I use this formulat to look up the unique ID (3rd colum) to match those ID's. I want to be able to ignore the default NO MATCH output for those ID not matching and be able to carry the data in those columns into this sheet. (ex. instead of NO MATCH , fill columns with the same type data fields as in the MATCHED row| the data is there its just overwritten by the default NO MATCH response right now).
Is there an 'IGNORE' string to use or can i create an IFVLOOKUP 'doesn't match' the criteria to ignore and provide the data points i'm looking for?
All guidance appreciated !
=VLOOKUP($[Opportunity Num]@row, {INTAKE SFDC_SDR Deal Candidates 100K Range 3}, 2, false)
Best Answer
-
Hi,
If you just want it to return blank cell, you can add "iferror" to your formula, but the risk there is sometimes if there is an error, it will also show up as blank.
=iferror(VLOOKUP($[Opportunity Num]@row, {INTAKE SFDC_SDR Deal Candidates 100K Range 3}, 2, false),"")
Answers
-
Hi,
If you just want it to return blank cell, you can add "iferror" to your formula, but the risk there is sometimes if there is an error, it will also show up as blank.
=iferror(VLOOKUP($[Opportunity Num]@row, {INTAKE SFDC_SDR Deal Candidates 100K Range 3}, 2, false),"")
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.4K Get Help
- 364 Global Discussions
- 200 Industry Talk
- 428 Announcements
- 4.4K Ideas & Feature Requests
- 137 Brandfolder
- 129 Just for fun
- 128 Community Job Board
- 446 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!