I am trying on returning the rank of individuals based on the sales in a specific month. On the attached 1B - E are the ranks, with anything below 4's minimum returning a 5; column A are the months 1-12 and, B2-E13 are the minimum sales necessary for the specific rank.
I am assuming I should be using match, but I seem to be totally stumped on how to approach this. SalesGrid.xlsx