Excel

a 1    a 234
b 2    b 23
c 3    d 234
d 5    f 55
e 6
f 2

VLOOKUP is the method to match values of one to another.
Used for aligning tables of translations. Where we have GUID + text in one language, and GUID + text in other language, and some texts are not present in other language