Lists using Indirect function

I have used in the past the Indirect function to have only relevant data shown after selecting a value from a list.

I tried using the indirect function to look up a range that was defined using offset and found it returned an error, although if defined as a static range worked normally.

As the ranges can contain a variable amount of data it is preferable to have them defined dynamically.

If anyone has come across this problem before I would be interested to hear from you

Regards


Jeff

Thanks a lot finally got there, much appreciated.

Regards


Jeff