Tabellab
Menu
Courses Guides Pricing Log in Start free

#N/A from Lookups: Trailing Spaces, Numbers Stored as Text & IFNA

Lesson 2 of 818 minLab

All lessons
  1. #DIV/0! & Safe Division: IF Tests vs IFERRORLab15 minFree
  2. #N/A from Lookups: Trailing Spaces, Numbers Stored as Text & IFNALab18 minFree
  3. #VALUE!: Text in Arithmetic, VALUE & SUBSTITUTELab15 min Pro
  4. #REF! & Broken References: Deleted Cells, Relative vs Absolute after CopyingLab18 min Pro
  5. #NAME? & #NUM!: Typos, Unquoted Text and Impossible MathsLab15 min Pro
  6. ISERROR, ISERR, ISNA & ERROR.TYPE: Classify and Count ErrorsLab18 min Pro
  7. Totals That Don't Add Up: Text Numbers, Double Counting & Check SumsLab20 min Pro
  8. Model Audit Checklist: Check Cells & Red FlagsLab22 min Pro

You are not signed in — the lab works, but your progress is not saved. Start free

Loading the spreadsheet…
← PreviousNext lesson →