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!