• 408K Members
• 7,000 Online
• 463K 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

To facilitate testing, please attach your sample Excel file.

# Re: Help with excel formulas

@Twifoo  : Apologies. Please find sample for testing.

Highlighted

# 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.

Sorry for late reply.

# Re: Help with excel formulas

@shilpa288 , you are welcome

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
16 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
11 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
217 Replies