Look up ???

[kennyken]

Hi

I have a list of data eg :


A B
1 a
1 b
2 c
2 d
2 e
3 f

What I want to do is if someone on another sheet enters a value (say 2) then it would return a list of all those values in column b where the value matches column a

Any help would be much appreciated as this is driving me mad at the moment

Thanks

K.

a

[Badger04]

Hi K

Where the user picks a value, would this be via a drop down list?
The values to return, is this to be shown on another drop down list?

Badger

[kennyken]

Hello Badger

Yes the first value is from a validation list . The results would not need to be a drop down list but simply a column of results . eg in the above example I would see

c
d
e

Thanks

K.