I have 25 products listed from H3 to H27 in sheet1. For those each 25 products I have last 12 months sale details from column I3 to T27 which will be pulled from sheet2 using vlookup. In I2 to T2 i have listed those 12 months name using a formula.

Now on column U3 to U27 I need rating for all those 25 products for each month. I have a dropdown on A1 which will get months from cell I2 to T2. Once I click a month for example Jun-16 I need to update rating for all the 25 products for that particular month on column U. Rating should be from highest to lowest (Eg. if maximum sale is 150 it should be Ranked 1 if 10 is the least sales it should be Ranked 25.

Please suggest any formula to resolve my issue. Thanks!!