Skip to content
  • Try Smartsheet

    • Smartsheet Basics

    Smartsheet Basics

    Ask questions about the core Smartsheet application: Sheets, Forms, Reports, Dashboards, and more.

    IFERROR for VLookup

    ✭✭
    in Smartsheet Basics

    Hi,

    My understanding of formulas is very limited.

    I have a basic Vlookup and I want the #NOMATCH to instead show as a '0' or an 'X' symbol (given I am using the tick, hold, x symbols).

    My current Vlookup is =VLOOKUP([UNIT CODE]@row, {CPA Marking list Range 1}, 10, false). Can someone help amend this so the outcome of #NOMATCH will show as a '0' or 'X' symbol.

    Many thanks,

    Matthew

    · Share on FacebookShare on Twitter

    Best Answer

    • ✭✭✭✭
      Answer ✓

      Hi Matthew.Poole147

      I hope you are doing well

      According to your requirements you can use this formula & if you will need “0” place of any error use this one

      =IFERROR(VLOOKUP([UNIT CODE]@row, {CPA Marking list Range 1}, 10,false),"0")

       

      If you will need “X” place of any error, use this one

      =IFERROR(VLOOKUP([UNIT CODE]@row, {CPA Marking list Range 1}, 10,false),"X")

       

      I hope this will help you, Have a Good Day.

      Thanks

      Shubham Umale, Smartsheet Engineer, Ignatiuz Software

      · Share on FacebookShare on Twitter

    Answers

    • ✭✭✭✭
      Answer ✓

      Hi Matthew.Poole147

      I hope you are doing well

      According to your requirements you can use this formula & if you will need “0” place of any error use this one

      =IFERROR(VLOOKUP([UNIT CODE]@row, {CPA Marking list Range 1}, 10,false),"0")

       

      If you will need “X” place of any error, use this one

      =IFERROR(VLOOKUP([UNIT CODE]@row, {CPA Marking list Range 1}, 10,false),"X")

       

      I hope this will help you, Have a Good Day.

      Thanks

      Shubham Umale, Smartsheet Engineer, Ignatiuz Software

      · Share on FacebookShare on Twitter
    • ✭✭

      Hi Shubham,

      Thank you very much for your help with this. The IFERROR formula works perfectly.

      Cheers,

      Matt

      · Share on FacebookShare on Twitter

    Sign in
    Try Smartsheet

    Quick Links

    Categories

    Trending in Smartsheet Basics

    Help shape the future of Smartsheet.
    Share your ideas and feature requests.

     Watch video