How can I do a reverse vlookup to get there manager. I need to look up by ID1 and then reverse to get there managers name. Like 10321 = John Jones.
<colgroup><col><col><col><col><col span="3"></colgroup><tbody>
</tbody>
Manager | TT No | Last | First | ID3 | ID2 | ID1 |
John Jones | 1-2-8-26-1-0-0 | Smith | Richard | 78739 | 10321 | |
Debra Willson | 1-2-8-26-1-0-0 | Davis | Pual | 74280 | 31808 | |
Anna Baker | 1-2-8-26-1-0-0 | Rodriguez | John | 77621 | 78945 | 11221 |
<colgroup><col><col><col><col><col span="3"></colgroup><tbody>
</tbody>