Matrix A is 2 columns: A1 = key code, A2 = text.
Matrix B is 2 columns, including B1 = key code, B2 = blank. Matrix B has many more rows than Matrix A — i.e. with repeats of the key codes.
I need a function to populate column B2 with the text from A1 corresponding to its key code.
How to do it may be obvious, and I’m just not seeing it. Can you help?
Thanks in advance.