Spreadsheet: 136992d1326903788-double-vlookup-example
Sheet: Sheet1

Store | Last year sales | Sales |  |  | Store Name | West
West | 2011-10-01 00:00:00 | 1000 |  |  | FEB 2012 SALES TARGETS
West | 2011-10-03 00:00:00 | 1050
West | 2011-10-04 00:00:00 | 1100 |  |  | DAY OF THE WEEK | SUNDAY | MONDAY | TUESDAY | WEDNESDAY | THURSDAY | FRIDAY | SATURDAY | END OF WEEK 1 | WEEK 1
West | 2011-10-05 00:00:00 | 1150 |  |  | DATE |  |  | 1 | 2 | 3 | 4 | 5 | 1st to 5th | 1st to 5th
West | 2011-10-06 00:00:00 | 1200 |  |  | 2010 ACTUAL SALES
West | 2011-10-07 00:00:00 | 1250 |  |  | 2011 TARGET SALES
West | 2011-10-08 00:00:00 | 1300 |  |  | TARGET GROWTH
West | 2011-10-10 00:00:00 | 1350 |  |  | TARGET GROWTH %
West | 2011-10-11 00:00:00 | 1400 |  |  | DAY OF THE WEEK | SUNDAY | MONDAY | TUESDAY | WEDNESDAY | THURSDAY | FRIDAY | SATURDAY | END OF WEEK 2 | Wk 1 + 2
West | 2011-10-12 00:00:00 | 1450 |  |  | DATE | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 6th to 12th | 1st to 12th
South | 2011-10-13 00:00:00 | 1500 |  |  | 2010 ACTUAL SALES
South | 2011-10-14 00:00:00 | 1550 |  |  | 2011 TARGET SALES
South | 2011-10-15 00:00:00 | 1600 |  |  | TARGET GROWTH
South | 2011-10-17 00:00:00 | 1650 |  |  | TARGET GROWTH %
South | 2011-10-18 00:00:00 | 1700 |  |  | DAY OF THE WEEK | SUNDAY | MONDAY | TUESDAY | WEDNESDAY | THURSDAY | FRIDAY | SATURDAY | END OF WEEK 3 | Wk  1 + 2 + 3
South | 2011-10-19 00:00:00 | 1750 |  |  | DATE | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 13th to 19th | 1st to 19th
South | 2011-10-20 00:00:00 | 1800 |  |  | 2010 ACTUAL SALES
South | 2011-10-21 00:00:00 | 1850 |  |  | 2011 TARGET SALES
South | 2011-10-22 00:00:00 | 1900 |  |  | TARGET GROWTH
South | 2011-10-24 00:00:00 | 1950 |  |  | TARGET GROWTH %
South | 2011-10-25 00:00:00 | 2000 |  |  | DAY OF THE WEEK | SUNDAY | MONDAY | TUESDAY | WEDNESDAY | THURSDAY | FRIDAY | SATURDAY | END OF WEEK 4 | Wk 1 + 2 + 3 + 4
East | 2011-10-01 00:00:00 | 2050 |  |  | DATE | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 20th to 26th | 1st to 26th
East | 2011-10-02 00:00:00 | 2100 |  |  | 2010 ACTUAL SALES
East | 2011-10-03 00:00:00 | 2150 |  |  | 2011 TARGET SALES
East | 2011-10-04 00:00:00 | 2200 |  |  | TARGET GROWTH
East | 2011-10-05 00:00:00 | 2250 |  |  | TARGET GROWTH %
East | 2011-10-06 00:00:00 | 2300 |  |  | DAY OF THE WEEK | SUNDAY | MONDAY | TUESDAY | WEDNESDAY | THURSDAY | FRIDAY | SATURDAY | END OF WEEK 5 | Wk 1 + 2 + 3 + 4 + 5
East | 2011-10-07 00:00:00 | 2350 |  |  | DATE | 27 | 28 | 29 | 30 |  |  |  | 27th to 30th | 1st to 30th
East | 2011-10-08 00:00:00 | 2400 |  |  | 2010 ACTUAL SALES
East | 2011-10-09 00:00:00 | 2450 |  |  | 2011 TARGET SALES
East | 2011-10-10 00:00:00 | 2500 |  |  | TARGET GROWTH
East | 2011-10-11 00:00:00 | 2550 |  |  | TARGET GROWTH %
East | 2011-10-12 00:00:00 | 2600
East | 2011-10-13 00:00:00 | 2650
North | 2011-10-14 00:00:00 | 2700
North | 2011-10-15 00:00:00 | 2750
North | 2011-10-16 00:00:00 | 2800
North | 2011-10-17 00:00:00 | 2850
North | 2011-10-18 00:00:00 | 2900
North | 2011-10-19 00:00:00 | 2950
North | 2011-10-20 00:00:00 | 3000
North | 2011-10-21 00:00:00 | 3050
North | 2011-10-22 00:00:00 | 3100
North | 2011-10-23 00:00:00 | 3150
North | 2011-10-24 00:00:00 | 3200
North | 2011-10-25 00:00:00 | 3250
North | 2011-10-26 00:00:00 | 3300
North | 2011-10-01 00:00:00 | 3350
North | 2011-10-03 00:00:00 | 3400
North | 2011-10-04 00:00:00 | 3450
North | 2011-10-05 00:00:00 | 3500
North | 2011-10-06 00:00:00 | 3550
North | 2011-10-07 00:00:00 | 3600
North | 2011-10-08 00:00:00 | 3650
North | 2011-10-10 00:00:00 | 3700
North | 2011-10-11 00:00:00 | 3750