Lookup Formulas Training Series – Lookup Formula Errors (2 of 3)

The Lookup Formulas Training Series Part 2:

How to Prevent & Handle Lookup Formula Errors

Download the file used in this video:

Common Lookup Formula Errors.xlsx (27.6 KB)

Lookup Formulas Training Series

Video 2

Lookup Formula Errors:
How to Prevent Critical Errors


Which Error Do You Get Most Often?

Please leave a comment below with your answer, and any questions.  Thanks!​

  • 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?

  • 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?


  • 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.

  • 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.

  • >