Excel formula help

Copper Contributor
Hi there,

Really struggling with this one.

I currently have two worksheets (BOM and WIP). Both contain three columns (Stock code, Description, Quantity).

The stock code column contains numeric and alphanumeric stock codes. The stock code column does contain duplicate references on both worksheets. There are stock codes that appear on one worksheet but not on the other.

Is there a way of matching the stock codes on both worksheets and offsetting the quatities against each other to see what's outstanding on both worksheets?
0 Replies