How to build filter field from database table AND manipulated cells

I am trying to retrieve jobs from our freight system based on location.

We have a table containing location codes I am using to build my filter field.

Some of our 3 character codes have been updated to 5 character codes

Some jobs are missing, as they were input before the change, so still contain a 3 character code, not the new 5 character equivalent.


I need to build a filter field that contains all of the current codes I am retrieving from the table, unionized with a list of Excel cells, that have manipulated location codes in.

The Excel cells will retrieve a subset of 5 character codes, and remove the first two characters, to produce a list of old 3 character codes. I managed to get the two lists in Excel, but I obviously not in an array format that I could use with other NL functions.


Please sign in to leave a comment.