May 08 2022 07:36 AM - edited May 08 2022 07:54 AM
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
May 08 2022 09:06 AM - edited May 08 2022 09:08 AM
Try this in J3:
=IF(OR($C3="",ROW($C3)=2),"",XLOOKUP($C3,$C2:$C$2,$I2:$I$2,"",0,-1))
Fill down.