+ Reply to Thread
Results 1 to 4 of 4

Vlookup to only pick up 1 value when duplicate references

  1. #1
    Registered User
    Join Date
    11-15-2016
    Location
    Denver
    MS-Off Ver
    7 Professional
    Posts
    2

    Vlookup to only pick up 1 value when duplicate references

    I have a column list of about 3,000 which has duplicates but cannot be deleted out as each one of the columns has a unique reference to it. I need to use a vlookup function to assign a value to this set of columns, but I only want the value to appear on one of the duplicate variables....And it does matter which one.

    Thanks in advance!


    Lookup.PNG

  2. #2
    Forum Contributor
    Join Date
    09-18-2015
    Location
    Republic of Korea
    MS-Off Ver
    2010
    Posts
    314

    Re: Vlookup to only pick up 1 value when duplicate references

    I don't know if it's what you want ...

    Name=Assuming it is column A ...
    =if(countif($A$2:A2,A2)=1,A2,"")

  3. #3
    Forum Expert
    Join Date
    04-01-2013
    Location
    East Auckland
    MS-Off Ver
    Excel 365
    Posts
    1,340

    Re: Vlookup to only pick up 1 value when duplicate references

    maybe

    Please Login or Register  to view this content.
    and fill down

    Assuming name is in column A, I added the vlookup in there too - obviously replace that with yours.
    If you want something done right... find a forum and ask an online expert.

    Time flies like an arrow. Fruit flies like a banana.

  4. #4
    Registered User
    Join Date
    11-15-2016
    Location
    Denver
    MS-Off Ver
    7 Professional
    Posts
    2

    Re: Vlookup to only pick up 1 value when duplicate references

    Thanks - This works a treat!

+ 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] Vlookup/Index Match with Duplicate references
    By meadnl89 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-01-2016, 01:12 PM
  2. Returning values for duplicate references
    By AlexnL12 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-21-2015, 01:05 PM
  3. [SOLVED] How to pick last appointment date in client list with duplicate clients
    By AllisonT in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-02-2014, 03:17 PM
  4. Deleting duplicate references with certain criteria
    By AlexnL12 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-09-2014, 08:56 AM
  5. Need Macro that will pick multiple criteria from duplicate values
    By jonnic14 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-02-2012, 12:11 AM
  6. Replies: 7
    Last Post: 07-09-2012, 09:25 PM
  7. Code to pick up unique references in a cell from a different worksheet
    By fusion007 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-07-2011, 09:53 PM

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