INDIRECT for a conditional lookup table

[adambc]

I have two columns in my Workbook, Dept (Column M) & Team (Column N) ...

Dept with Data Validation =INDIRECT("Dept") ie pointing at the Named Range = Dept
Team with Data Validation =INDIRECT(SUBSTITUTE(SUBSTITUTE(M1161," ",""),"&","")) ie pointing at the Named Range = the selection made in M1161/Dept (with any spaces or commas stripped out)

I now want to emulate this in a UserForm/VBA behind the two ComboBoxes ...

But I can't get out to work!

Any ideas please?

 

[adambc]

(with any spaces or commas stripped out)

Sorry, this should have read ... (with any spaces and any & stripped out)