Combining Two Sets of Data

Hi,

I have put this in the general section as I don't know if I need VBA or if I can do this with a look up.

Basically I have two sets of data;

Set 1 eg.

Promo Code       Detail                                         Creative      Offer               Expense          Date Live

XF2                   PPC Promotion Jan 09                   N/A             10% Off          $2000             1/1/09

GGH                  Geographic Magazine Jun 09          Red             15% Off         $100               5/1/09

......

Set 2 eg.

Date         Customer         Revenue         Promo        City

1/1/09      John                $400               XF2            NY

1/1/09      Fred                 $200              -                WA

1/1/09      Joe                  $300              XF2             SF

.....

I want to combine the two sets of data so I can do evaluations on the type of promotions that worked best in each city, the type of creatives that worked better, the ROM on activity etc...

Initally I did a VLookup to match the promocode and it's variables to Set 2 however if the promocode had no return then it doesn't appear in the data and I'm having trouble putting the cost in the right place.

This is the pivot I would like to do

                  JAN                              FEB

Promos       Expense    Revenue       Expense    Revenue

XXF             400           5000            0              200

HHG            200            0                0              500

KKK             4000          20              4000         8000

....

Any suggestions???

Thanks!