Table 1 Table 2 excel called a column, use the drop-down menu display

Table 1 Table 2 excel called a column, such as Table 2, column I wrote a bunch of career, I want a C-column table in each cell has a drop-down menu, and the contents of the drop-down menu is my Table 2 that the fixed column of occupation, how????

to Table 2 in the occupation column of the data selected in the Name box, enter “occupation” word.selected to have pull-down menu in Table 1 area, point data menu, data validation, set to allow:sequence, source:= job.OK.

data – validity – Series – Source – Professional 1, Professional 2, Professional A

1.Open the Table 2, insert – name – define, enter a name, such as “occupation”, and then the selected reference location 2.Open the Table 1, data – the effectiveness of selected sequences, enter the following sources:= job