In the file you downloaded look for the sheet name ‘VLOOKUP- Error reason-1’
Why are the VLOOKUP’s in B14 and C14 giving an error message when student A111 clearly exists in the table?
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.
To follow along go to 3_4_2