Hi everyone.

I'm working on making a calander in excel that can sort data to show when a project will take place, and I feel as if I've gone about this the wrong way as it's getting complicated and it's not a flexible method.

An example of the sorting code is =IF(AND($F$3=E$14,$E$3=E15,$C$3="North"),$B$3,IF(AND($F$4=E$14,$E$4=E15,$C$4="North"),$B$4,IF(AND($F$5=E$14,$E$5=E15,$C$5="North"),$B$5,IF(AND($F$6=E$14,$E$6=E15,$C$6="North"),$B$6,IF(AND($F$7=E$14,$E$7=E15,$C$7="North"),$B$7,IF(AND($F$8=E$14,$E$8=E15,$C$4="North"),$B$8,IF(AND($F$9=E$14,$E$9=E15,$C$9="North"),$B$9,IF(AND($F$10=E$14,$E$10=E15,$C$10="North"),$B$10,IF(AND($F$11=E$14,$E$11=E15,$C$11="North"),$B$11,"")))))))))

Even though this seems to work, it can only show 1 result, but I have situations where there are more than 1 scenarios meeting the condtions. I've attached the file so this can make sense.

Many thanks

Project Calander.xlsx