How can I get data from a Table

Question

Can someone assist me on how can I get data from a table in Excel 2013?

I have a table named Personal:

and I want to have a control in a cell like this: (I do not know how to add this control in a cell)

So I can select data from the table:

I googled a lot before asking here, and couldn't find how to do it.

Answer 1

Maybe your google foo could do with some polish. For the dropdown try DATA > Data Tools, Data Validation,

Allow: List
Source: whatever the range is for the data in your table.