Spreadsheet: 73407d1274076802-how-to-combine-if-vlookup-and-match-lookup-1-
Sheet: Data Source

Date | 20100920 | Campaign | Forecast QTY |  | 1 | 2 | 3 | 4 | 5
2010-04-15 00:00:00 | F4081033 | C9 | 9226 |  | 0 | 1 | 0 | 0 | 0 |  |  | Date | Model | C1
2010-04-30 00:00:00 | [NAME] | C10 | 388 |  | 0 | 0 | 0 | 0 | 0 |  |  | 2010-03-15 00:00:00 | F4081033 | 12784
2010-04-30 00:00:00 | [NAME] | C11 | 93650 |  | 0 | 0 | 0 | 0 | 0
2010-04-30 00:00:00 | F4081033 | C12 | 16000 |  | 0 | 1 | 0 | 0 | 0
2010-03-30 00:00:00 | F4081033 | C13 | 5850 |  | 0 | 1 | 0 | 0 | 0 |  | 1 | SUMPRODUCT compares 3/15/2010 with date column and returns TRUE and FALSE staements accordingly
2010-03-30 00:00:00 | F4081033 | C14 | 52360 |  | 0 | 1 | 0 | 0 | 0
2010-04-30 00:00:00 | F4081033 | C15 | 8378 |  | 0 | 1 | 0 | 0 | 0 |  | 2 | Then it compares F4081033 with values of your second column and again returns TRUE and FALSE statements respectively
2010-04-15 00:00:00 | F4081036 | C16 | 388 |  | 0 | 0 | 0 | 0 | 0
2010-03-15 00:00:00 | F4081036 | C17 | 388 |  | 1 | 0 | 0 | 0 | 0
2010-04-30 00:00:00 | F4081033 | C18 | 65000 |  | 0 | 1 | 0 | 0 | 0 |  | 3 | For C1 the same
2010-04-15 00:00:00 | F4081036 | C19 | 10400 |  | 0 | 0 | 0 | 0 | 0 |  | 4 | Then it multiplies TRUEs and FALSEs. For example TRUE*TRUE = 1FALSE*TRUE=0
2010-04-15 00:00:00 | F4081036 | C20 | 51000 |  | 0 | 0 | 0 | 0 | 0
2010-04-15 00:00:00 | F4081036 | C21 | 159800 |  | 0 | 0 | 0 | 0 | 0 |  |  | That’s because TRUE =1 but FALSE = 0
2010-03-30 00:00:00 | F4081033 | C22 | 25568 |  | 0 | 1 | 0 | 0 | 0 |  |  | Here's just onel with three TRUEs (row 18)
2010-04-30 00:00:00 | F4081033 | C23 | 127840 |  | 0 | 1 | 0 | 0 | 0 |  | 5 | then it multiplies Forecast QTYcolumn values with 1 and you get 12784
2010-04-30 00:00:00 | F4081033 | C24 | 388 |  | 0 | 1 | 0 | 0 | 0
2010-03-15 00:00:00 | F4081033 | C1 | 12784 |  | 1 | 1 | 1 | 1 | 12784
2010-04-30 00:00:00 | F4081037 | C2 | 388 |  | 0 | 0 | 0 | 0 | 0
2010-04-30 00:00:00 | F4081037 | [NAME] | 388 |  | 0 | 0 | 0 | 0 | 0 |  |  | Related Topics
2010-03-15 00:00:00 | F4081037 | C4 | 388 |  | 1 | 0 | 0 | 0 | 0 |  |  | Xl Dynamic
2010-03-15 00:00:00 | F4081033 | C5 | 388 |  | 1 | 1 | 0 | 0 | 0 |  |  | YouTube Excel Lovers Channel
2010-03-15 00:00:00 | F4081033 | C6 | 388 |  | 1 | 1 | 0 | 0 | 0
2010-03-15 00:00:00 | F4081033 | C7 | 388 |  | 1 | 1 | 0 | 0 | 0
2010-04-30 00:00:00 | F4081033 | C8 | 388 |  | 0 | 1 | 0 | 0 | 0
2010-04-15 00:00:00 | F4081034 | C9 | 5850 |  | 0 | 0 | 0 | 0 | 0
2010-04-15 00:00:00 | F4081034 | C10 | 38000 |  | 0 | 0 | 0 | 0 | 0
2010-04-15 00:00:00 | F4081033 | C11 | 70000 |  | 0 | 1 | 0 | 0 | 0
2010-04-30 00:00:00 | F4081034 | C12 | 13280 |  | 0 | 0 | 0 | 0 | 0
2010-04-15 00:00:00 | F4081034 | C13 | 2500 |  | 0 | 0 | 0 | 0 | 0
2010-04-30 00:00:00 | F4081034 | C14 | 49160 |  | 0 | 0 | 0 | 0 | 0
2010-04-30 00:00:00 | F4081034 | C15 | 7866 |  | 0 | 0 | 0 | 0 | 0
2010-03-30 00:00:00 | F4081034 | C16 | 5850 |  | 0 | 0 | 0 | 0 | 0
2010-04-30 00:00:00 | [NAME] | C17 | 5850 |  | 0 | 0 | 0 | 0 | 0
2010-03-30 00:00:00 | [NAME] | C18 | 2500 |  | 0 | 0 | 0 | 0 | 0
2010-03-30 00:00:00 | [NAME] | C19 | 70000 |  | 0 | 0 | 0 | 0 | 0
2010-03-30 00:00:00 | F4081034 | C20 | 11200 |  | 0 | 0 | 0 | 0 | 0
2010-03-30 00:00:00 | F4081034 | C21 | 24200 |  | 0 | 0 | 0 | 0 | 0
2010-04-30 00:00:00 | F4081034 | C22 | 116200 |  | 0 | 0 | 0 | 0 | 0
2010-04-30 00:00:00 | F4081036 | C23 | 92960 |  | 0 | 0 | 0 | 0 | 0