Excel Forum
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

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.