Trying to return a last value in a column based on the same description

[Barkinglong]

I have a problem in column G (happy with Col H if G would work)

Trying to return the last known value in the "cumulative units" column H based on the stock typed in column C
I think I am struggling with the array { } needed in the formula brought over from a working Google sheet (and how to do that in mac).

Tried MAXIF in the first rows but when I have a sell and units go down it obviously does not return the right value (e.g 13 returned but is ok on row 8 bu then it should be 12, 11 etc on each "SELL")
Played about with INDEX and SUMPRODUCT to no avail get a REF error

Working formula in Google sheets is:
=IF($C12="","",IFERROR(IF(ROW()<>2,INDEX(arrayformula(FILTER($H$4:$H11,$C$4:$C11<>"",ROW($C$4:$C11)=MAX(IF($C$4:$C11=C12,ROW($C$4:$C11),0)))),1),0),0))
Can't get it to work in excel.

Any help appreciated.
Regards
Mark

[Gregb11]

Try in Cell G5:

=XLOOKUP(C5,$C$4:$C4,$H$4:$H4,0,0,-1)

And copy down.

[bebo021999]

Do not know what column G for, but in column H, in H5:

Please Login or Register  to view this content.

Drag down

Try to input column G manually, I will try it again.

[Barkinglong]

Re GregB11

wow yes this works and is a lot more simple!

Thanks