Look Up and bring multiple result
nsd wrote:
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.
|