I think index and match is what you are looking for
=INDEX($D$17:$BOB$23,MATCH($C43,$C$17:$C$23,0),MAT CH(D$42,$D$16:$BOB$16,0))
Do you have something to work out the dates with a delivery? if so the above seems to work
I would also reccomend turning the data around so that the feed is along the top and the dates at the side, it will be much easier to manage and read.
|