VLOOKUP with 2 criteria

[Rita Palazzi]

Windows 2000
Office 2000


I have one data sheet that lists a slew of values for each world division for each
week. Each new week is added as new rows to bottome of sheet. I have tried to
set up a partial sheet in example below to show how data is gathered:

A B C D
1 > Week Ending Division Total Shipments Total Pieces
2 > 12/19/2003 APAC 111,111 333,333
3 > 12/19/2003 CANADA 111,111 333,333
4 > 12/19/2003 EMEA 111,111 333,333
5 > 12/19/2003 LAC 111,111 333,333
6 > 12/19/2003 US 111,111 333,333
7 > 12/26/2003 APAC 111,111 333,333
8 > 12/26/2003 CANADA 111,111 333,333
9 > 12/26/2003 EMEA 111,111 333,333
10> 12/26/2003 LAC 111,111 333,333
11> 12/26/2003 US 111,111 333,333



I am trying to set up a chart data sheet so that I can do weekly trend charts on
the divisions for
each indice i.e. one chart for shipments and one chart for pieces.

I need to set up the data as shown below (Shipment example):

SHEET: Export Volume (Shpts)
APAC CA EMEA LAC US GLOBAL
12/19/2003
12/26/2003
1/2/2004
1/9/2004
1/16/2004
1/23/2004
1/30/2004
2/6/2004
2/13/2004
2/20/2004
2/27/2004
3/5/2004
3/12/2004

How can I do a vlookup utilizing the data in the first sheet to have it populate
the second sheet given that i need to match weekending date with division? If
vlookup is not the correct function, please advise on how I should handle this.


Thanks in advance for any help you may give!

Rita Palazzi
Engineer/FedEx Express


****NOTE**** NUMBERS SUPPLIED IN EXAMPLES ARE HYPOTHETICAL AND NOT TO BE
CONSIDERED LITERAL REFLECTIONS OF OUR BUSINESS!!!

 

[Frank Kabel]

Hi
not quite sure but you may have a look at pivot tables to create such a
report for you. See the following sites as a starting point:
http://www.cpearson.com/excel/pivots.htm
http://peltiertech.com/Excel/Pivots/pivotstart.htm
http://www.contextures.com/xlPivot02.html