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.

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.