+ Reply to Thread
Results 1 to 2 of 2

Vlookup only once when data set contains multiple occurrences of unique value

  1. #1
    Registered User
    Join Date
    12-13-2013
    Location
    Columbus Ohio
    MS-Off Ver
    Excel 2010
    Posts
    3

    Vlookup only once when data set contains multiple occurrences of unique value

    I've got a data set that contains multiple occurrences of the unique value that I need to use to perform my Vlookup, but I only want to perform the Vlookup once. Example below, I only want to perform the Vlookup for the 1st or last occurrence of each unique value.

    4353378
    4353378
    4353378
    4353378
    4353378
    4353378
    4353378
    4353378
    4353378
    4353378
    4353378
    4353378
    4353378
    4353421
    4353421
    4353421
    4353421
    4353421
    4353421
    4353421
    4354353
    4354353
    4354353
    4354353
    4354353
    4354353
    4354353
    4354353
    4354353
    4354353
    4354353
    4354353
    4354353
    4354353
    4354353
    4354353


    Thanks,

    David

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,604

    Re: Vlookup only once when data set contains multiple occurrences of unique value

    You have a response at your other post - please do not multi-post (see Forum Rule 05 at the top of the screen).

    Pete

+ 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. How to find multiple occurrences with a vlookup
    By DawsonG in forum Excel General
    Replies: 1
    Last Post: 08-14-2014, 01:11 PM
  2. [SOLVED] VLookup return sum of multiple occurrences
    By excelMTL in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 12-03-2012, 03:32 PM
  3. [SOLVED] how do I use vlookup for multiple occurrences of the same value
    By Edith F in forum Excel Formulas & Functions
    Replies: 18
    Last Post: 10-13-2011, 06:37 PM
  4. Counting unique occurrences with multiple criteria
    By moki311 in forum Excel General
    Replies: 2
    Last Post: 01-05-2010, 04:24 PM
  5. [SOLVED] RE: how do I use vlookup for multiple occurrences of the same value
    By bj in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 04-27-2005, 06:06 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