Formula for multiple values of text in cell to display text in another column

Create the table in D1:E17.

Data Range

	A	B	C	D	E
1	Name	Final Name	------	Name	Final Name
2	Tye Westmark	Tye Westmark		Tye Westmark	Tye Westmark
3	Cristie Gimble	Tye Westmark		Cristie Gimble	Tye Westmark
4	Tony Sepanski	Tony Sepanski		Tony Sepanski	Tony Sepanski
5	Starla Buccholz	Tony Sepanski		Starla Buccholz	Tony Sepanski
6	Keri Oldman	Keri Oldman		Keri Oldman	Keri Oldman
7	Reimer Douglas	Keri Oldman		Reimer Douglas	Keri Oldman
8	Debra Liming	Debra Liming		Debra Liming	Debra Liming
9	Marka Kontos	Debra Liming		Marka Kontos	Debra Liming
10	Carol Peterson	Carol Peterson		Carol Peterson	Carol Peterson
11	Karen Ottison	Carol Peterson		Karen Ottison	Carol Peterson
12	Joleen Sums	Joleen Sums		Joleen Sums	Joleen Sums
13	Joseph Ahlf	Joleen Sums		Joseph Ahlf	Joleen Sums
14	Brian Mays	Freddy Mercury		Freddy Mercury	Freddy Mercury
15	Freddy Mercury	Freddy Mercury		Brian Mays	Freddy Mercury
16	Robert Smith	Robert Smith		Robert Smith	Robert Smith
17	Steve Severin	Robert Smith		Steve Severin	Robert Smith

Then, this formula entered in B2 and copied down:

=VLOOKUP(A2,D$2:E$17,2,0)