Hi,
How to make validate Dropdown list combined from Range1 and Range2 without creating additional columns?
Do I have first to create Range3 for combining those two ranges and only then create Dropdown list?
Edited:
Added screenshot and attached excel file.
DropDown.PNG
Bookmarks