+ Reply to Thread
Results 1 to 4 of 4

Index Formula with Multiple condition problem

  1. #1
    Registered User
    Join Date
    03-21-2019
    Location
    Germany
    MS-Off Ver
    professional plus 2010
    Posts
    6

    Index Formula with Multiple condition problem

    Dear Good people,

    I have a specific problem with Index formula regarding multiple condition usage. Below is a formula that use one condition works perfectly:

    Please Login or Register  to view this content.
    Now i would like to put another condition and both condition has to be met to get the value. I tried with AND formula and some other ways.Nothing works or not rightly works. Any idea or solution will be much appreciated.



    Thanks in advance all of you.
    Last edited by punno2015; 07-26-2019 at 07:38 AM.

  2. #2
    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. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,369

    Re: Index Formula with Multiple condition problem

    Administrative Note:

    We would very much like to help you with your query, however you need to include code tags around your code.

    Please take a moment to add the tags. Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

    Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

    (Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)
    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.

  3. #3
    Registered User
    Join Date
    03-21-2019
    Location
    Germany
    MS-Off Ver
    professional plus 2010
    Posts
    6

    Re: Index Formula with Multiple condition problem

    Done
    Thanks

  4. #4
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,427

    Re: Index Formula with Multiple condition problem

    Thank You for complying with AliGW's instructions.
    Not a VBA coder myself however if the second condition is supposed to go in this segment "...SMALL(IF('Sheet2'!$H$2:$H$5000=6,ROW('Sheet2'!$H$2:$H$5000))…"
    then generally a formula would read: "...SMALL(IF('Sheet2'!$H$2:$H$5000=6,IF(second condition,ROW('Sheet2'!$H$2:$H$5000)))…"
    For specific help you may want to upload a small desensitized sample that illustrates the issue by clicking on the GO ADVANCED button below the Quick Reply window and then scrolling down to Manage Attachments to open the upload window.
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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] Problem with INDEX and Multiple MATCH Formula
    By leo73pk in forum Excel General
    Replies: 5
    Last Post: 10-26-2017, 07:58 AM
  2. [SOLVED] Multiple condition and index matching
    By atanu021 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 04-13-2017, 10:07 AM
  3. formula index() problem, multiple sheets
    By coolebok in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-17-2017, 09:23 AM
  4. Replies: 3
    Last Post: 05-26-2015, 11:34 AM
  5. [SOLVED] Problem with index match formula with multiple criteria s - help
    By vba_newbie83 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-06-2014, 08:47 AM
  6. Multiple condition lookup for Index function
    By cheal2 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-17-2013, 09:13 AM
  7. [SOLVED] Index and Vlookup question (Multiple Condition)
    By jp16 in forum Excel General
    Replies: 7
    Last Post: 09-25-2012, 12:41 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