+ Reply to Thread
Results 1 to 7 of 7

Vlookup or Index Match to populate multiple values

  1. #1
    Registered User
    Join Date
    02-16-2015
    Location
    Chennai
    MS-Off Ver
    2013
    Posts
    39

    Vlookup or Index Match to populate multiple values

    Hi..
    I am working on a file and trying to match the two columns. But thing is the entries in column 1 and column 2 are not unique. They are repeating, to avoid the confusion, I am taking help of another column containing Index values. Now I am using Index Match to populate the corresponding index value..But I am not getting the results..

    vlookup trial.JPG
    Here Column 1 has got some values and column 2 has got some values.. I want to match them..For that I am having index value column

    Thanks in advance for help..!!
    Attached Files Attached Files
    Last edited by HB07; 03-27-2015 at 08:37 AM.

  2. #2
    Forum Moderator Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Vlookup or Index Match to populate multiple values

    You get your desired result with this formula, but i am not sure if this is what you mean.In E2 and copy down.

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.

  3. #3
    Registered User
    Join Date
    02-16-2015
    Location
    Chennai
    MS-Off Ver
    2013
    Posts
    39

    Re: Vlookup or Index Match to populate multiple values

    Fortis..My apology..I didnt make my question clear in the first place..This is what i want..If I use If(A2=B2,c2,"") .It wont work here..

  4. #4
    Forum Moderator Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Vlookup or Index Match to populate multiple values

    Unfortunately iam not able to understand the logic of the expected result. Sorry. Good luck.

  5. #5
    Registered User
    Join Date
    02-16-2015
    Location
    Chennai
    MS-Off Ver
    2013
    Posts
    39

    Re: Vlookup or Index Match to populate multiple values

    Okay Fortis..Thanks for giving a try..!!

  6. #6
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2211
    Posts
    36,756

    Re: Vlookup or Index Match to populate multiple values

    I think you need to explain in more detail WHY you want the desired values, with reference to what is in columns A & B.
    Glenn



  7. #7
    Registered User
    Join Date
    02-16-2015
    Location
    Chennai
    MS-Off Ver
    2013
    Posts
    39

    Re: Vlookup or Index Match to populate multiple values

    Hi Glenn. Actually I am trying to match the failure modes and causes of two systems. The idea is that if they match..then I should count number of matches and,if they dont then i need to count the number of failure modes than dont match.. The list of failure modes run into 1000 line items.
    Glenn_example.JPG

    Please go through the snapshot. For same failure modes...there'll be causes and controls for System A & System B. I want to match the causes..I'll attach the excel file also for your consideration.
    Attached Files Attached Files
    Last edited by HB07; 03-30-2015 at 05:51 AM.

+ 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. Returning multiple distinct/repeating values for vlookup or index-match
    By amatvien in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 08-21-2018, 01:14 PM
  2. Replies: 3
    Last Post: 05-19-2014, 02:01 PM
  3. [SOLVED] Formula (VLOOKUP vs INDEX & MATCH) to return multiple values in the same column
    By wfidler in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-06-2012, 07:04 PM
  4. Replies: 7
    Last Post: 08-10-2010, 04:05 PM
  5. Populate listbox using vlookup or index,match?
    By sarahng86 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-31-2007, 08:42 AM

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