Eddie,

The data is as follows:
Sheet1
A B C D
CH #-812081T CH815
HK #-812081T CH815
TH #-752075T AS755
RP #-752075T AS755
WWE#-532053T WW535

Sheet2
A B C D
CH #-812081T CH815 125,000 B
CH #-812081T CH05 6,180 A
HK #-812081T CH815 75,000 B
HK #-532053T 5785 4,519.58 A
RP #-752075T AS755 89,000 B
RP #-752075T 213.72 A
SN #-532053T WW535 30,000 B
SN #-532053T 425.83 A
SN #-532053T WW535 13,000 B
TH #-752075T AS755 11,000 B

I want the values from Sheet2 to show on Sheet1 on Columns C and D in
their respective row.
Sheet2 is export data from accounting where A=Actuals and B= Budget
shown on column D.

Column C is to show Actuals and it should sum the values found on
sheet2
Column D is to show Budget and it should sum the values found on sheet2

HK #-532053T and SN #-532053T should roll up to the WWE#-532053T for
both budget and actuals.

Thanks for your help.

Bexi