Cell Pull down menu with 'where' condition

Hi

I have a worksheet 1, it has 5 columns.

(A)
Team A
Team B
Team C
Team D
.....
(B)
Team E
Team F
Team G
Team H
.....
(C)
87:90
78:88
90:92
85:89
.....
(D)
2005
2005
2005
2006
.....
(E)
Round 1
Round 1
Round 1
Round 2

It means Team A vs Team E, score result 87:90 in year 2005.

In worksheet 2, I want to show 2 cell pull down menus in (A) row
(1) Team in (A)
(2) Year in (D)

When I choose All Team and 2005, it will show the result in (A3) row

(A3) Empty (B3) Round 1 (B3) Round 2
(A4) Team A (B4) Team E (87:90)
(A5) Team B (B5) Team F (78:88)
(A6) Team C (B6) Team G (90:92)
(A7) Team E (B7) Team A (87:90)
(A8) Team F (B8) Team B (78:88)
(A9) Team G (B9) Team C (90:92)

How can I code it?

Thanks for help
Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories