Need help re how to insert text in a column using key codes

Solved2.61K viewsFormulas and Functions

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.


Hi – I took a quick stab at this. I think you can do what you want with a SELECT statement. See attached.


You are viewing 1 out of 4 answers, click here to view all answers.