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
- Customer Resources
- 65.2K Get Help
- 445 Global Discussions
- 143 Industry Talk
- 476 Announcements
- 5K Ideas & Feature Requests
- 84 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 488 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 301 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!