INDEX with accumulative SUM

Originally Posted by benishiryo

hi Mecha_Trueno. try this at E4:
=LOOKUP(2,1/((SUBTOTAL(9,OFFSET(G4,,,,COLUMN(G4:AJ4)-COLUMN(G4)+1))<=D4)*(G4:AJ4<>"")),$G$3:$AJ$3)

Brilliant, works perfect.
Just wondering, would it have worked just as well without the <>”” test?

Originally Posted by arlu1201

Mecha,

You should be able to download the attachment now. Please try and let me know.

Nope, still getting redirected.