Hi from A15 : A27 this is the list with drop downs and dropdown are Priority level , and i have priorities. In K5 . i want to get value from list if list from A15 : A27. If list have any At risk , in K5 it must show At risk dont need to check other cells , if list doesnt contain At risk it must check Delayed , if any cell has delayed it must show delayed , no need to check others, then it need to check On-Track , Yet to start . For Complete if all are complete it need to show complete . I wrote some code but it is not working =IF(VLOOKUP(J5,B15:B27,1,0)="At Risk","At-Risk", IF(VLOOKUP(J6,B15:B27,1,0)="Delayed","Delayed", IF(VLOOKUP(J7,B15:B27,1,0)="On-Track","On-Track","x "))) can anyone help me?