I have two worksheets in the same work book
Sheet one looks like:
Sheet two looks like this:
I would like to have a formula to use on sheet one column d which will return the value the LC and Date intersection.
Can anyone help??
Many Thanks!
Sheet one looks like:
Capacity for Capacity Planner_083106 (2).xls | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | |||
2 | LC | Style | 09/01/2006 | 09/08/2006 | 09/15/2006 | 09/22/2006 | 09/29/2006 | 10/06/2006 | |||
3 | B1 | GS0038 | 11.6% | ||||||||
4 | B1 | GS0098 | 76.7% | ||||||||
5 | B1 | GS0169 | 11.7% | ||||||||
6 | B2 | GS0036 | 9.9% | ||||||||
7 | B2 | GS0099 | 82.5% | ||||||||
8 | B2 | GS0168 | 7.5% | ||||||||
9 | B3 | GS0007 | 97.7% | ||||||||
10 | B3 | GS1345 | 2.3% | ||||||||
11 | B4 | GS0019 | 99.0% | ||||||||
12 | B4 | GS1346 | 1.0% | ||||||||
13 | B6 | GS0448 | 100.0% | ||||||||
14 | B7 | GS0449 | 100.0% | ||||||||
15 | B8 | GS0116 | 16.9% | ||||||||
16 | B8 | GS0875 | 83.1% | ||||||||
Sheet1 |
Sheet two looks like this:
Capacity for Capacity Planner_083106 (2).xls | |||||||||
---|---|---|---|---|---|---|---|---|---|
B | C | D | E | F | G | H | |||
1 | LoadCategory | 09/01/2006 | 09/08/2006 | 09/15/2006 | 09/22/2006 | 09/29/2006 | 10/06/2006 | ||
2 | B1 | 90 | 90 | 90 | 90 | 90 | 70 | ||
3 | B2 | 250 | 250 | 250 | 250 | 250 | 200 | ||
4 | B3 | 140 | 140 | 112 | 140 | 140 | 140 | ||
5 | B4 | 500 | 500 | 400 | 500 | 500 | 500 | ||
6 | F2 | 0 | 0 | 0 | 0 | 0 | |||
7 | F3 | 0 | 0 | 0 | 0 | 0 | |||
8 | F5 | 0 | 0 | 0 | 0 | 0 | |||
9 | F8 | 0 | 0 | 100 | 115 | 115 | 100 | ||
10 | H1 | 1850 | 1850 | 1480 | 1652 | 1652 | 1480 | ||
11 | H11 | 700 | 700 | 700 | 700 | 700 | 700 | ||
12 | H2 | 150 | 150 | 120 | 150 | 150 | 150 | ||
cross tab |
I would like to have a formula to use on sheet one column d which will return the value the LC and Date intersection.
Can anyone help??
Many Thanks!