Return multiple values from long list

Hi oeldere ,

Attached is attempt so far.

Sheet 1 shows the raw data.
Sheet 2 shows an example of the Information I am trying to put together.

Note: I have changed all names to numbers and only left some example information.

The issue with the way I am doing it is that the VLOOKUP I am using would require you to know at which rows in the raw data each person sits at.

Hope this helps and someone can provide an automated formula.

Many Thanks