dropdown menu fill after selection first dropdown menu

Hi everyone,

I would like to show a validation list in the dropdown menu, after the user has made a selection in another dropdown menu.

On sheet 1 you'll find a data list of different clubs and the members. For each club I've made a named range of the members (Club1, Club2, Club3)

So the user selects a club in the first dd menu, which will fill the second dd menu with the members of that club.

Unfortunately this results to a message that 'the source results to an error'

Any idea what goes wrong?

Thanks for your help

Thank you John for your reply. After I've deleted the offset-formula, it worked.
But is there a way so I can use the offset? The groups are always changing in size, so it would be practical to use the offset formula.