VLOOKUP Stock Spreadsheet issue

[paulbray81]

Hi Guys,

I am having an issue which a spreadsheet where I have a list of stock

item	SKU	TYPE	SIZE	Starting QTY	Running Qty
Shirt	SS-5XS	SS	5XS	8
Shirt	SS-3XS	SS	3XS	23
Shirt	LS-3XS	LS	3XS	2
Shirt	LS-2XS	LS	2XS	25

<tbody>
</tbody>

I then have a table which lists all items the running QTY has a formula of =F4-(VLOOKUP(C4,$J$3:$Y$10,9,FALSE))

F4 = the Starting Qty column
C4 = is the SKU column
Column J is the shirt sku column
Column 9 is the shirts needed column

Team

Shirt SKU

Shirt Size

Short SKU

Short Size

Zip Top SKU

Zip Top Size

Shirts Needed

In Stock

Shorts Needed

In Stock

Socks Needed

In Stock

Zip Top Needed

In Stock

U7 Red

SS-5XS

3

8

U7 Red

SS-3XS

2

23

U7 Yellow

SS-5XS

5

8

<tbody>
</tbody>

So I need to see the running quantity change upon what is added into the shirts needed. trouble is the 2nd row with the SS-5XS SKU is not added to the running total which should make it 0 not 5.

If anyone can help me solve this issue it would be massively appreciated

 

[Marcelo Branco]

Maybe...

=F4-SUMIF(J$4:J$10,C4,R$4:R$10)

M.