The Lookup Formulas Training Series Part 2:
How to Prevent & Handle Lookup Formula Errors
Lookup Formulas Training Series
Video 1
Intro to VLOOKUP:The 5 Must Know Essentials
Video 2
Lookup Formula Errors:How to Prevent Critical Errors
Video 3
INDEX & MATCH:An Alternative to VLOOKUP
Which Error Do You Get Most Often?
Please leave a comment below with your answer, and any questions. Thanks!
Great tips. I’ve been learning a lot about EXCEL. Thanks Jon!!
Enjoyed it. keep up a good work
Am just learning so nothing to use it for now but hopefully in the near future
Thanks million for your kind for the sharing knowledge
Awesome, I don’t have any idea, such each error means and how easily we can solve it and learn a new formula of TRIM as well. 🙂
Thankyou!
Excel tips. It is helping me a lot. Jon is a very good teacher. EXCELLENT.
Very Nice and very helpful for me in my office work. Thank you so much
Thanks a lot Jon,the videos are very helpful !
Dear Jon
Thank for this error handling video and I did not know the error type and how to solve them. Now, It clears to me.
TRhx for the video and the cheat sheet, where I’ve seen you using the CLEAN function to remove non-printable characters from a text string and makes the VLOOKUP search more reliable and any errors easy to debunk!
Thanks John
That’s great Jon. I have really learnt a lot this week with your handling of the Vlook up topic. I am done with the second video and look forward for the third video on Index & Matches.
Great work done. Bravo
Great tips.
The most common error I received is #N/A. As you mention in the video, the drop-down in Excel isn’t able to advise on how to resolve the error.
I see the #N/A error most often and have been able to deal with it, but I always learn something new after watching your videos. Thank you so much!
Thanks Jon, really well structured training guide – makes it easy to understand the base principles and use it in a much wider aspect. Look forward to Part 3.
Great tips! Look forward to part 3!!!
Thank you so much for sharing. Great video! Love excel! Teach me more!!
Hi Jon,
Your video explained and resolved some secrets I had for over 15 years! You go boy!!! Going forward I can’t miss any of your teachings whether I know the subject or not because there is always something I can learn.
DEAR JON
EXPLANATIONS IN VIDEO VERY GOOD AND MY EASY UNDERSTANDING, AND VERY HELPFUL IN MY WORK, ACKNOWLEDGED
THANK JON!!
#N/A is the most common error. But you did not talk about one error that occurs often, that is when spreadsheet maintain the formula instead the result. Thanks.
#N/A
The most common error I experience is the N/A Error.
The information you provide was great and will help me in keeping my spreadsheet clean and professional.
The most regular error I come across is #Ref.
Really enjoyed your explanation. I usually find that when training it is the most sought after area all want to know about.
#N/A
#N/A. Thanks Jon!
#N/A of course 🙂
#N/A
#N/A.
Jon u make a best tutor. Videos are excellent for understanding.
#N/A is my most commmon error.
very usefull.
thanks
Thank you for making Excel more useful.
Jon,
You are wonderful to have your knowledge shared with people who are interested in learning. Really appreciated! Many Thanks to you!
I receive N/A errors most often. I knew about iferror function; however, I learned a good tip to not wrap formulas initially with it. Thanks.
Jon, Thank you for the way you simply explain the how and whys these happen as well as the solutions, I’ve had them all at some point and others have corrected the formula without or improper explanations. Thank YOU!
The most common error I get is NA.
Hi Jon, thanks again for sharing. from Part 2 I have learnt how to identify errors and how to prevent in a future exercises or how to handle them using “iferror” and LEN very helpful and time saving.
#N/A
Thanks for the video.
I don’t normally use v-lookups, but your video regarding errors you might come across was fantastic.
I’m sure in the future I will use them more due to your videos.
Thank you so much. Great teacher.
Easy to understand within a short time and very useful. thanks for sharing.
Great! Thank you.
#N/A, I knew what was causing it, but I didn’t that I could type a replacement comment. this is great. Thank you
#NA and #Value are the two I most deal with #Value because I usually use an If(ISBLANK(A1), “”, SomeFormula) and then when I reference the cell that has the value “” it turns out that it is TEXT not a VALUE of zero. Most of the time that I use this I don’t want to show values of ZERO in the cell as it clutters up the look. So now I know to use IFERROR in the subsequent calculation to show a result of zero or “” in the subsequent cell if I don’t need to show anything.
Same goes for a formula that might divide by zero.
Thanks for the explanation!
I think leading or trailing blanks after a mega data extract are the most common problem I see.
I see the #N/A which is either no value found or there is tear. Which happens a lot in the files I work. I have enjoyed all the videos and can’t wait to view more!
#n/a where I have blank cells – then use iferror to return empty cell
The error I see most often is N/A
The NA error. This was very helpful, thank you.
#N/A is very common, but I also get #REF error on excel sheet normally even not using Vlookup formula.
Lookup Elvaluates to an out of bong Range