One way you could do it. Assume you have two source ranges, Range1 and Range2.

Let's say F3 can have a 1 or 2 (to specify Range1 or Range2 - I would assume
there is data validation to ensure only a 1 or 2 could be placed in this
cell).

For F4, click Data/Validation/List, and source is
=INDIRECT(IF(F3=1,"Range1","Range2"))


"cmac" wrote:

can the 'pick from list' list placed into a cell be decided by the selection
in the previous cell to it?