Back to the Vlookup Menu
Back to the related video
Getting Rid of the Vlookup #N/A Error Code
When the vlookup function doesn’t find the value inside the range specified, it will write the #N/A code, meaning “Not Available”.
To get rid of this error code, you can put the vlookup inside an IF function together with the ISNA function in the following format:
=If (isna (vlookup(blabla)) , “”, vlookup(blabla))
If the vlookup function is N/A, then leave the cell blank, otherwise perform the vlookup function.
(It is recommended that you be familiar with the If Statement before you proceed.)
An Example (taken from the related video):
(Note the double parenthesis after the word “false” in both of its occurrences)
Let’s cut the above function into three parts, and examine them one by one:
If the function vlookup(D9,oldList,2,false) gives N/A - (this will happen if it didn’t find the value of cell D9 inside oldList),
Then leave the cell blank (double quotation marks mean “blank”)
Otherwise perform the vlookup as usual.