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

Vlookup #name? error

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

Reasons for Vlookup #name? error

#Name? errors occur if you type the word VLOOKUP wrong (C14 below) or if you don’t use quotes when Excel expects it (in C15 below we need to use quotes ” ” around the Adrian word). This applies when you are referring to a particular text item. If you have a named ranged called adrian then this would work.

vlookup #NAME? error