Tables :: VLookup Displaying Multiple Cells

I am creating a staffing database and currently have two tables:

Table 1 - Staff - which contains staff information ie. First Name, Last Name, Other Names

Table 2 - Staff Work History - which displays the shifts worked by each staff member.

In Table 2 - I have "Staff Name" which is populated using VLOOKUP and searching for the Staff Name from Table 1 - First Name, Last Name, Other Name.

I want Table 2 column "Staff Name" to display all parts of the name - not just display then when on the dropdown when you select the staff person. Currently only the First Name is displayed once you have chosen the staff person.