Look for value in a range and if it matches display cell contents

[inosent]

I have 24500 records and a list of 200 names.

I want to compare the name in one of the 24500 records and look for it within the range of 200 names. If there is a match, then show the cell info from the desired cell

Example

Range of names E1:E3:

Bob Smith
Dave Jones
Barry White

	A	B	C	D
1	Bob Smith	green	4	if(A1 is found in E1:E3 then show B1, else leave blank)
2	Jack Morgan	blue	2	if(A2 is found in E1:E3 then show B2, else leave blank)
3	Barry White	orange	1	if(A3 is found in E1:E3 then show B3, else leave blank)

The result would be:

D1 = green
D2 =
D1 = orange

 

[JoeMo]

Book1
	A	B	C	D	E
1	Bob Smith	green	4	green	Bob Smith
2	Jack Morgan	blue	2		Dave Jones
3	Barry White	orange	1	orange	Barry White
Sheet1

Cell Formulas
Range	Formula
D1:D3	D1	=IF(ISNA(MATCH($A1,$E$1:$E$3,0)),"",$B1)