INDEX/MATCH with OFFSET

[chrono2483]

Hello,

I have been working on this project, and thanks to the amazing help on this forum so far have been making some great progress. I am at a roadblock again, and hoping the great minds here can help.

As mentioned, I want to grab the Scheduled From/To & Actual From/To for each agent, and display it next to the names listed in Col I (and display in Col K:N).

Can anyone suggest if Index/Match can work with Offset, and what the formula could look like (an initial formula that I can work and tweak)?

Thank you!

 

[chrono2483]

UPDATE:

I've tried the following formula and various orders to choose the names as a point of reference, and select the cells from there:

=OFFSET(INDEX($A$1:$A$500,MATCH(I$3,$A$1:$A$500,0)),4,0,0,2)

However I keep getting a #VALUE! or #REF! error.

Would someone know why I am getting this error?