aab

I'm trying to write a multiple if(or statement with three data points. IF(OR(AA11046="AAA",OR(AA11046="AAB",OR(AC11046="YES"))),"YES","NO") Brings back "no" no matter what. I'm trying to say if the points are aaa and aab and yes then give me yes. all others should be no. Any help is...

Not sure what formula to use. Currently I am using index match but whilst it is returning a result it is not quite returning what I want. I have a table which contains the following info: <tbody> Staff Reg 1 Reg 2 Reg 3 Reg 4 AAB 7.1/Rg SAH 7LA/Rg 7LB/RG 7.1/Rg MAH 9.7/Rg 9BW/RG...

I need to sum Programs (C6:F88) by color and by object class (B6:B88) I can do the two separate functions: =SUMPRODUCT(--(LEFT($B$6:$B$88,3)="AAB"),C6:C88) and =sumbycolor(C15,C10:C88) but I can't figure out how I can do both. Pretend my example table had fill colors instead of text color...

I have excel sheet which contains the data as (dummy data). <tbody> Code School Employee 123 AAB xyz 123 AAB MNO 123 AAB ANO 323 CCB Jam 323 CCB Yoi </tbody> On the second sheet I have same columns. by using vlookup I got the results of School. So i want to get the drop list in...