+ Reply to Thread
Results 1 to 6 of 6

Using Vlookup for duplicated numbers

  1. #1
    Registered User
    Join Date
    08-07-2010
    Location
    London,England
    MS-Off Ver
    Excel 2007
    Posts
    7

    Cool Using Vlookup for duplicated numbers

    Hi everyone,

    I am trying to vlookup the numbers in column titled branch to return same for cif but excel is returning the first cif number where the branch numbers are duplicated as follows:

    Branch Cif Excel Results (Cif)
    304620 308203 308203
    304620 308055 308203
    304620 306207 308203
    452546 228901 228901
    305552 302398 302398
    305552 181381 302398
    305239 306863 306863

    Please what logical formulas can i use to get around this lack of unique numbers.

    Many thanks for you assistance.

    Folarin
    Last edited by fodejimi; 05-12-2011 at 09:20 AM.

  2. #2
    Forum Expert Domski's Avatar
    Join Date
    12-14-2009
    Location
    A galaxy far, far away
    MS-Off Ver
    Darth Office 2010
    Posts
    3,950

    Re: Using Vlookup for duplicated numbers

    What is the result you actually require?

    A sample workbook showing the formula you are using and the result that you want would probably help a great deal.

    Dom
    "May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."

    Use code tags when posting your VBA code: [code] Your code here [/code]

    Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.

  3. #3
    Registered User
    Join Date
    08-07-2010
    Location
    London,England
    MS-Off Ver
    Excel 2007
    Posts
    7

    Re: Using Vlookup for duplicated numbers

    Hi everyone,

    I am trying to vlookup the numbers in column titled branch to return same for cif but excel is returning the first cif number where the branch numbers are duplicated as per the attached spreadsheet:

    Please what logical formulas can i use to get around this lack of unique numbers.

    Many thanks for you assistance.

    Folarin
    Attached Files Attached Files

  4. #4
    Valued Forum Contributor
    Join Date
    07-29-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2003/Excel 2010
    Posts
    534

    Re: Using Vlookup for duplicated numbers

    One way to get the result:
    Attached Files Attached Files

  5. #5
    Forum Expert Domski's Avatar
    Join Date
    12-14-2009
    Location
    A galaxy far, far away
    MS-Off Ver
    Darth Office 2010
    Posts
    3,950

    Re: Using Vlookup for duplicated numbers

    Vlookup will always return the first match that it finds in a list.

    Have a look at this article in the section Arbitrary Lookups if you want to return the nth result from a table.



    Dom

  6. #6
    Registered User
    Join Date
    08-07-2010
    Location
    London,England
    MS-Off Ver
    Excel 2007
    Posts
    7

    Thumbs up Re: Using Vlookup for duplicated numbers

    Hi guys,

    The attachment from WHER did the job and the articles from Domski was very helpful.

    Many thanks indeed!

+ 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