+ Reply to Thread
Results 1 to 4 of 4

Assigning numbers to text possible?

  1. #1
    Registered User
    Join Date
    09-06-2019
    Location
    Nl
    MS-Off Ver
    Na
    Posts
    3

    Assigning numbers to text possible?

    Basically i have a list of 200+ products that i frequently need to input in excel. Is there a way to assign numbers to these products so I dont have to write them out every time. For example if i want D2 to say "Coca-cola 1L Bottle", instead of writing it out I want to be able to type "13" and for the productname "Coca-cola 1L Bottle" to show up. If you guys could help in any way I would much appreciate it. Thank you.

    PS: Im not very familiar with Excel so you might want to put me in a boosterseat and talk to me like im 5yo Xd

  2. #2
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Excel for Windows & Mac - all versions.
    Posts
    25,506

    Re: Assigning numbers to text possible?

    Hi and welcome to the forum

    Create a two column table, say A1:B200 on say Sheet1 but it could be anywhere of course.
    In the first column enter your references like "13" and in the second column enter the product description.

    Then you can use the following formula to return the description

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Better still apply a name to the table in A1:Bnnn, say "Data"
    Then the formula would be

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Richard Buttrey

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Registered User
    Join Date
    09-06-2019
    Location
    Nl
    MS-Off Ver
    Na
    Posts
    3

    Re: Assigning numbers to text possible?

    Thank you for the reply good sir. That looks pretty straight forward. Ill try it as soon as im in the office on Monday (dont have excel at home). I appreciate the fast and clear answer. You're a lifesaver!

  4. #4
    Registered User
    Join Date
    09-06-2019
    Location
    Nl
    MS-Off Ver
    Na
    Posts
    3
    I love you my dude. Straight up worked like a charm

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1