Good afternoon,

In a worksheet I have five columns.

Zip Code II Zip Code I OT Carrier Transit Date
64429 50010 1 DHRN 1 11/15/2006
64429 50010 8 DHRN 1 11/15/2006
64429 50010 7 DHRN 1 11/15/2006
64429 50010 2 DHRN 1 11/15/2006
64429 50010 4 DHRN 1 11/15/2006
64429 50014 1 DHRN 1 11/15/2006
64429 50014 8 DHRN 1 11/15/2006
64429 50014 7 DHRN 1 11/15/2006


I would like to create a second worksheet to use as a cross table of the
data in the first worksheet. I would like to have the carrier name put at
the intersection of the column (OT) and the row Zip Code I.

So if in the new table I have:
- A2 = 50010
- B1 = 1
- Then b2= DHRN

What would be the formula that would take the data from an organized list
and create a cross table. I tried Match / Index but I do not get the result.

Thanks