Data validation list filter with range defined by OFFSET
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
|