=IF( formula with Vlookup feature

[arsalas007]

I have a formula that works if a cell (Percentage) is a certain number and it will calculate a grading system based on that number. As exampled below:

=IF(CQ8<='DATA CALCS'!$M$16,"1 STAR",IF(AND(CQ8>='DATA CALCS'!$L$15,CQ8<='DATA CALCS'!$M$15),"2 STAR",IF(AND(CQ8>='DATA CALCS'!$L$14,CQ8<='DATA CALCS'!$M$14),"3 STAR",IF(AND(CQ8>='DATA CALCS'!$L$13,CQ8<='DATA CALCS'!$M$13),"4 STAR","5 STAR"))))

However, I need the formula above to work, also, if another cell has a particular category, say (District)...

So, If Cell A2 = Orlando and Cell C2 = 62% I want cell G2 to say "2 Star"
and, If Cell A5 = Portland and Cell C5 = 48%, I want cell G5 to say "1 Star"..

Is there any easy way to add a lookup formula to the above mentioned formula to "add" in the extra criteria?

Thanks!
R.S.

 

[pbornemeier]

It is not clear how the second and third formulas relate to the first or each other.

I believe I would create a lookup table that had the scores in the leftmost column and the district names in the top row. The "# STAR" values would be in the intersections of the table.

Use the MATCH function on Column A vs. the District name range to determine which column to return in the VLOOKUP function avainst the table above based on the score in column C.

 

[arsalas007]

That works, thank you!!!