cell list
 

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

cell list
 

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?