Results 1 to 15 of 15

IF formula with multiple conditions using INDEX/MATCH

Threaded View

  1. #1
    Registered User
    Join Date
    03-29-2010
    Location
    Earth
    MS-Off Ver
    Excel 2007
    Posts
    37

    IF formula with multiple conditions using INDEX/MATCH

    I am looking to shorten/simplify a formula that looks up values in a table using INDEX/MATCH as part of an IF formula that includes logical OR and AND functions. For example, I could use the following general structure:

    =IF(OR(INDEX(MATCH)=A,INDEX(MATCH)=B,INDEX(MATCH)=C),0,IF(AND(INDEX(MATCH)=D,INDEX(MATCH)=E),1,""))
    The INDEX(MATCH) elements have been abbreviated here simply to convey the general idea, but the formula can quickly run into many lines when written normally and when the number of conditions is more than 2 or 3 and there are additional nested IF statements.

    I have tried to shorten the formula using the following (ie grouping the conditional values in an OR function) but it returns a #VALUE error:

    =IF(INDEX(MATCH)=OR(A,B,C),0,1)
    Is there another way to write a shortened conditional formula of this kind? Or does the INDEX(MATCH) need to be included for each separate condition as written in the first code snippet?
    Last edited by cad1llac; 01-30-2013 at 06:36 AM.

Thread Information

Users Browsing this Thread

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

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