Vlookup approximate match error exercise

Free Preview

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

Back to: Free VLOOKUP Course > VLOOKUP Approximate Match