+ Reply to Thread
Results 1 to 2 of 2

Index match with or formula

  1. #1
    Registered User
    Join Date
    11-02-2014
    Location
    lONDON
    MS-Off Ver
    8.1
    Posts
    1

    Index match with or formula

    CAN SOMEONE HELP ME THIS FORMULA

    Ii HAVE THIS FORMULA

    =ISNA(MATCH(1,(Company_VIN=Quarter)*(Index_VIN=C14),0)),"N/A",INDEX(Vin_Lookup,MATCH(1,(Company_VIN=Quarter)*(Index_VIN=C14),0),3))

    I WAND TO ADD TO THIS FORMULA AN "IF" AND "OR" STATEMENT (IF F14 IS = TO 1, OR F15 = 2) THAN IS SHOULD =ISNA(MATCH(1,(Company_VIN=Quarter)*(Index_VIN=C14),0)),"N/A",INDEX(Vin_Lookup,MATCH(1,(Company_VIN=Quarter)*(Index_VIN=C14),0),3))

    I GUEST IT SHOULD BE SOMETHING LIKE THIS

    =IF(OR(F14=1,F15=2),(ISNA(MATCH(1,(Company_VIN=Quarter)*(Index_VIN=C14),0)),"N/A",(OR(F14=1,F15=2),INDEX(Vin_Lookup,MATCH(1,(Company_VIN=Quarter)*(Index_VIN=C14),0),3))

  2. #2
    Valued Forum Contributor wenqq3's Avatar
    Join Date
    04-01-2013
    Location
    Malaysia
    MS-Off Ver
    Excel 2003
    Posts
    868

    Re: Index match with or formula

    Hi DEE LEE, welcome to forum.

    This function will not working without IF function in front.
    Please Login or Register  to view this content.
    I guess you want be like this.
    Please Login or Register  to view this content.
    If not, please upload a sample workbook.Thanks
    -If the problem is solved, please mark your thread as Solved: Click Thread Tools above your first post, select "Mark your thread as Solved".

    -Always upload a workbook before start your question
    To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.

    +++ If my answer(s) helped you, please add me reputation by click on * +++

+ 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: 2
    Last Post: 09-27-2014, 04:34 PM
  2. Index Match Match Formula DOESN'T WORK WITH TABLES/TABLE NAMES ??
    By Underling in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-04-2014, 09:01 PM
  3. Replies: 3
    Last Post: 05-02-2013, 01:31 AM
  4. Index Match Index Formula work slow
    By avk in forum Excel General
    Replies: 9
    Last Post: 03-07-2012, 02:19 PM
  5. Replies: 5
    Last Post: 02-29-2012, 08:51 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