select team matches from a dropdown list.

[madforgolf]

Hi guys,

I have a table C2:h200 which has 10 teams dates with 18 matches.

When i select a name from a dropdown box in another sheet using vlookup it gives me the 1st date for that team -- as below.

the data:
c2 - d2 - e2 - f2 - g2 - h2
Drummond - Wed - 21/9/11 - Leck - v - Drummond

Can you tell me how to populate the other matches for that team when i select it from the dropdown to show all matches for that team. Im not good (in fact cr*p) at pivot tables so was looking for any ideas or would a pivot be the best.

Is there a way to do this.

Cheers
Marty


excel 2007

 

[madforgolf]

Hi
i am still struggling with the pivot table idea and cant see any other way to do the above. is it possible, to be done?