Thanks, that works brilliantly.
The next challenge is to use this dynamic range in a data validation.
When I select the team in column B (e.g. VVM), a Vlookup searches the table (lookup_Team) below:
Column A Column B
VVM ddl_Team_VVM
TZ ddl_Team_TZ

However, the =INDIRECT(VLOOKUP($A2,lookup_Team,2,false)) function as source if the data validation results in am error.
I do not understand why.

Please advise.