+ Reply to Thread
Results 1 to 5 of 5

Creating a Name List in Excel that correllates to a specific number.

  1. #1
    Registered User
    Join Date
    08-06-2013
    Location
    San Jose, CA
    MS-Off Ver
    Excel 2007
    Posts
    3

    Creating a Name List in Excel that correllates to a specific number.

    I need help on how to create a formula that will assign a name to a specific number. I will be uploading bar code data to excel and each barcode is assigned a specific number, I then need this number to be replaced with a Name. For example Number 1000 - should be assigned to John Smith. The first column will have the number, the second column will have the data and I would like the third column to have the correlating name. Can anyone help me with this?

  2. #2
    Forum Guru tigeravatar's Avatar
    Join Date
    03-25-2011
    Location
    Colorado, USA
    MS-Off Ver
    Excel 2003 - 2013
    Posts
    5,361

    Re: Creating a Name List in Excel that correllates to a specific number.

    mjrod0721,

    Welcome to the forum!
    Create a table with the numbers and their corresponding names and then use a vlookup formula
    Hope that helps,
    ~tigeravatar

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

  3. #3
    Registered User
    Join Date
    08-06-2013
    Location
    San Jose, CA
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Creating a Name List in Excel that correllates to a specific number.

    tigervatar,

    Thank you for your reply. Can you explain in more details how I would create a table with the numbers and the corresponding names and then us a "vlookup" formula? I do not know anything about "vlookup." Thank you.

  4. #4
    Forum Guru tigeravatar's Avatar
    Join Date
    03-25-2011
    Location
    Colorado, USA
    MS-Off Ver
    Excel 2003 - 2013
    Posts
    5,361

    Re: Creating a Name List in Excel that correllates to a specific number.

    Here's a link to a tutorial on how to use Vlookup:
    http://spreadsheets.about.com/od/exc...320vlookup.htm

    Also, attached is an example workbook based on the criteria you described.
    The vlookup table is in G3:H5 and this formula is in cell C2 and copied down:
    Please Login or Register  to view this content.

    You can see how it looks up the number in the table I made and returns the corresponding name.
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    08-06-2013
    Location
    San Jose, CA
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Creating a Name List in Excel that correllates to a specific number.

    tigervatar,

    Thank you for your reply. I will take a look at this and make sure I understand.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Creating random numbers that add up to a specific number
    By PapaCheese in forum Excel General
    Replies: 1
    Last Post: 06-13-2012, 07:00 PM
  2. Creating a Marco to Replace a Specific Number with a Specific Letter in a Column
    By goldbeje in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-27-2011, 11:26 AM
  3. Replies: 15
    Last Post: 06-26-2011, 09:10 PM
  4. Creating a formula to find the first specific number of characters from a description
    By visionwindowfilms in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-18-2011, 03:41 AM
  5. Replies: 1
    Last Post: 12-22-2005, 11:10 AM

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