Hi All

Is there a formula that looks up a value in a cell in another
worksheet, and returns the values immediately next to it?

What I mean is, I have a sheet that looks like this

Col A    Col B    Col C

x              a          1
x              b          2
x              c           5
y              j           4
y              u           8
y              k           4
z              t            3
z              l            5

I have 3 worksheets, one for each of the values in col a (x, y, z).
What I want to be able to do is, pull the values in col b, into it's
relevant worksheet. So in effect, like a vlookup but something that
looks for a value in a cell, and returns all the values associated with
that in another worksheet.

Any help?

Many thanks

Ozkan