Trying to match fields

[Andrew_Moss]

Hi Everyone, hope you can help.

I have a workbook with two sheets, one used for referance (Column A - Product SKUS, B - Product Description and C - Carton Quantities) - Sheet 1

The other sheet I would like to import incoming shipments. (Column A - Product SKUS, B - Product Description, C - Quantity Ordered and D - No of Cartons) - Sheet 2

What I need to do is find out how to get Excel to find and match up the SKUs in Col A and then dividing Sheet 2's column C by Sheet 1's column C to give the number of incoming cartons of each product in Sheet 2's Column D

Does that make sense?

Cheers,
Andrew

[gak67]

Can you upload an example sheet to make it clearer? Indicate where you want to results to appear and how they might look.

[Andrew_Moss]

Hi,

Thank you for your reply, please find example file attached
Cheers,
Andrew

[azumi]

Perhaps something like this, pls see the file

[Andrew_Moss]

Perhaps something like this, pls see the file

Fantastic! thank you so much!

[azumi]

Yes you're welcome