1

I have a named range in Excel that contains user-entered manufacturers of cars. I want to use this named range in another table as a data validation dropdown list, but also include two other options: blank and "Manufacturer not in list". Is there a way to do this without including these two other options in the user-entered car manufacturer list?

enter image description here

John
  • 802
  • 2
  • 9
  • 19

1 Answers1

0

Although it is possible to combine two range names into a new range (using the name formula =RangeOne,Range2 ), that results in a multi-area range which cannot be used in data validation.

For a DV list you will need to construct a new, contiguous range in the grid and reference that for DV. That can be done with a variety of techniques, i.e. formulas, VBA or Power Query.

teylyn
  • 34,374
  • 4
  • 53
  • 73