Formula help (index n match)

[pillr001]

Hi guys,

This formula is not working, how do i make it looks into the WaxMan sheet as-well, when it looks into the Mid-Summer one it works, How do make the formula look into the waxman sheet if it cannot find in Mid-summer.

Hope this makes sense please help

 

[pillr001]

This is the formula =IF(ISNUMBER(FIND("Mid-Summer",D9,1)),INDEX('Mid-Summer'!D2:D4,MATCH(1,IF(B9='Mid-Summer'!A2:A4,IF(C9>='Mid-Summer'!B2:B4,IF(C9<='Mid-Summer'!C2:C4,1))),0)))*IF(WaxMan!D2:D4,MATCH(1,IF(B9=WaxMan!A2:A4,IF(C9>=WaxMan!B2:B4,IF(C9<=WaxMan!C2:C4,1))),0))

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel-questions/1072389-formula-help.html#post5151176

Please do not post the same question multiple times.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).