Learn Excel Episode 1121: VLOOKUP #N/A
The most common error from your VLOOKUP formula is the #N/A error. Episode 1121 looks at how to find the #N/A and then three ways of adding those new values to your lookup table.