I have an unsorted list that is a subset of a master list. Of the entries in the unsorted list, I'd like to sort the items according to the order in the master list. I would prefer to use formulas instead of macros (I know how to create a macro to accomplish this task). Thanks.

SortByMaster.xlsx