Figure A shows a simple Table named Commission2 — that’s the source data. As you can see, the Region values repeat. ... How to base a data validation dropdown on an array in Excel.

Excel tables help manage dynamic data ranges, adjusting automatically as data changes. ... Table Array: This is the range of cells that contains the data you want to search through.

If you select the actual Table, Excel will use a longer version, Names[[#All],[First Name]], but the shorter reference works the same, so don’t worry about that slight difference.