Return value if first 6 digits match the first 6 digits in another column

[eyoonbbj]

If the first 6 digits of column A match the first 6 digits of column C, return value from column D

A	B	C	D
-119.858604		-119.859738	EMILY
-119.794760		-119.794222	BRANDON
-119.799090		-119.799800	DONALD
-119.703094		-119.740803	DAVID
-119.840230		-119.703131	SHIRLEY
-119.869385		-119.759102	TOM
-119.827545		-119.762117	BETTY
-119.7982680		-119.840851	LAUREN
-119.798730		-119.798622	BRIAN
-11.762680		-119.869465	WILLIAM
-11.740670		-119.827319	JEFF
-119.759590

<tbody>
</tbody>

 

[Stridhan]

try this in B1 and enter with ctrl+shift+enter, not just enter.

=IFERROR(VLOOKUP(LEFT(A1,8),LEFT($C$1:$D$11,8),2,0),"")