Formula help (index n match)

Status
Not open for further replies.

pillr001

New Member
Joined
Sep 28, 2018
Messages
24
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 :confused::confused:
 

Some videos you may like

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.

pillr001

New Member
Joined
Sep 28, 2018
Messages
24
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))
 
Status
Not open for further replies.

Watch MrExcel Video

Forum statistics

Threads
1,109,073
Messages
5,526,657
Members
409,713
Latest member
roman9980

This Week's Hot Topics

Top