using VLOOKUP to match or ignore unmatched strings

Options

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

  • Marcelle Conradie
    Marcelle Conradie ✭✭✭
    Answer ✓
    Options

    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

  • Marcelle Conradie
    Marcelle Conradie ✭✭✭
    Answer ✓
    Options

    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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!