Excel Forum

Remove #N/A Error Result from Empty VLOOKUP() Formulas

This video tutorial will show you how to remove the #N/A error that results in a cell with a VLOOKUP() formula that has no corresponding value. This uses a simple IF formula to simply leave a cell blank if there is no VLOOKUP() value for the cell. This will teach you how to include a VLOOKUP() formula within an IF statement to remove the #N/A value.
   Topics Covered
Remove the #N/A Error from Empty VLOOKUP() Formulas
Use a VLOOKUP() Function within an IF Statement
ISNA() Function
   Difficulty:         Intermediate
   Video:               Yes

Got a Question? Ask it Here in the Forum.