formula help

[pillr001]

Hello,

I can't figure out what's not working with this formula,

For example this is the formula below. When I try and look into the WaxMan sheet it is returning 'FALSE' but when I do the mid-summer one it returns the value i'm looking for, both mid-summer and waxman sheets are identical, so something is wrong with the formula string.. can someone please advise. I think the bit in red is where it's going wrong, basically IF i cannot find what i want in the mid-summer one i want it to look into the waxman sheet

{=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),INDEX(WaxMan!D2:D4,MATCH(1,IF(B9=WaxMan!A2:A4,IF(C9>=WaxMan!B2:B4,IF(C9<=WaxMan!C2:C4,1,0))))))))))}

[TABLE="width: 411"]
<tbody>[TR]
[TD]Hi-Tech 285w[/TD]
[TD="align: right"]13/04/2018[/TD]
[TD] WaxMan[/TD]
[TD="align: center"]FALSE
[/TD]
[/TR]
</tbody>[/TABLE]

 

[pillr001]

That does not seem to be working, I've uploaded it to google docs.. if someone could fix this I would be much appreciated.

As you can see on the google docs, when i change to wax-man its just returning false?


https://docs.google.com/spreadsheets/d/1DD4vivn6dvdjXaauHO6avF6Q69yC-l_UFLux7pCd_-s/edit?usp=sharing

 

[pillr001]

Fixed, thanks all for your help.

 

[pillr001]

Right got another questions,

Is there a better formula to use, for example i have third tab now (third supplier) .. how do I get it to look into there if i changed column C to 'Third Supplier'

I've attached google doc

https://docs.google.com/spreadsheets/d/1DD4vivn6dvdjXaauHO6avF6Q69yC-l_UFLux7pCd_-s/edit?usp=sharing

When I change to 'Wax Man' or 'Mid-Summer', it looks into their tabs fine, but if I had a third option what formula would be needed?

Many thanks

 

[pillr001]

Right got another questions,

Is there a better formula to use, for example i have third tab now (third supplier) .. how do I get it to look into there if i changed column C to 'Third Supplier'

I've attached google doc

https://docs.google.com/spreadsheets/d/1DD4vivn6dvdjXaauHO6avF6Q69yC-l_UFLux7pCd_-s/edit?usp=sharing

When I change to 'Wax Man' or 'Mid-Summer', it looks into their tabs fine, but if I had a third option what formula would be needed?

Many thanks

Anyone know how to crack this?