Dealing with the

UNDERSTAND & FIX EXCEL ERRORS: Download our free pdf
www.bluepecantr...
Learn how to fix these errors: #DIV/0!, #N/A!, #NAME?, #NULL!, #NUM!, #REF! & #VALUE!/
The #N/A error is actually quite useful - especially when performing a VLOOKUP in Excel. The error tells you a match cannot be found. The video gives some examples where error might occur and shows you how to cloak it using IFERROR
------------------------

[@phist_bumpb5689]

Great Video! One thing that I just realised, which I was stuck no all-day (super basic but worth mentioning). The value you are looking for needs to live in the first column of the data source or table. I am sure there are smart ways around it but it fixed my #N/A error. Thanks for sharing your knowledge.

[@SoulFlushSF]

perfect mate! trim worked a treat and i shall be using this in the future :)

[@ChesterTugwell]

Great!

[@AssassinsAces]

Thank you so much! This really helped me formulate something that will save me so much time at work.

[@lalitsingh7923]

Thank you so much for great quality

[@ClaudioSantos99]

Great help! Thank you!

[@MohammedSaeedAwad]

very helpful , thanks alot for PDf files also

[@devanshpatel3306]

Good job , Thank you

[@ShowtimeRI]

Perfect! Thank you so very much!

[@donieoliqs2739]

Hi I have a file and all possible causes of showing N/A was checked but still showing N/A. Can I send you the file and help me on finding what's the issue with this?

[@bugatiiboutique9305]

ohhhhh very very good i love u

[@sharontan3775]

Perfect