How can I have Excel pull up a value in another workbook based on text input?
Posted on 2011-02-25
I have a workbook with two columns, one with a persons last name, and one with a number associated with them:
Col. A Col. B
I want to link new workbooks to this master document, so when I type a name (like Baker) into a cell, the cell to the right of that autopopulates with the number value from the master workbook.
How do I do this?