If function with one result being a Dropdown choice based on criteria

I am looking to write an if function, where if the the first criteria is met (invoice number is found in a different table), then a dropdown box of results that match that invoice number in the second table is available.

Tbl_Data column b&C is data report driven
Tbl_Data column d is where I am developing the formula

Tbl Names is Manually created after investigating invoices.
Some invoices have only one name, some invoices have multiple names.
The data only ever shows the first name on the invoice.
Tbl_Names is a manual breakout of invoices with Manual names.

The goal is to create a formula, that if the invoice number in the Tbl_Data shows on Tbl_Names, a data validation dropdown shows up in column D for only the names related to that particular invoice Number
If the invoice is not in Tbl_names, it should show the name in Column B.
looking for

That worked, with a minor work around for myself.
The only shortfall, and probably as I was not clear, was for instances where they were not on the Tbl_2, I would want the name to auto populate. However as mentioned, it was not too hard for me to find a work around.

Thanks so much, I never would have gotten there!