+ Reply to Thread
Results 1 to 4 of 4

Assigning multiple (!) numbers to text

  1. #1
    Registered User
    Join Date
    05-22-2013
    Location
    Babylon, Nowhere
    MS-Off Ver
    Excel 2003
    Posts
    9

    Smile Assigning multiple (!) numbers to text

    Good morning fellows,

    I am searching now already quite a bit on the web and in this forum but was not able to find a solution.

    I am trying to assign reference numbers to company names (text). The problem is that each company has multiple numbers assigned. Now, I would like to assign to each company all the reference numbers out there in my excel file. I found now the vlookup-formula here in the forum, but that one only chooses one of the reference numbers. I need all of them.

    I attached my file.
    Column A: Company names
    Column B/C/D: Place to assign numbers
    Column E+F: Company names plus reference numbers.
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    01-03-2011
    Location
    Bucharest
    MS-Off Ver
    Excel 2010
    Posts
    19

    Re: Assigning multiple (!) numbers to text

    Hi!
    If your files has the same information use =CONCATENATE(A3;E3) than apply vlookup formula.

  3. #3
    Registered User
    Join Date
    05-22-2013
    Location
    Babylon, Nowhere
    MS-Off Ver
    Excel 2003
    Posts
    9

    Re: Assigning multiple (!) numbers to text

    Hi kalergy,
    thank you for your advice, but I dont understand actually. '=CONCATENATE(A3;E3)' only puts the content of these cells into one cell. I still have the problem then that Excel does not assigns me all the reference numbers but just one of them. Or did I misunderstand you? Cheers

  4. #4
    Registered User
    Join Date
    05-22-2013
    Location
    Babylon, Nowhere
    MS-Off Ver
    Excel 2003
    Posts
    9

    Re: Assigning multiple (!) numbers to text

    I actually just found an answer. It is a bit complicated though. To find here --> http://www.get-digital-help.com/2009...okup-in-excel/

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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