Aug 08 2019 02:41 AM
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.
Aug 08 2019 02:52 AM
To facilitate testing, please attach your sample Excel file.
Aug 08 2019 03:12 AM
@Twifoo : Apologies. Please find sample for testing.
Aug 08 2019 02:15 PM
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")
Aug 20 2019 07:12 AM