Excel converting a code to an abbrevation

%3CLINGO-SUB%20id%3D%22lingo-sub-1859149%22%20slang%3D%22en-US%22%3EExcel%20converting%20a%20code%20to%20an%20abbrevation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1859149%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20someone%20advise%20how%20to%20do%20this%3F%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20a%20list%20of%20codes%20that%20I%20would%20like%20excel%20to%20recognize%20and%20convert%20to%20the%20name%20of%20the%20product.%26nbsp%3B%3C%2FP%3E%3CP%3EEx.%20402A59%20converts%20to%20name%20Widget.%3C%2FP%3E%3CP%3EHow%20can%20I%20do%20that%3F%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20is%20a%20report%20I%20create%20every%20morning%20and%20would%20save%20a%20ton%20of%20time.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1859149%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1862201%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20converting%20a%20code%20to%20an%20abbrevation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1862201%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F859432%22%20target%3D%22_blank%22%3E%40bcooney%3C%2FA%3E%2C%3C%2FP%3E%3CP%3EDo%20you%20have%20a%20table%20with%20all%20the%20codes%20and%20names%3F%20If%20so%2C%20you%20should%20use%20vlookup()%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Bennadeau_0-1604690719594.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F231928i820A16DD375BA014%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Bennadeau_0-1604690719594.png%22%20alt%3D%22Bennadeau_0-1604690719594.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hello, 

Can someone advise how to do this? 

I am a list of codes that I would like excel to recognize and convert to the name of the product. 

Ex. 402A59 converts to name Widget.

How can I do that? 

This is a report I create every morning and would save a ton of time. 

1 Reply

Hi @bcooney,

Do you have a table with all the codes and names? If so, you should use vlookup()

 

Bennadeau_0-1604690719594.png