There are a couple of ways to do this. If your layout is consistent and you want the text after the "-" without spaces, you can use this DV formula:
=INDIRECT(SUBSTITUTE(MID(A2,FIND("-",A2)+2,LEN(A2))," ",""))
If you want to use more controlled list names, you can actually create a lookup table in your sheet somewhere. The first column could be called List and could be used as the DV source in the first drop box. The second column is the name of the matching list, and can appropriately be called Lists.
Then you use this as your Data Validation formula:
=INDIRECT(LOOKUP(A2, List, Lists))
With this second method, you are no longer constrained by the text, your LISTS can have any list name values you want.
Bookmarks