+ Reply to Thread
Results 1 to 5 of 5

Vlookup with duplicate Lookup values

  1. #1
    Registered User
    Join Date
    02-19-2015
    Location
    Florida
    MS-Off Ver
    2010
    Posts
    3

    Vlookup with duplicate Lookup values

    I have a large worksheet ("All Journals Working Copy",) that list all of our items numbers and inventory related stats. Item numbers (Column A) are repeated as we have many warehouses. I have a second worksheet (Item Master Download) on the same spreadsheet (range named "data") that has two pieces of information for each item number that I need to bring over to the first worksheet. Each unique item number although may be repeated but has only one "description" and one "item group" from the "data" range on my second worksheet (Item Master Download). I am not able to do a regular VLookup because many of the item numbers are repeated (due to the same item number being listed separately for multiple warehouses). I am trying to bring the "description" from "Item Master Download" into column B on my "All Journals Working Copy". Every item number listed on "All Journals Working Copy" appear only once on the "Item Master Download".

    How can I bring over the corresponding information from the second worksheet "data"? I hope I have provided enough information. Once I am able to do this I will then do a pivot table but I can't run the pivot table until I bring in the values need.

  2. #2
    Forum Expert
    Join Date
    09-11-2014
    Location
    Washington, DC
    MS-Off Ver
    2016
    Posts
    1,907

    Re: Vlookup with duplicate Lookup values

    You can do multi column/row lookups using INDEX/MATCH and the & (concatenate) operator, but without a sample workbook it is hard to give specific help.
    Spread the love, add to the Rep

    "None of us are as smart as all of us."

  3. #3
    Registered User
    Join Date
    02-19-2015
    Location
    Florida
    MS-Off Ver
    2010
    Posts
    3

    Re: Vlookup with duplicate Lookup values

    The spreadhseet is 12MB so it won't let me upload it. Any suggestions?

  4. #4
    Forum Expert
    Join Date
    09-11-2014
    Location
    Washington, DC
    MS-Off Ver
    2016
    Posts
    1,907

    Re: Vlookup with duplicate Lookup values

    Can you cut out the data portion that you are asking the question about, and desensitize your data? This should reduce the size limit.

  5. #5
    Registered User
    Join Date
    02-19-2015
    Location
    Florida
    MS-Off Ver
    2010
    Posts
    3

    Re: Vlookup with duplicate Lookup values

    Here is a portion of the worksheet.
    Attached Files Attached Files

+ 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] PLEASE HELP: Return Duplicate Values with V-lookup
    By Funky_Finance in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-23-2014, 12:24 AM
  2. Using approximate lookup and getting duplicate returned values
    By nikkigotro in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-16-2013, 02:54 PM
  3. [SOLVED] conditional lookup for duplicate values
    By Abhi1687 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-22-2013, 04:39 PM
  4. [SOLVED] Lookup + Duplicate Values
    By keithmacd in forum Excel General
    Replies: 4
    Last Post: 06-12-2012, 07:49 PM
  5. Need help on how to lookup values that duplicate
    By Pat Parker in forum Excel General
    Replies: 4
    Last Post: 01-26-2012, 11:56 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