How Can I Make Cells Populate with Up-to-Date Information and still Work with My Existing Formula?-CodePudding

Here is my sheet, feel free to make edits to it:

Or, for the whole column:

=INDEX(IFERROR(SPLIT(BYROW(F4:F,LAMBDA(each,JOIN("|",xlookup(each,C2:C,{D2:D,B2:B,A2:A},,0,-1)))),"|")))

CodePudding user response：

Both input and output reference dynamic.

=REDUCE({"Status","Stuff","Time Stamp"},F4:INDEX(F4:F,COUNTA(F4:F)),LAMBDA(a,x,{a;
QUERY(A2:D,"select D,B,A where C='" & x & "' order by A DESC limit 1",0)}))

See your file, sheet harun24hr.

I have used UNIQUE() function in F4 cell, if there any new items scanned then it will populate in F column automatically.