a 1 a 234
b 2 b 23
c 3 d 234
d 5 f 55
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