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!
Greate job sir,
#N/A error is most common usually because value is missing or has wrong format (e.g. text)
Thank you again. Brilliant.
Thank you! Excellent! I am not scared of excel any longer!
N/A errors because I didn’t know how to anchor my table array in the past. Thanks
#REF because array columns get deleted or rearranged. Thanks for the tips!
#n/a error
thanks for your video
Most common is #N/A but also #VALUE is another I encounter quite often.
Now I know what to look for thanks to your video……great work Jon
#N/A
I seem to have issues with numbers being exported into a spreadsheet and dropping the leading or trailing zeros. Is there a way to fix that?
#n/a error
Very useful video. Thanks Jon
thank you jon it is very useful information to learn and resolve the issue from errors.
Excellent tips!
Sometimes my vlookup returns the formula itself instead of a value. Can you explain why and how to fix that?
Jason
N/A
This is great, thank you! Easy to understand and very thorough. I get a lot of #N/A errors when working with my clients’ database (mostly different spellings, extra space) plus, as you mentioned, numbers (used as unique IDs) are often exported as text by different platforms. I incidentally learned about F2 and pressing TAB when entering a function – I’ll be using those shortcuts a lot.
This video is so informative and I love the specific instructions on how to a alleviate these errors.
N/A
I learned a lot !
I am so exited to learn from this video.
Very informative.
Have had all, but #N/A mostly due to mismatch between text & numbers.
#Ref
The most common is the #N/A
I am dealing with a #REF error. It says there sheet I’m pulling from doesn’t exist but I can click on edit link and get to the document that says it is not valid. I’m currently checking to see if it has to do with the format of the cell but it worked yesterday and today it won’t. I’ve checked names, location, made sure no one changed the file, etc.