+ Reply to Thread
Results 1 to 8 of 8

Assign single number to duplicate values according to a column

Hybrid View

  1. 07-18-2013, 04:05 AM #1
    DonAx
    DonAx is offline
    Registered User
    Join Date
    02-27-2012
    Location
    Chisinau, Moldova
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    11

    Exclamation Assign single number to duplicate values according to a column

    I have a table with codes of the countries in Sheet2. In Sheet1 I have some name of the countries that are without codes.....please help me to fill in the column B (Sheet1) with data matched in Sheet2.
    Thanks

    Find attached exel file.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 07-18-2013, 04:07 AM #2
    Pepe Le Mokko
    Pepe Le Mokko is offline
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2504
    Posts
    13,620

    Re: Assign single number to duplicate values according to a column

    Hi
    try using VLOOKUP
    How to paste Power Query code ( by Olly)
    Reply With QuoteRegister To Reply
  3. 07-18-2013, 04:20 AM #3
    DonAx
    DonAx is offline
    Registered User
    Join Date
    02-27-2012
    Location
    Chisinau, Moldova
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    11

    Re: Assign single number to duplicate values according to a column

    I tried but something goes wrong and i don't know what....

    Can somebody just type the formula....
    Thank you in advance.
    Reply With QuoteRegister To Reply
  4. 07-18-2013, 04:22 AM #4
    Pepe Le Mokko
    Pepe Le Mokko is offline
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2504
    Posts
    13,620

    Re: Assign single number to duplicate values according to a column

    What have you tried and what went wrong?
    Reply With QuoteRegister To Reply
  5. 07-18-2013, 04:33 AM #5
    Rambo4711
    Rambo4711 is offline
    Forum Contributor
    Join Date
    07-02-2013
    Location
    Stockholm, Sweden
    MS-Off Ver
    Excel 2003 and 2007
    Posts
    197

    Re: Assign single number to duplicate values according to a column

    in cell B2: =VLOOKUP(A2,Sheet2!A:B,2,FALSE)
    Copy the formula down
    Reply With QuoteRegister To Reply
  6. 07-18-2013, 04:45 AM #6
    Rambo4711
    Rambo4711 is offline
    Forum Contributor
    Join Date
    07-02-2013
    Location
    Stockholm, Sweden
    MS-Off Ver
    Excel 2003 and 2007
    Posts
    197

    Re: Assign single number to duplicate values according to a column

    =VLOOKUP(A2,ccodes,2,FALSE) should also be workong
    Reply With QuoteRegister To Reply
  7. 07-18-2013, 04:31 AM #7
    DonAx
    DonAx is offline
    Registered User
    Join Date
    02-27-2012
    Location
    Chisinau, Moldova
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    11

    Re: Assign single number to duplicate values according to a column

    I named table from Sheet2 ccodes

    i wrote
    =vlookup(A1,ccodes,2,false)

    is it right?
    Reply With QuoteRegister To Reply
  8. 07-18-2013, 04:44 AM #8
    DonAx
    DonAx is offline
    Registered User
    Join Date
    02-27-2012
    Location
    Chisinau, Moldova
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    11

    Re: Assign single number to duplicate values according to a column

    It works perfectly thank you!!!!!!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Assign single number to duplicate values in column
    By excelresumes in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-19-2013, 06:05 PM
  2. Counting the number of fields in a column for which there are duplicate values.
    By sangreal2007 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-24-2013, 03:59 AM
  3. [SOLVED] sort column based on number of duplicate values
    By mcdermott2 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-03-2013, 12:35 PM
  4. [SOLVED] Need Urgent help on Adjacent values of Duplicate column values should be be in single row.
    By anto_01 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-11-2012, 09:55 PM
  5. [SOLVED] Finding Duplicate values within a single column
    By Ed P in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-16-2005, 07:06 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1