Filtered list from 2 other lists

I am looking for a filter/sort formula that compares 2 lists and filters only values in List 2 that do NOT occur in List 1. I am hoping for an array formula for the final Filtered list so it can be used in a dynamic drop down list. thanks

Is there another way to make the output into a table format so I can create a named range?

No need to create a named range, if you put the formula in (for instance) G2 you can use =$G$2# in the source field of the data validation

would you mind creating it on my attached sheet so I can duplicate it?

Here you go

Quiet brilliant Fluff. I just learned something new today....thank you!

.....and thank you XOR

Glad to help & thanks for the feedback