Need help

[silkcut]

I have 2 working sheets

Sheet 1 contains raw data which reads

Item Description Outlet Value


Sheet 2 is the presentation sheet and contains


Outlet

Description Actual Forecast Plan


in each column.


I can sumif to get the description value from sheet 1 to sheet 2, but what i actually need is the value for each outlet and each description in sheet 2.

can anyone point me to the right direction?


Wez

[silkcut]

I have 2 working sheets

Sheet 1 contains raw data which reads

Item Description Outlet Value


Sheet 2 is the presentation sheet and contains


Outlet

Description Actual Forecast Plan


in each column.


I can sumif to get the description value from sheet 1 to sheet 2, but what i actually need is the value for each outlet and each description in sheet 2.

can anyone point me to the right direction?


Wez

anyone with any ideas?