Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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, |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Data Matching
Hi,
Try this =index($A$1:$B$11,match($C1,$B$1:$B$11,0),1) -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "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, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Enter Data on one tab, then find matching data on another tab | Excel Worksheet Functions | |||
Matching a column of new data to existing larger data set. | Excel Worksheet Functions | |||
Matching identical data using data only once in the matching proce | Excel Discussion (Misc queries) | |||
Can I merge data in 2 sheets matching rows of data by last name? | Excel Discussion (Misc queries) | |||
Matching data and linking it to the matching cell | Links and Linking in Excel |