Sales / Inventory Combined Files

Hello all, I am new to the board and need some help trying to combine two files.

File one - Sales data, by product number, month, qty sales, cog and GP.

File two - Aged inventory report. File contains Product number and qty and $ value by product number.

I need to be able to combine the two files bases on items that show up on the aged inventory file.

I have put both into a pivot table and get desired info;however on the sales side i get all products and some are not in the aged inventory file.

Any help is greatly appreciated.

hi,

could you post an example,

thanks reg