Hello. I'm trying to use Index/Match to pull corresponding data by extracting a string from a cell, but it is not working. My extraction formula is working correctly. Formulas are below each cell. I do not want to create a new column (I do not want to eliminate the additional formula in the Employee ID column.
<tbody>
</tbody>
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>