Show available items sorted by multiple criteria and without calc error

Hi Everyone,

I have a box tracking system and have become stuck on small things.

I'd like to display a "picklist" of available boxes. The boxes have several stages and can only pop up in the picklist if the previous step has been completed.
My approach was to use FILTER function (To sort criteria) as well as XLOOKUP on the physical location on of the box (Check in/Out). I'm running a VBA that tended up crashing for some reason using the formulas I'm currently using (I imported the values into the UserForm).

Fomula for Check In/Out -

=XLOOKUP(MAX(Table1[Time]),(Table1[Barcode]=[@Serial])*Table1[Time],Table1[Check in],,-1)

Formula for conditions -

=FILTER(FILTER(BoxIn[[Serial]:[FILE M]],ISNUMBER(SEARCH(R5,BoxIn[Client])*(SEARCH($T$1,BoxIn[FILE M]))*(SEARCH(T1,BoxIn[SCAN])*(SEARCH(S1,BoxIn[Completion])*(SEARCH($T$1,BoxIn[In progress])))))*(BoxIn[Completion]=0)),{1,0,0,0,0})

Attached is the workbook where "BoxIn" tab shows the current status, 'Database' tab shows which box is last in/out (XLOOKUP), and 'Home' tab is where the results are to be displayed.

Once the list is emtied I'd prefer not to have it show #calc error if possible.

Hope you magicians can help!