View Single Post
 
Old 06-18-2020, 01:16 AM
Purfleet Purfleet is offline Windows 10 Office 2019
Expert
 
Join Date: Jun 2020
Location: Essex
Posts: 345
Purfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to behold
Default

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.
Reply With Quote