Look up INDEX issues

[Bryony309]

Hello,

I'm new to indexing and i'm having some issues.
I would really appreciate some guidance, as I've tried a couple of goes but I keep getting errors.

I have this document and would like to be able to enter a Student ID in B2 on the "check" sheet and for all the activities and dates related to that ID be pulled from the "entry" sheet (column A and B).

Must appreciated!

[samba_ravi]

I think Pivot Table is better option
see the attached file

[Ali Kırksekiz]

For D3 cell

Please Login or Register  to view this content.

This in an array formula and so must be confirmed with CTRL+SHIFT+ENTER and not just ENTER. Then pull down

For E3 cell

Please Login or Register  to view this content.

This in an array formula and so must be confirmed with CTRL+SHIFT+ENTER and not just ENTER. Then pull down

Note: For E column cell format must be date

[Bryony309]

Thank you so much Ali, this was great!!!

Nflsales, Pivot tables are too advanced for my users, but thank you for your time.

[Czeslaw]

Another option.