Hi and welcome to the forum

Not really sure what you want here, or what you would want the answer/s to look like, but this will pull the SoH based on the Item #...
=VLOOKUP(A2,Stock!$A$2:$B$2212,2,0)

I see that you have a number of the same Item, with the same Qty and the same Date (A3:A5 for instance)?

What would your results look like - and why?