+ Reply to Thread
Results 1 to 1 of 1

VLookup Duplicate Values

  1. #1
    Registered User
    Join Date
    07-20-2011
    Location
    Chicago
    MS-Off Ver
    Excel 2007, 2010
    Posts
    3

    VLookup Duplicate Values

    I am attempting to automate a portion of a risk analysis process for my job. I would like to automate the process of pulling codes into a matrix and placing them based on risk calculations. I have assigned each quadrant in the matrix a number (1-25) and used a series of if statements to assign each code a quadrant number. I then want to use a VLookup type formula to pull each code into the appropriate quadrant cell and seperate multiple codes in the same cells with commas. However, VLookup will only pull the first code for a quadrant and will drop all others. I have done a lot of research and it seems that I need to use the index and match functions, or a LookupAll funtcion. Unfortunately, I have tried a multitude of times and can't get either function to work. The data set is two columns. In column A (the quandrant numbers) a data set could be any numbers 1-25 depending on the risk calculations (typically would have several duplicates). Column B would have unique codes (one alphanumeric, two numeric) that need to be pulled into the matrix. I listed an example data set below. I've also attached the workbook. If anyone could tell me how to pull the codes in column B to cells based on the correlating data in column A while allow the function to pull codes with duplicates in column A and display them in the same cell seperated by commas I would really appreciate it. Thanks, Mark.

    Column A -
    2
    13
    14
    9
    5
    25
    22
    9
    13
    9

    Column B -
    S01
    S02
    S03
    S04
    S05
    C01
    C02
    C03
    C04
    C05
    Attached Files Attached Files
    Last edited by markd87; 07-20-2011 at 01:14 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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