Return a rank based grid data

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
uadAsked:
Who is Participating?
 
Martin AndrewsConnect With a Mentor Commented:
This version works without need to modify your table
SalesGrid_v3.xlsx
0
 
Martin AndrewsCommented:
This should help you get started.  Note that because of the match function if the value equals your table it will downgrade the rank (which is likely not what you want).  If you can update your table, however, by decrementing each one you'd get around that.
SalesGrid_v2.xlsx
0
 
uadAuthor Commented:
Works perfectly.
0
 
Martin AndrewsCommented:
Great.
0
All Courses

From novice to tech pro — start learning today.