Look Up and bring multiple result

[nsd]

Hello,

I have a long data in following format.

Name Week Total
Jon 4-Sep 1
Philip 4-Sep 2
Dan 4-Sep 3
James 4-Sep 4
Jon 25-Sep 5
James 11-Sep 6
Philip 11-Sep 6
Dan 18-Sep 7
James 18-Sep 8
Philip 25-Sep 8

I wish to create look up in different sheet to find individual's
performance on weekly basis as under

Case 1
Look up = Philip

Result should appear as under

Week 4-Sep 11-Sep 25-Sep
Roll 2 6 8

& Case 2
Look up = Jon
Result to appear as under:

Week 4-Sep 25-Sep
Roll 1 5

I was trying Vlookup, Index/Match, but unable to find a solution. If you
can help in advise a formula, will be of great help.

Also since I have a big historical file and need to find info. of last four
week - will that be possible.

Thanks in anticipation.
Regards,
Dinesh

 

[smartin]

Hello,

I have a long data in following format.

Name Week Total
Jon 4-Sep 1
Philip 4-Sep 2
Dan 4-Sep 3
James 4-Sep 4
Jon 25-Sep 5
James 11-Sep 6
Philip 11-Sep 6
Dan 18-Sep 7
James 18-Sep 8
Philip 25-Sep 8

I wish to create look up in different sheet to find individual's
performance on weekly basis as under

Case 1
Look up = Philip

Result should appear as under

Week 4-Sep 11-Sep 25-Sep
Roll 2 6 8

& Case 2
Look up = Jon
Result to appear as under:

Week 4-Sep 25-Sep
Roll 1 5

I was trying Vlookup, Index/Match, but unable to find a solution. If you
can help in advise a formula, will be of great help.

Also since I have a big historical file and need to find info. of last four
week - will that be possible.

Thanks in anticipation.
Regards,
Dinesh

Check your later post.