Choose + vlookup + if(iserror)

I've got a set of data that lists out information for items contained in a shipping container, but the same items can be in multiple containers, sometimes up to 6 or 7. When we receive the data, the containers are grouped together as text separated by a delimiter, normally a "/". I need to list the data by container, then show the contents.

I attempted to do this by separating the container text into unique values via the Text To Columns function, leaving me with 6 or 7 columns worth of container values. I moved these to the left of my data to set up my table for the Vlookup.

On a separate tab, I copied and pasted the Container values into one row, then attempted to write my Vlookups to include IF(ISERROR) statements indicating that if the container wasn't found in Column A, move the data set to Column B and look there, then C, then D, etc. The challenge I've run into is that my formula is longer than the 8912 characters allowed in Excel and I've got another set of columns to include to complete my data set.

I thought I might be able to combine the CHOOSE function with the VLOOKUP function and the IF(ISERROR) to shorten the formula.

A copy of my data set is attached. Can anyone help me with this?