I have to make a customer schedule forecast sheet. i record the customer demand every week with different different part no and store them in central database fie.

i have to use 2 vlook criteria one - part no (C4) and second is date of Call off (D4) and then get the future demand Column E to Y.

Vlook is required in F5 and F10 in "Stock overview sheet" . Drop Down is available in D5 and D10 .

Customer Schedule working.xlsx

please guide me.