+ Reply to Thread
Results 1 to 3 of 3

Combining IF with INDEX and MATCH

  1. #1
    Forum Contributor
    Join Date
    02-09-2011
    Location
    Perth, Australia
    MS-Off Ver
    2016
    Posts
    161

    Combining IF with INDEX and MATCH

    Hi,

    The INDEX/MATCH formula below works great:

    =INDEX(Table_TEAMWORKS_25657_HYDRO5[TEST_PREPARATION],MATCH('OSBL Testpacks'!A2,Table_TEAMWORKS_25657_HYDRO5[PKG_ID],0))

    I now need to include an IF so that if there is no value (a date) in the cell in Table_TEAMWORKS_25657_HYDRO5[TEST_PREPARATION] it returns nothing. A present if there is no date it returns “0”. I want either a date or nothing.

    I have tried adding an IF but can’t get it working. How would I need to modify my formula to include this IF?

    Thanks very much

    Dave

  2. #2
    Forum Guru benishiryo's Avatar
    Join Date
    03-25-2011
    Location
    Singapore
    MS-Off Ver
    Excel 2013
    Posts
    5,147

    Re: Combining IF with INDEX and MATCH

    hi Dave. does the formula return you text, numbers or both? also, are you still using Excel 2003?
    if it's a text:
    =INDEX(Table_TEAMWORKS_25657_HYDRO5[TEST_PREPARATION],MATCH('OSBL Testpacks'!A2,Table_TEAMWORKS_25657_HYDRO5[PKG_ID],0))&""

    if it's a number/mixed (in excel 2003):
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Thanks, if you have clicked on the * and added our rep.

    If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".

    "Contentment is not the fulfillment of what you want, but the realization of what you already have."


    Tips & Tutorials I Compiled | How to Get Quick & Good Answers

  3. #3
    Forum Contributor
    Join Date
    02-09-2011
    Location
    Perth, Australia
    MS-Off Ver
    2016
    Posts
    161

    Re: Combining IF with INDEX and MATCH

    Thanks benishiryo, that works perfectly! I am using Excel 2016

+ 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] Combining 2 Index Match functions!
    By Hellion in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-29-2016, 04:34 AM
  2. Combining IF and Index Match
    By csnyder10 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 06-29-2016, 03:16 AM
  3. [SOLVED] Combining INDEX and MATCH with MAX
    By jcswaby in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 02-12-2016, 10:35 AM
  4. [SOLVED] Combining 3 Formulas: Return all Names that Match Criteria Using Index/Match
    By bchilme in forum Excel Formulas & Functions
    Replies: 20
    Last Post: 09-29-2014, 09:28 AM
  5. [SOLVED] Combining Index, Match, If, Not, ISERROR
    By brad999 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-07-2013, 07:02 AM
  6. [SOLVED] Need help combining two Index Match functions into one
    By BeachRock in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-23-2012, 10:35 PM
  7. Combining Match & Index Functions
    By bmc1975 in forum Excel General
    Replies: 10
    Last Post: 08-09-2010, 03:33 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