• 513K Members
• 2,478 Online
• 611K 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.

# Re: Help with excel formulas

@shilpa288 , you are welcome

Related Conversations
Help with #NUM error in IRR formula
hasan ahmed in Excel on
2 Replies
Consolidating data from multiple worksheets
Machala Sentance in Excel on
3 Replies
Merge Cells with Different Data Types
CaffeineKing in Excel on
2 Replies
I need the Formual...
alanaj in Excel on
1 Replies