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.