Forum Discussion
Help with excel formulas
Hi,
I have attached 3 sheets in word doc . I have very simple one conditions that goes in main sheet column D8
1. =IF(AND(Sheet2!$E$2:$E$10000<=0.01,Sheet1!$E$2:$E$10000>=0.01),1,0)
Issues I am getting is : I have to compare Roomids, Day Name and time slot to put correct values.
How to match Roomids, Day Name and time slot in Sheet 1 and Sheet2 to Main Sheet and put the above formula?
Sheet 1 and Sheet2 have similar pattern.
5 Replies
Perhaps
=IFERROR( (INDEX(Sheet1!$E:$E,MATCH(1,INDEX((Sheet1!$A:$A=$B8)*(Sheet1!C:C=D$5)*(Sheet1!$B:$B=$C8),0),0))>=0.01)* (INDEX(Sheet2!$E:$E,MATCH(1,INDEX((Sheet2!$A:$A=$B8)*(Sheet2!C:C=D$5)*(Sheet2!$B:$B=$C8),0),0))<=0.01), "no such")
