Matching or Vlookup in Excel

[azureseas001]

Hi, newbie here. Thanks in advance for the help.

My question is in using matching or vlookup... I have two spreadsheet tabs. I want to fill up the "Current Stock Count" in first spreadsheet tab, where the product name and variation name will be searched in second spreadsheet, and add up quantity sold for that item, then the total quantity sold will be deducted from the Initial Inventory. How to formulate the code to get the result?

Again, thank you.

 

[etaf]

SUMIFS() should do that for you
can you use XL2BB or a share to put the spreadsheet rather than images, I will try and enter all data into an example , but logging off soon.

SUMIFS($E$2:$E$100, $B$2:$B$100, B2,$C$2:$C$100, B2) should add up thew quantity sold - so subtract from D2


Heres a quick sample

Book5
	A	B	C	D	E
1	date	Prod name	Var Name	Inven	Stock now
2	1/1/21	ABC	A	110	98
3		ABC	B	100	86
4		ABC	C	90	90
5		ABC	D	80	62
6		XYZ	1	70	50
7		XYZ	2	60	60
8		XYZ	3	50	29
9		XYZ	4	40	35
Sheet1

Cell Formulas
Range	Formula
E2:E9	E2	=D2-SUMIFS(Sheet2!$E$2:$E$7,Sheet2!$B$2:$B$7,Sheet1!B2,Sheet2!$C$2:$C$7,Sheet1!C2)

Book5
	A	B	C	D	E
1	date	Prod name	Var Name	Price	Sold
2		ABC	A		12
3		ABC	B		14
4		ABC	D		18
5		XYZ	1		20
6		XYZ	3		21
7		XYZ	4		5
Sheet2