+ Reply to Thread
Results 1 to 6 of 6

Issue with nested if statements/index match.

  1. #1
    Registered User
    Join Date
    05-03-2018
    Location
    Nottingham, England
    MS-Off Ver
    MS Office 2016
    Posts
    2

    Issue with nested if statements/index match.

    Trying to get this formula to work

    Please Login or Register  to view this content.
    Any idea where i am going wrong??

  2. #2
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    365
    Posts
    5,994

    Re: Issue with nested if statements/index match.

    Hello and welcome to the forum. Sharing nothing but a non-working formula isn't going to allow us to help you much.

    Attach a small representative sample workbook along with the desired results (which you can enter manually) based on that data.

    Make sure there is just enough data to demonstrate your need.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.To upload an Excel workbook, follow these steps:
    1) Click on "Go Advanced"
    2) Click on "Manage Attachments"
    3) Click on "Choose File"
    4) Choose your file and click on "Open"
    5) Click on "Upload"
    6) Click on "Close this window"

  3. #3
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    6,780

    Re: Issue with nested if statements/index match.

    One thing that does strike me as wrong with the formula is your use of OR.
    Should be something like:
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    But as mentioned above, without a sample file or even a bit more of a clue on what's not working, it's difficult to guess.

    BSB

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    52,116

    Re: Issue with nested if statements/index match.

    Agree that a sample file will greatly help.

    1. are there only 2 different ranges? If so, try...
    =IF(K5=Sheet2!$A$32,INDEX(Sheet2!$B$7:$H$15,MATCH(F5,Sheet2!$A$7:$A$15,0),MATCH(E5,Sheet2!$B$5:$H$5,0)),INDEX(Sheet2!$B$21:$H$28,MATCH(F5,Sheet2!$A$21:$A$28,0),MATCH(E5,Sheet2!$B$19:$H$19,0)))

    2. If the 2 MATCH ranges contain the same info though, you may be able to just use 1 index/MATCH with a test to see which ranges to use, then just add that value to the MATCH's
    3. Consider using Named ranges, it may make it a bit easier
    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

  5. #5
    Registered User
    Join Date
    05-03-2018
    Location
    Nottingham, England
    MS-Off Ver
    MS Office 2016
    Posts
    2

    Re: Issue with nested if statements/index match.

    This has worked a treat!! Seems to be bringing back all the correct data.
    I cant add a sample file due to the sensitive nature of this particular spreadsheet.

    But thanks you legend!

  6. #6
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    52,116

    Re: Issue with nested if statements/index match.

    Happy to help (assuming my suggestion worked for you)

+ 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. Replies: 1
    Last Post: 02-14-2018, 05:28 AM
  2. [SOLVED] Nested IF statements with INDEX/MATCH instead of VLOOKUP
    By LKERN in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 11-12-2017, 02:24 PM
  3. [SOLVED] Nested If Statements or Match/Index???
    By djbcktt in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-10-2014, 12:57 AM
  4. [SOLVED] IF statements with nested INDEX MATCH
    By desertfx41 in forum Excel General
    Replies: 5
    Last Post: 07-08-2014, 03:26 PM
  5. Index Match - nested If (less than/greater than statements)
    By kelea in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 08-28-2009, 04:40 PM
  6. Issue with too many nested IF statements
    By sjak in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 08-05-2008, 03:13 PM
  7. Nested If Statements using Match
    By Zaraf in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-14-2008, 01:52 PM

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