SOLVED

I am sure I am looking for IF command advice, but not 100% sure

New Contributor

Hello all!

 

I am looking for assistance to find the right formula. Hoping someone can help out.

Thank you in advance!

 

IF Column E (in form 1) = Column D (in form 2), then Column K (in form 1) with the row it matched in Colum E (form 1) & Column D (form 2) - Column K (in form 2) with the row it matched in Column E (form 1) & D Column (form 2)

 

This would need to stack - IF Multiples in Form 2, then subtract all from Form 1.

I hope this makes sense...

 

Basically trying to subtract the Original Lot# Qty in receiving inspection from any lot#'s released that matches the Original lot# in receiving to see how much inventory is left.

 

Matt_QC_0-1661375274613.png

Matt_QC_1-1661375296755.png

 

 

 

2 Replies
best response confirmed by Hans Vogelaar (MVP)
Solution

@Matt_QC You need to use the SUMIF function. The formula would look like this:

 

In the cell in Form 1 where it says FORMULA, and let's assume this is M11 and that the sheet that contains Form 2 is called "Form2".

=K11-SUMIF(Form2!D:D,E11,Form2!K:K)

 

@Riny_van_Eekelen 

 

Thank you very much. That worked flawlessly!