SUMIFS + VLOOKUP tricky use in excel
I've got two files with excel sheets
The first one consists of 2 columns
First one is ARTICLE (with article numbers), second one is QUANTITY (with
product quantity)
Second file consists of two sheets
First sheet contains two columns is CODE (code numbers), second one is
QUANTITY (with product quantity)
Second sheet consists of two columns CODE and ARTICLE
The thing is one code, for instance "2111", can contain up to 5-10
different articles
My goal is to find the right articles in the first file depending on the
code in the second one and calculate the quantity in the second one.
THANK YOU SO MUCH for any insights!
No comments:
Post a Comment