Help with excel formulas

Copper Contributor

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

@shilpa288 

To facilitate testing, please attach your sample Excel file.

@Twifoo  : Apologies. Please find sample for testing.

@shilpa288 

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")

 

@Sergei Baklan 

Thank You. It worked for me.

Sorry for late reply.

@shilpa288 , you are welcome