Hallo I am back to ask for more help to You.


First table:
A,B,C are input data
D = summ of value from 2nd table
E= C-D
F= input data

A B C D E F
Code Product Quant Despatched Differ. Max/deliver
1 Sample1 300 150 150 50
2 Sample2 100 50 50 50
3 Sample3 47 7 40 50
4 Sample4 193 93 100 50


a detailed table with

A B C D
Date Code Product Quant
10 25.03 1 sample1 10
20 25.03 2 sample2 50
30 26.03 1 sample1 50
40 27.03 3 sample3 ??
50 27.03 1 sample1 ??

With Vlookup I am populate column C.

Form example: how may tell Excel to write 40 in cell D40 that is the
value of the first table =E3.
Than for cell D50 how may tell Excel to write 50 as E1 is 150, but max
deliver per day is 50?
I hope I explain myself.

Thanks and Regards
Paul