Employee | Total Returns | Overall Score | Overall Score | Employee ID | |

Tom Smith (12345) | 700 | 87% | #N/A | 12345 | |

=INDEX(C2:C10,MATCH(MID(LEFT(A2,FIND(")",A2)-1),FIND("(",A2)+1,LEN(A2)),A2:A10)) | =MID(LEFT(A2,FIND(")",A2)-1),FIND("(",A2)+1,LEN(A2)) |

<tbody>

</tbody>