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!
Thanks Jon, very informative and clear. I appreciate the videos and look forward to more. I have gotten all of the errors, although I think the one I have seen the most is #N/A
Great Video – #N/A error is the most common error that I ran into in excel. Also very interested to know when the 3rd video will be ready. These videos are a great help. Thanks
The most common error i see is the #N/A which many times i expect. i love the IFERROR function for those times when i know the values i’m looking for are inconsistent.
We have to deal with the type mismatch between numbers and text quite a bit. The IFERROR function will be very useful.
I use VLOOKUP to compare reports of same data from different sources. Therefore, #N/A is my most common error.
The most common error is #N/A as I use vlokup to compare data
The most common error is #N/A as I use vlookup to combine data
Errors I encounter every now and then. Well explained.
Well Explain.
Appreciate you support if you explain If Formula.
Regards,
Great video and very helpful. The most common is the #NA error. The Iferror will come in helpful.
Another great tutorial Jon,
#N/A is the most common error I encounter but now thanks to you, not anymore. Who would have thought dealing with errors was that easy!
Looking forward to the next video.
Thanks again Jon.
Thank you Sharon! 🙂
Thank you Jon, very informative / clear and look forward for more videos.
Excellent Video and very helpful! Thank you so much, Jon!
loved the video. Very helpful!!!
Thanks!
loved the video. Very helpful!!!
Thanks!
N/A Error
Thanks Jon, appreciate the videos on correcting #NA and #REF. Informative and well explained.
Thank you Joseph! 🙂
thank you very much sir.
N/A – thanks again for this clear video! Can’t wait to watch Index/Match. It helps a lot!
Could we have nested the trim function inside the vlookup?
Great video Jon, your explanations are excellent for learning Excel! Thanks so much!
thanks a lot… Videos are really good… Gr8…anything related to excel come in mind I remember you only….
Can you send graph videos using primary, secondary axis….
My most common Vlookup error is the NA. Thanks to you no more.
Thank you so much for this video, very helpful
Hi Jon,
Thank you very much for providing an understandable Excel tutorial that helps us a lot in our report generation and how to address the errors encountered.
Looking forward to your future Excel videos.
Kind regards,
Anne
Most common error I get is #N/A often due to reports downloaded into Excel from Oracle which formats the numbers as text.
#N/A without a doubt. Many Thanks for the informative video
Like pretty much everyone else, #N/A is the most common error I get in VL. Moving forward I’m going to take a little more time in investigating WHY I’m getting that error rather than just assuming that my range did not contain the look-up value. And I love the IFERROR for when I’m sure that’s the only reason why!
#N/A is the most common error. Thank you Jon for the presentation. It is informative to know differnt type of errors. I might not have noticed the message is different, as they were all considered as errors and needed to be fixed. I have learned to investigate other causes of errors. Thanks again.
N/A & #ref error while doing the comparison statement.
Well done. The error that I always have is numbers stored as text.
Thanks Andy , Found it very informative, great tip on trailing and using the trim function.
Thanks John. I found the video very informative. I like that I can also download the supporting spreadsheet so I can refer back to it. My most common is is both: #N/A and #REF.
Thanks Jon this lookup video was very explanatory, I am finding excel really exciting all thanks to you Jon.
Hi Jon,
Thank you very much for providing an understandable Lookup error handling.
Meanwhile, I a workbook that keeps track of fleet inventory. It has a RATE sheet which consist different clients rates based on type of lorries and destinations. On the LOG Sheet where I populate the activity within a month, I have a Rate column that I automated with Vlookup but I’m not geeting desire result.
What the statement is doing is to dertemine which client, lorry type and destination and populate actual Rate. How can I achive this?
Hint: Can If statement and Lookup statement be combained together.
2. Kindly, make provision to upload an excel problem on this blog page.
Thanks very much it is clear,easy understand and helpful. Appreciate it.
Thanks for covering these errors, and I have seen these before and just worked my way thru or around them without fully understanding them. Now I feel like I know how to troubleshoot these better!
Thanks a lot! That is quite helpful. Appreciate this. Keep up the good work!
#N/A is by far the most common error that I get. Great job explaining how to fix! Thank you Jon, you Rock!
Very well explained. #N/A is my most common error. Great idea about the IFERROR as well.
VERY HELPFUL VIDEO, I´M LEARNING MUCH FROM THE WEBSITE, THANKS FOR SHARING THE KNOWLEDGE. SALUDOS!
My most common lookup error is #N/A where the lookup value is text and I’m looking up numbers.
Great video – thanks.
Jon, your teachings are so clear – I appreciate them so very much. My most common error is #N/A
Indeed thanks so much your effort you put into the video, really that make original boring Vlookup syntex and its argument become more vivid and easier to remember, so that it engraves in our heart and mind to make further use of function, for example in a VBA
You did make learning really coem to life, we love the carton, that make pour lessons more fun,relief adn enjoyable instead giving everyone a hard time to remember those hard code language,which is asily forgotten.
Jon, your explanations are spot on and very clear to follow along.
I mostly encounter #N/A error, but when this occurs for me, I typically expect that result in my vlookup.
I get the #N/A error, however, in the spreadsheet I use most, the #N/A is valid. What I thought was very helpful is that I can change the #N/A error can actually be named. I really like that feature.
Also, I am very new to VLOOKUP and these videos are great in learning how to use this function.
Thank you
Jon, This was a great explanation of the different error types in Vlookup formulas. I typically had the #N/A errors.
I have N/A errors a lot because the values are not found.
These are great tips! Thanks a lot
Hi Jon,
#N/A is the most common. I refresh data from external sources and third party colleagues add their own bit usually in the opposite format e.g. text cum value.