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.

Thanks for you reply.

Yes i think you are right. I will flip the tables around.

Its a little confusing as i may not have explained it right.

You see cells D27 to D38, there are three separate date (29/03 03/04 and 01/07) what i would need is:

column D all feed quantities arriving on the 29/03
column E all feed quantities arriving 03/04
column F all feed quantities arriving 01/07

I think i can do with two tables but i want to get it into one and i dont want to have to filter using the table drop down menu.

Okay, so my attempt in D43:k49 is not what you wanted?

It actually works well, thank you!

One last question. Is there anyway to get the dates in line 42 automatically?