Hello Excel Forum,
I'm trying to replace a column consisting of codes (such as A1.1 or C1.6) with text that corresponds to each of those codes (so say A1.1 = John and C1.6 = Mary). Most codes appear more than once and in no particular order.
I've got another table that documents how those codes correspond with all the codes in column A and corresponding text in column B.
How can I automatically the column of codes with the corresponding texts according to the correspondencies defined in my second table?
Thanks so much for your help!
Bookmarks