a formula to match dates and words

[sam__gleeson]

Hi

In sheet5 E21 i require a formula which looks at sheet4 C5 date and if the date matches sheet5 E20 date It looks at sheet4 B7 and if it sees a word "work hours - day" it places the figure from Sheet4 C7 in Sheet5 E21.....

Thanks

 

[vogel997]

Try this

'Formula in Sheet 5 E21 -- > =if(sheet4!c5=Sheet5!e20,if(sheet4!b7="work hours - day",sheet4!c7,""),"")

 

[sam__gleeson]

Thank you