0 of 23 lessons complete (0%)
VLOOKUP Exact Match

Vlookup #n/a Exercise

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

In the file you downloaded look for the sheet name ‘VLOOKUP- Error reason-1’

Simple question.

Why are the VLOOKUP’s in B14 and C14 giving an error message when student A111 clearly exists in the table?

Video instructions

To follow along go to 3_4_1


Before you watch the solution, if your answers seem incorrect consider the typical errors made and some useful suggestions:

  • Have you looked closely at the the data involved. This is a very simple error and it happens often. If you have VLOOKUP problems, first look to see if this is the issue. Then worry about the syntax and dollar signs.

Video Solution

To follow along go to 3_4_2