+ Reply to Thread
Results 1 to 3 of 3

Return Unique data using mutliple but same ID in V - Look up. Help!!!!

  1. #1
    Registered User
    Join Date
    08-18-2013
    Location
    Johannesburg
    MS-Off Ver
    Excel 2007
    Posts
    1

    Cool Return Unique data using mutliple but same ID in V - Look up. Help!!!!

    Hi guys. Need help please. I need to extract unique data with multiple but same id in v look up.
    Problem is when i do the v look up, it only returns the first instance of the ID's and not multiple.

    How can i get around this?

  2. #2
    Forum Expert RobertMika's Avatar
    Join Date
    06-22-2009
    Location
    Haverhill, UK
    MS-Off Ver
    Excel 2003-13
    Posts
    1,530

    Re: Return Unique data using mutliple but same ID in V - Look up. Help!!!!

    Could you post your workbook with desired result?
    If you are http://www.excelforum.com/image.php?type=sigpic&userid=125481&dateline=1392355029happy with the results, please add to the contributor's
    reputation by clicking the reputation icon (star icon).




    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved.
    To undo, select Thread Tools-> Mark thread as Unsolved.
    http://www.excelaris.co.uk

  3. #3
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Return Unique data using mutliple but same ID in V - Look up. Help!!!!

    There's an example here:

    http://www.excelforum.com/excel-form...ell-value.html
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

+ 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. [SOLVED] insert row where unique identifier has mutliple columns
    By shaz0503 in forum Excel General
    Replies: 2
    Last Post: 02-10-2013, 11:12 PM
  2. [SOLVED] Mutliple criteria lookup to return a value
    By JIMH1980 in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 10-18-2012, 08:00 AM
  3. Replies: 1
    Last Post: 10-16-2012, 10:59 AM
  4. Return Single Value from Mutliple Criteria
    By Doogs2009 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-01-2010, 05:10 AM
  5. lookup mutliple values to return one value
    By David Pelizzari, IS Manager in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-06-2006, 09:35 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1