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?

Improve company productivity with a Business Account.Sign Up

x
 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.