Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data matching
Hello, this is my first time here, I am looking for some help with data
matching. I have a list of numbers (they happen to be 6 digits) and they correspond to other numbers, but more importantly, I have another sheet with a key of those numbers, which correspond to strings. In case you're wondering why, I have to align the matches in the first list so that it can be formatted into another string command parsed with the list of places. Someone I know has suggested MS Access. Specifically this is what I would like to accomplish Eg. key: AA 1 BB 2 CC 3 Other list 1 2 hello 2 1 bye 3 1 byehello 3 2 hellobye the final step would want to look like AA BB hello BB AA bye CC AA byehello CC BB hellobye And eventually I would make an excel formula to the effect of =A1&A2&A3 Sorry for the longwindedness, any suggestions or directions are appreciated. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data matching
First list (key) in A1 to B3
Second list in A6 to B9 Final list in A12 to C15: A12: =INDEX($A$1:$A$3,MATCH(A6,$B$1:$B$3,0)) B12:= =INDEX($A$1:$A$3,MATCH(B6,$B$1:$B$3,0)) C12: =C6 Copy these down HTH "Kordasn" wrote: Hello, this is my first time here, I am looking for some help with data matching. I have a list of numbers (they happen to be 6 digits) and they correspond to other numbers, but more importantly, I have another sheet with a key of those numbers, which correspond to strings. In case you're wondering why, I have to align the matches in the first list so that it can be formatted into another string command parsed with the list of places. Someone I know has suggested MS Access. Specifically this is what I would like to accomplish Eg. key: AA 1 BB 2 CC 3 Other list 1 2 hello 2 1 bye 3 1 byehello 3 2 hellobye the final step would want to look like AA BB hello BB AA bye CC AA byehello CC BB hellobye And eventually I would make an excel formula to the effect of =A1&A2&A3 Sorry for the longwindedness, any suggestions or directions are appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I merge data in 2 sheets matching rows of data by last name? | Excel Discussion (Misc queries) | |||
Matching data. | New Users to Excel | |||
matching data | New Users to Excel | |||
matching data | New Users to Excel | |||
Matching data and linking it to the matching cell | Links and Linking in Excel |