Show available items sorted by multiple criteria and without calc error

[Sosborg]

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 -

Please Login or Register  to view this content.

Formula for conditions -

Please Login or Register  to view this content.

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!

[CRIMEDOG]

I would add 4 calculated columns on Boxin Tab that use Start in row 2 (Say column K) :

Please Login or Register  to view this content.

This should number all of your File Management List. Then on the Home tab - in your File Management Helper starting in Row 3:

Please Login or Register  to view this content.

this will bring over the info.