i have data validation for a cell set to allow data from a list using a named
range. can i make the name of the range in the data validation source field
dependent on the value in another cell?
ie: if i have 3 named ranges in rows 1:3 in columns a, b & c respectively
and want the drop down in E1 to display only 1 of the 3 lists depending on
the value in cell D2 how do i set up the data validation field?