To handle error #N/A In Microsoft Excel, when use
VLOOKUP function searches for value in the left-most column of
table_array and returns the value in the same row based on the
index_number.
One problem that can occur is when there is not a match so it returns N/A. Here is an example: