Question
Beyond #N/A, are there other error messages that can occur when VLOOKUP doesn't find a match?
Asked by: USER1354
93 Viewed
93 Answers
Answer (93)
While #N/A is most common, you might also see #REF! if the table array is invalid (e.g., a deleted range) or #VALUE! if there's a data type mismatch between the lookup value and the first column of the table array.