Offset Index Match?

[Robby19]

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.

Name	Employee #	Code	Code Date
ABC	1	TA	2018/1/1
ABC	1	TZ	2018/2/1
BCD	2	TA	2018/5/31
FGH	3	TZ	2018/2/4
BCD	2	TZ	2018/6/1

<TBODY>
</TBODY>

I need to pull the data into something like this;

Name	Employee #	TA Code	TA Date	TZ Code	TZ Date
ABC	1	TA	2018/1/1	TZ	2018/2/1
BCD	2	TA	2018/5/31	TZ	2018/6/1
FGH	3			TZ	2018/2/4

<TBODY>
</TBODY>

 

[Aladin Akyurek]

What is given in the output and what must be computed?

 

[Robby19]

The second table on Post #1 is what I would like the result to be. The first table is the output from our system logs. I want to be able to re-format the data so that it displays like table 2.

I have the TA Code and Date columns working fine. The issue that I'm having is getting the TZ Code and Dates to appear on Table 2, if the person also has the TA Code ran in our system.

 

[Aladin Akyurek]

What is given in the "second table" and what must be computed?​