Excel worksheet function - Sort of LookUp Function - Help Needed

[iwtci]

Good day to all of you out there?!

I work as a sales and marketing manager for a company selling an
installing elevators. I use a relatively large workbook to maintai
the database and control the delivery process, therefore, determin
when do I have to place the order with our principals, hence, forecas
the outgoing cash flow for this purpose only. yet, get a Gantt Char
of the expected workload for the installation dept. The primar
installation date is provided by our customer

I have the following setup for the sheet

A1 : data validation list to choose the year (2004 upwards)
B5:B20 contains the order number (manually entered)
C5:C20 contains the order quantity (manually entered)
D520 contains the delivery date (to be automatically calculated
i.e. I need help here.
E44 contains short month names (Jan, Feb, Mar…Dec)

A B C D E F G H
I J K L M N O P

1 2004
2
3
4 Order # Qty Del. Date Jan Feb Mar Apr May Jun Jul Aug Se
Oct Nov Dec
5 NA-092 3 to be calc
2 1
6 NA-097 7 to be calc
2 3 2
7 NA-101 3 to be calc
1 1 1

 

[iwtci]

Hi tehre,

the data sample shall look as detailed hereunder.


A B C D E F G H
I J K L M N O P

1 2004
2
3
4 Order # Qty Del. Date Jan Feb Mar Apr May Jun Jul Aug Se
Oct Nov Dec
5 NA-092 3 to be calc ………………………...2………….1
6 NA-097 7 to be calc …………………………………2………3……….2
7 NA-101 3 to be calc …………………………….1……………1….1