Thread: Data Matching
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Demosthenes Demosthenes is offline
external usenet poster
 
Posts: 36
Default Data Matching

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!