IFERROR for VLookup

Matthew.Poole147

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

Shubham

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

Shubham

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

Matthew.Poole147

Hi Shubham,

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

Cheers,

Matt