There are many ways to sort data in Microsoft Excel, and one of the simplest and most convenient is the SORTBY function. It ...

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.