+ Reply to Thread
Results 1 to 2 of 2

Index match for the following scenario

  1. 06-26-2018, 04:36 PM #1
    excel25newbie
    excel25newbie is offline
    Registered User
    Join Date
    06-26-2018
    Location
    London
    MS-Off Ver
    office 365
    Posts
    1

    Index match for the following scenario

    I have the following scenario
    1.PNG


    I am using the following formula

    =INDEX($A$1:$B$12,MATCH(C1,$B$1:$B$12,0),1)

    to perform something like
    Name 5 in Column C, should print oimnlu in Column D, based on Name 5 value in Column B.

    This works fine as long as there are no dupes in Column B and Column C

    When we have dupes, for example Column B and C has Name8 as dupe
    In this case I would like qqweq and jkhjkh to be printed in Column D for each Name8 in column C, but currently it prints qqweq for both the name8.

    How do I achieve what I am after please?

    Thanks
    Reply With QuoteRegister To Reply
  2. 06-26-2018, 04:39 PM #2
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,939

    Re: Index match for the following scenario

    Hi, welcome to the forum

    Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem - not what you think the answer might be. (think google search terms?). Once you have done this please send me a PM and I will remove this request. (Also, include a link to your thread - copy from the address bar)

    Many members search our previous posts, and thread titles play a big part of the search. I doubt anybody would do a search based on your title?

    To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

    (note: this change is not optional )
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. VLOOKUP? MATCH INDEX? Not sure which would work in this scenario, if any
    By AFIOF719 in forum Excel General
    Replies: 1
    Last Post: 05-02-2018, 08:51 PM
  2. Scenario and Index Table in Excel
    By alive555 in forum Excel General
    Replies: 13
    Last Post: 10-15-2015, 08:50 AM
  3. VLOOKUP? MATCH? Please answer my scenario - Cheers! Carl
    By carlbackham in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-22-2014, 12:38 AM
  4. Problems with multi-criteria Index/Match. LOOKUP works. Index/Match, SUMPRODUCT,ARRAY fail
    By sfike in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-30-2014, 02:42 AM
  5. [SOLVED] Help with a tricky lookup or index/match scenario
    By sheepsmasher in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 12-21-2013, 05:22 PM
  6. Index, match, dynamic and connected without sorting helper column non-adjacent index match
    By Underling in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-08-2013, 10:29 PM
  7. [SOLVED] Concatenated INDEX MATCH formula that won't give error that can index match 2-4 strings
    By bkwins in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-02-2013, 01:31 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1