Data Validation Range for a List based on value of neighbouring cell >0

Hello. I have usually been able to find my answer by an internet search, but have failed with this one.

I have this table ('Meta' table):

team_needs_lookup.png

I want to make a dropdown in the column of another table ('Prospects' table). I understand that I need to use Data Validation -> List to achieve this. For the List range I want to select cells from the first column of the Meta table but only if the value in the second column (in its row) is >0. (Both tables are on different sheets in the same workbook.)

I tried to explain to Google and Bing what I needed but I just couldn't word it concisely enough to get the answer I needed.

My file contains a lot of personal information, contact details, financial information, etc., for a charity. That is why I did not upload it.

All I need is someone to tell me which formula, or combination of formulas I need to use to achieve my aim. I will look up the syntax and work out how to implement it.

I posted the pictures because I was struggling to explain what I wanted to achieve in words. Sorry!

Thanks!

Glenn. I am genuinely sorry that I managed to make this more difficult than it needed to be. I took my pictures as screenshots from within the file I referred to. I now understand that I could help others by recreating what I need in a new excel file and posting that. In future I will do so.

Thank you so much for providing a workable solution for me to implement. Love it!

I am having a problem entering this:

=FILTER(Meta!$G$9:$T$9, Meta!$G$28:$T$28>0)

As the List range in Data Validation. I get the error "The formula you entered is not valid".

Have I done anything obviously wrong, or is there another step required to make this work as a list range for Data Validation?

Many thanks.

That little # is pretty clever. Thank you for the solution.