+ Reply to Thread
Results 1 to 4 of 4

Help with index match combination

  1. #1
    Registered User
    Join Date
    06-08-2017
    Location
    Hochiminh
    MS-Off Ver
    2010
    Posts
    2

    Help with index match combination

    Hi
    As the title says, I have problem with INDEX MATCH COMBINATION
    I have a database of item (A), quantity (B) and Code (C). Pls see the atachment
    Now i want to find the Code (F) that looks up from item (E) and quantity is the greatest

    I have been trying my best to make the index fomula return my expected value on F2
    However i dont think i can do it on my own

    So pls someone look at the case and suggest me how can i do it
    Attached Files Attached Files
    Last edited by vdminh21; 06-08-2017 at 04:59 AM.

  2. #2
    Forum Expert
    Join Date
    03-28-2014
    Location
    Hyderabad,India
    MS-Off Ver
    Excel 2013
    Posts
    1,887

    Re: Help with index match combination

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    try this in f2 and then use Ctr+Shift+Enter as it is array function

  3. #3
    Forum Expert shukla.ankur281190's Avatar
    Join Date
    05-17-2014
    Location
    Lucknow, India
    MS-Off Ver
    Office 365
    Posts
    3,935

    Re: Help with index match combination

    Try

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


    Drags down!!

    ...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.
    If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)

  4. #4
    Registered User
    Join Date
    06-08-2017
    Location
    Hochiminh
    MS-Off Ver
    2010
    Posts
    2

    Re: Help with index match combination

    oh dear
    Thank you from the bottom of my heart
    I did it, and besides, i know exactly my problem is

+ 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] Index Match combination in VBA
    By Arnodekkers1995 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-24-2017, 09:17 AM
  2. IF / INDEX-MATCH Combination
    By Joshua27 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-23-2015, 05:29 PM
  3. Combination of IF and INDEX/MATCH
    By flandophile in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-30-2012, 09:52 AM
  4. Index and Match formula combination
    By anstasija in forum Excel General
    Replies: 3
    Last Post: 10-21-2011, 08:17 AM
  5. Index Match Combination for two variables
    By zhopa19 in forum Excel General
    Replies: 2
    Last Post: 06-21-2011, 03:07 PM
  6. combination of IF, INDEX/MATCH command
    By zombie in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 11-23-2010, 10:49 AM
  7. Using INDEX/MATCH in combination with LARGE?
    By scoobz in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-06-2008, 02:38 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