I have a master list of account codes used by my employer on a DatVal sheet for a budget tracker I used. I want to use checkboxes to select the most relevant codes to include in a list in a separate column that will become a data validated drop down list on another sheet.

I'm trying to use lookup and it sort of works, but is broken. I'm looking to see if the checkbox column is marked "True" then returning the result from a column where I've joined the account code and its description.

[Here is an image of the sheet.]

I've set up an example sheet here: (

or skip the blanks like:

=FILTER(E3:E, B3:B=TRUE)