In the file you downloaded look for the sheet name ‘VLOOKUP-Error-Approximate-1’
Why is the VLOOKUP’s in J8 to L8 pulling through information relating to SP010 instead of the correct SP0101?
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?
To follow along go to 5_5_2