Use a Table Column as a List in a Validation List

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]")

Similar

---