Hi Kazphillips,

See the attached file where I have used Iserror function.. thanks.
Name sample.xlsx

Regards,
DILIPandey

<click on below 'star' if this helps>