Portfolio Tracker

[nurhtive]

Hi all, 

I'm having trouble with the 'previous units' column only returning a value of 0. 

I am looking to return the value in the 'cumulative units' column if the value in the 'stock' column finds a previous match. 

Does anyone know how to solve this? 

Below I have attached an example snip of the first 2 rows. 

Many thanks

[#2]

@nurhtive 

Try this in J3:

=IF(OR($C3="",ROW($C3)=2),"",XLOOKUP($C3,$C2:$C$2,$I2:$I$2,"",0,-1))

Fill down.