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.