+ Reply to Thread
Results 1 to 3 of 3

FUNCTION INDEX + MATCH + OFFSET alternate solution

  1. #1
    Registered User
    Join Date
    02-10-2021
    Location
    Bogotá. Colombia
    MS-Off Ver
    2013
    Posts
    14

    FUNCTION INDEX + MATCH + OFFSET alternate solution

    Dear all, good day

    In the attached file I have an Excel sheet in which I am performing some searches according to certain criteria such as month (cell I4) and Salesperson (I12).
    The question is that for the first search (cell I8), taking into account the month (I4), Total Sales (I6) and Max. individual sale (I7), I want to know the name of the salesman who made them (cell I8). To make this possible I have applied several functions between INDEX+MATCH+OFFSET, but I find them a bit confusing because in case I need to add more columns to the data matrix, I have to modify their arguments.

    The same happens with the result obtained in cell (I16).

    Is it possible to apply another type of formula that allows me to simplify or automate in a better way the results obtained in cells I8 and I16, for example using other functions such as VLOOKUP+MATCH or INDEX+MATCH?

    I appreciate your valuable collaboration!

    PST. I am using Excel 365 version
    Attached Files Attached Files

  2. #2
    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,956

    Re: FUNCTION INDEX + MATCH + OFFSET alternate solution

    Rather than name your thread with functions you thing you want, rename it to something that actually explains what your problem is please - 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

  3. #3
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2406 (Windows 11 23H2 64-bit)
    Posts
    82,445

    Re: FUNCTION INDEX + MATCH + OFFSET alternate solution

    And please update your forum profile from Excel 2013 to MS365.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

+ 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] FUNCTION INDEX + MATCH alternate solution
    By ferfer20 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-27-2021, 11:57 AM
  2. Replies: 11
    Last Post: 08-26-2019, 11:32 AM
  3. Offset function with Index match
    By Jayant shettigar in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-08-2018, 11:56 AM
  4. Offset an Index/Match function
    By GurminderSG in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-25-2016, 04:48 PM
  5. Replies: 1
    Last Post: 06-10-2015, 12:56 PM
  6. Replies: 2
    Last Post: 10-25-2010, 03:10 PM
  7. Complicated Index Match Offset function
    By Bob in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 04:05 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1