+ Reply to Thread
Results 1 to 2 of 2

Vlookup skipping previous results

  1. #1
    Registered User
    Join Date
    11-22-2011
    Location
    Columbus, OH
    MS-Off Ver
    Excel 2010
    Posts
    1

    Vlookup skipping previous results

    I'm having trouble grabbing data with a vlookup without duplicating data results. My data sheet has 2 columns: Column 1 has a # either 1,2, or 3 that is assigned to independent data labels in column 2. My data has about approx. 50 rows with 1, 2, or 3 assigned to mulltiple rows. I'm trying to do a vlookup that grabs all the results for one number (2) and provide the data label in column 2. The first result works, but when I copy the formula down my results column I get duplicate results because I believe there are blank rows in my data that I have to leave.

    Does anyone have a solution? If further clarification is need let me know. Thank you in advance.

  2. #2
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2021
    Posts
    4,361

    Re: Vlookup skipping previous results

    Hello J_le4
    Welcome to the forum.
    It is better to post a dummy workbook (Atachement) so that someone may get interested to look at it.
    I think people forget the word "THANK YOU!!!!" Do you still know it???

    There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "

    Regards,
    Vladimir

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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