• 466K Members
• 10.4K Online
• 564K Conversations

New Contributor

# 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

# Re: Help with excel formulas

@Twifoo  : Apologies. Please find sample for testing.

# Re: Help with excel formulas

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

# Re: Help with excel formulas

Thank You. It worked for me.

Highlighted

# Re: Help with excel formulas

@shilpa288 , you are welcome

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies