0 of 23 lessons complete (0%)
Why is VLOOKUP not working

Vlookup #value error

This is a preview lesson
Purchase this course, or sign in if you’re already enrolled, to take this lesson.

Reasons for VLOOKUP #value error

The #Value error occurs when one of the cells referred to contains more than 255 characters. In the example below, the lookup value in A14 contains over 255 characters and the net effect is that the VLOOKUP returns a #value error.

vlookup #value error

This can happen when you are using unique references that have lots of characters. A more likely case is where you are using multiple criteria by concatenating cells to create a unique lookup value.