msharma864512
Member
Hi I am trying to combine Nested IF with Index Match formula.
I have ranks of a list of companies and on the basis of their ranks, their categories have been defined (First 25% as Out performers, 25% to 75% as Avg Performers, and so on)
Details are in the attachment
I have already created a formula for whole data set, but now i want the category to be defined by sectors
Minimum and Maximum Rank is different in all the sectors, details are in excel
For e.g if we are designating the Rank to Technology company, then it should use the cell "AB3" to compare with minimum and maximum,
if we are categorizing Oil & Gas companies, then it should use the cell "AB7" to compare.
Please help me with this, formula has to be written in column V
I have ranks of a list of companies and on the basis of their ranks, their categories have been defined (First 25% as Out performers, 25% to 75% as Avg Performers, and so on)
Details are in the attachment
I have already created a formula for whole data set, but now i want the category to be defined by sectors
Minimum and Maximum Rank is different in all the sectors, details are in excel
For e.g if we are designating the Rank to Technology company, then it should use the cell "AB3" to compare with minimum and maximum,
if we are categorizing Oil & Gas companies, then it should use the cell "AB7" to compare.
Please help me with this, formula has to be written in column V
Attachments

217.1 KB Views: 5