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

Vlookup approximate match error 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-Approximate-1’

Simple question.

Why is the VLOOKUP’s in J8 to L8 pulling through information relating to SP010 instead of the correct SP0101?

Video Instructions

To follow along go to 5_5_1


Before you watch the solution, have a look again at the sort order of column A. Does it make sense to you?

Video Solution

To follow along go to 5_5_2