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.
Bookmarks