Hi,
I have two columns A and B as shown below. When I choose North in Col A, I
should get only values correspondig to North in Col B . ( 1,4,2 and 6). Can
you help me with the right formula?

Col A Col B

North 1
South 4
East 2
West 3
South 6
South 5
North 4
North 2
West 1
East 2
North 6