I have a cell with a data validation drop down that displays certain named ranges based on a previous cell's input. E.g.
=IF(A1="First Option", NamedRange1, IF(A1="Second Option", NamedRange2, ...
I have one option that needs two named ranges to display in the drop down. Does anyone know of a way to do this? I know I could smash my two separate named ranges together, but that won't work in this case since the data is ordered in a particular way and wouldn't make sense if rearranged to suit my named range needs.
Bookmarks