Trying to write a formula to bring back a value based on 2 parameters and am struggling!

Hi,
I am trying to create a formula that returns a value based on the product and day of the week. I only want a value returned if both the product and week day have a value in. The yellow cell indicates where the date would be changed to the appropriate month and the dates and days will flow through by formula. I have already actioned this part.


I have attached my working doc for info and would be really grateful if any of you can offer a steer in the right direction!

Many thanks

Suzanne

How about this in J6 and filled right/down to N12

=IF(B8="","",B8)

Thank you for taking the time to reply to me.

My problem is that when I change the month in cell H2 the date and day of the week will change, as I wish them to. For example, Bread will only be delivered on a Monday and Wednesday. These days will not always be in the same cell so I need a formula that can reflect this change...

Hope this makes sense!

Suzanne

OK, I see it now.

I was thinking the day's in row 4 would remain the same...
But I see now that they change with a different date in H2.

Try this in H6 filled down/right
=IFERROR(1/(1/INDEX($B8:$F8,MATCH(I$4,$B$7:$F$7,0))),"")

Thank you so much for your help.

Something else that I have learnt!

Suzanne

You're welcome.