An curved arrow pointing right. Once you have mastered VLOOKUP in Excel it's time to move on to INDEX/MATCH. This formula combination gives the same results but without the problems of VLOOKUP.

More specifically, VLOOKUP's approximate match (indicated by TRUE in the formula) searches down the lookup array until it finds a value that's larger than the lookup value. It then returns the ...

If you leave the final argument blank or type TRUE, VLOOKUP will accept approximate matches. However, the approximate match can be too lenient, particularly if your list is not sorted. As a ...