Data Matching
 

Hello,

I have a question. I have two sets of data - one large and one small. The
large one has metadata, and the small one fits entirely inside the large one.
I need to separate out the metadata from the large set for just the entries
in the small set. For example, say I have these three columns:

abc 123 123
bcd 234 567
cde 456 678
def 567 901
efg 678 012
fgh 789
ghi 890
hij 901
ijk 012
jkl 321
klm 432

Where column A is the metadata, column B is the large set, and column C is
the small set. I want to create another column (or two columns) that match
the data in column C with that in column A. So the output that I want looks
like this:

abc 123
def 567
efg 678
hij 901
ijk 012

In other words, I want the metadata from column A to match with the data in
column C. I can't just do a sort, because column C is missing some numbers.
Does anyone have any thoughts for how to do this?

Thanks for your help,

Data Matching
 

I copied your first table to a new worksheet sating in A1
I copied the third column of this to column G (so G1 has 123)
In F1 I entered the formula =INDEX(A:A,MATCH(G1,B:B,0)) and copied it down
the column
This gave me the second of your tables
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
"Demosthenes" wrote in message
...
Hello,

I have a question. I have two sets of data - one large and one small. The
large one has metadata, and the small one fits entirely inside the large
one.
I need to separate out the metadata from the large set for just the
entries
in the small set. For example, say I have these three columns:

abc 123 123
bcd 234 567
cde 456 678
def 567 901
efg 678 012
fgh 789
ghi 890
hij 901
ijk 012
jkl 321
klm 432

Where column A is the metadata, column B is the large set, and column C is
the small set. I want to create another column (or two columns) that match
the data in column C with that in column A. So the output that I want
looks
like this:

abc 123
def 567
efg 678
hij 901
ijk 012

In other words, I want the metadata from column A to match with the data
in
column C. I can't just do a sort, because column C is missing some
numbers.
Does anyone have any thoughts for how to do this?

Thanks for your help,