I have data in 4 columns, I want to look at two (or three if it works)
columns and if data matches, put 4th column data in that cell.

Ex.

Here is my source data.

      A         B         C             D
1     401      1      50204      $200
2     401      1      50206      $200
3     401      2      50204      $200
4     401      2      50206      $200
5     401      3      50204      $200
6     401      3      50206      $200
7     401      4      50204      $200
8     405      1      50204      $200
9     405      1      50206      $200
10   405      2      50204      $200
11   405      2      50206      $200
12   405      3      50204      $200
13   405      3      50206      $200
14   405      4      50204      $200
etc.

Column B refers to a month of the year.

I want to turn it into this type of format:

For 401

      A         B         C         D          E
1                1         2         3           4
2   50206   $200   $200   $200   $200
3   50206   $200   $200   $200   $200

Row 1 refers to the same months of the year.

And then do the same thing for 402.

Is this possible???  I tried to use a lookup function, but I could not
figure out how to look for 2 variables and then if they both match the result
be a third variable.  It would be a simple cut and paste, but my source data
is 50K+ lines long it covers 50 units (column A), 2500 account codes (column
C), and the values for those respective code (column D).

Any help would be greatly appreciated.