Hi everyone. New user here, so apologies if this sounds like a juvenile question. I've tried looking this up online, and can't seem to figure it out. Maybe I'm not using the right keywords, but here goes.
I'm working on some pivot tables, but the column I need isn't available and I need to create a new one. Currently, one of the columns I have is a bunch of product codes. Each product code has a corresponding name, which I have on paper.
For example, let's say this is Column A with the product codes:
HB192948
HB106805
HX109581
HB106805
HB192948
HR181758
I need to match each code to the name, and create a new Column B to look like this:
Chaser 9000
Ramp Free
Night Time 108
Ramp Free
Chaser 9000
Free Agent New
I figure I can just copy the entire produce code column and paste onto a new sheet and use Find>Replace, then copy and insert that new column back into my original sheet again. However, I'm wondering if there's a simpler, faster way to do this?
Bookmarks