• 550K Members
• 3,571 Online
• 659K Conversations

Highlighted
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
Highlighted

Highlighted

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

Highlighted

# Re: Help with excel formulas

@shilpa288 , you are welcome

Related Conversations
Printing underlines
Gary7777 in Excel on
2 Replies
Date Format in Pivot Tables
KimbersHulme in Excel on
1 Replies
Question One: Protect Format & Two: Formula
Richard_James in Excel on
0 Replies
Excel question.
skbp1970 in Excel on
6 Replies