adjust to fit.looking in col J for a match in col K and returning col I
=INDEX(I:I,MATCH(K1,J:J))

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Demosthenes" wrote in message
...
Hello,

I have a question. I have two sets of data, one of which is contained in
the
other. The problem is, the big set has additional data that I want to
isolate
for the shorter data set. For example:

a 123 123
b 234 789
c 345 234
a 456 890
b 567
c 678
a 789
b 890

where column A is the additional data, column B is the large set, and C is
the small set. I want to pull out the instances where the data in a single
cell in column C matches any single cell in column B. My result is:

123 a
789 a
234 b
890 b

Can anyone give me any ideas? I'm really stuck here. Thanks!