Hello!
I have a table that I need to Index Match a code and date to another sheet. The problem is that there are multiple lines for each person and the code I need is not always the first one.
<TBODY>
Name
Employee #
Code
Code Date
ABC
1
TA
2018/1/1
ABC
1
TZ
2018/2/1
BCD
2
TA
2018/5/31...