Hi everyone,

I struggle with linking one validation list to another in order to filter my choices.

It usually works well with typing =INDIRECT($A$1), then filtering the list to A1 Name Manager, but it doesn't work in my case.
I think it is so because I used an Offset formula to define my second range.

Can anybody have look ?

Thanks

Attached Files

Data validation filter.xlsm (492.1 KB, 18 views)