Hello,
I have the following formula -
=IF(AND(OR(D2='Vitasheet - HIPS Mixed'!$E$7,D2='Vitasheet - HIPS Mixed'!$E$8,D2='Vitasheet - HIPS Mixed'!$E$9),G2='Vitasheet - HIPS Mixed'!$E$10),COUNT(M$1:M1)+1,"")
Where it shows G2='Vitasheet - HIPS Mixed'!$E$10 I want it to look at $E$11 as well.
I've tried the below formula but it doesn't work. Any ideas how to do it?
=IF(AND(OR(D2='Vitasheet - HIPS Mixed'!$E$7,D2='Vitasheet - HIPS Mixed'!$E$8,D2='Vitasheet - HIPS Mixed'!$E$9),G2='Vitasheet - HIPS Mixed'!$E$10,G2='Vitasheet - HIPS Mixed'!$E$11),COUNT(M$1:M1)+1,"")
Bookmarks