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.

[TABLE="width: 500"]
<TBODY>[TR]
[TD]Name[/TD]
[TD]Employee #[/TD]
[TD]Code[/TD]
[TD]Code Date[/TD]
[/TR]
[TR]
[TD]ABC[/TD]
[TD]1[/TD]
[TD]TA[/TD]
[TD]2018/1/1[/TD]
[/TR]
[TR]
[TD]ABC[/TD]
[TD]1[/TD]
[TD]TZ[/TD]
[TD]2018/2/1[/TD]
[/TR]
[TR]
[TD]BCD[/TD]
[TD]2[/TD]
[TD]TA[/TD]
[TD]2018/5/31[/TD]
[/TR]
[TR]
[TD]FGH[/TD]
[TD]3[/TD]
[TD]TZ[/TD]
[TD]2018/2/4[/TD]
[/TR]
[TR]
[TD]BCD[/TD]
[TD]2[/TD]
[TD]TZ[/TD]
[TD]2018/6/1[/TD]
[/TR]
</TBODY>[/TABLE]

I need to pull the data into something like this;
[TABLE="width: 500"]
<TBODY>[TR]
[TD]Name[/TD]
[TD]Employee #[/TD]
[TD]TA Code[/TD]
[TD]TA Date[/TD]
[TD]TZ Code[/TD]
[TD]TZ Date[/TD]
[/TR]
[TR]
[TD]ABC[/TD]
[TD]1[/TD]
[TD]TA[/TD]
[TD]2018/1/1[/TD]
[TD]TZ[/TD]
[TD]2018/2/1[/TD]
[/TR]
[TR]
[TD]BCD[/TD]
[TD]2[/TD]
[TD]TA[/TD]
[TD]2018/5/31[/TD]
[TD]TZ[/TD]
[TD]2018/6/1[/TD]
[/TR]
[TR]
[TD]FGH[/TD]
[TD]3[/TD]
[TD][/TD]
[TD][/TD]
[TD]TZ[/TD]
[TD]2018/2/4[/TD]
[/TR]
</TBODY>[/TABLE]

 

[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?​