complicated INDEX (or VLOOKUP?) formula

In column B is part number (like 001-00-001), in column C is date, and D is quantity of sales forecasted that date.) For example:

001-00-001 10/8 1
001-00-001 11/15 3
001-00-001 11/21 2
001-00-002 10/9 17

I'm trying to put this info into another format. Part Number is in Column I (no duplicates), the list of dates begins J3 and goes across the 3 row. For example

10/8 10/9 11/15 11/21
001-00-001 1 3 2
001-00-002 17

I'm confused about the formula to use. For cell J4 (where I have "1"), I use the formula =INDEX($B:$D,MATCH(J$3,$C:$C,0),3)

But that formula won't work for all the cells. I need a formula that says

for cell J4:

IF the date in J3 is in column C beside the part number in I4's position in column B, THEN the quantity value in Column D that is in the same row. IF NOT, 0.

and for cell J5:

IF the date in J3 is in column C beside the part number in I5's position in column B, THEN the quantity value in Column D that is in the same row. IF NOT, 0.

Etc.

Any ideas how to do this?

I am going to close this thread and refer readers to the thread:

http://www.excelforum.com/excel-form...html?p=2960470

where I have attached an attachment. Thanks all!