This is easy to do but not as easy as you would first think.
me@jaykilleen.com wrote this over 8 years ago and it was last updated over 8 years ago.
Given a Table named Table1
| ID | Name |
|---|---|
| 1 | a |
| 2 | b |
| 3 | c |
If I want a dropdown in a cell on a worksheet that uses all the Names in Table1[Name] then you might think you can just add a validation list with the value =Table1[Name] as the formula. This won't work.
You will need to use the INDIRECT Application Worksheet Function like this:
=INDIRECT("Table1[Name]")