Results 1 to 4 of 4

Using an IF statement with INDEX / MATCH

Threaded View

  1. #1
    Registered User
    Join Date
    12-30-2011
    Location
    Bristol, UK
    MS-Off Ver
    Excel 2010
    Posts
    82

    Using an IF statement with INDEX / MATCH

    Hi all,

    I have an INDEX / MATCH formula that is currently looking at a value and returning some corresponding text:
    =IFERROR(INDEX('Data Converter'!$B$2:$T$5000,MATCH($L$17,'Data Converter'!$L$2:$L$5000,FALSE),4),"-")
    I've now been asked to refine this to look at only data within the past 30 days. I've put this value in E6 and tried to use the following formula to look in only the specific dates (in column C):

    =IFERROR(INDEX(IF('Data Converter'!$C$2:$C$5000>$E$6,'Data Converter'!$B$2:$T$5000,""),MATCH($L$17,'Data Converter'!$L$2:$L$5000,FALSE),4),"-")
    ...but this doesn't seem to work. I've also tried putting the IF statement beforehand:


    =IF('Data Converter'!$C$2:$C$5000>$E$6,IFERROR(INDEX('Data Converter'!$B$2:$T$5000,MATCH($L$17,'Data Converter'!$L$2:$L$5000,FALSE),4),"-"),"")
    ...again no joy. I've tried running these as array formulas, but still nothing.

    Can anyone suggest where I'm going wrong?

    TIA,

    FermentedR
    Last edited by Fermented Reptile; 02-13-2017 at 08:47 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. index match with if statement
    By Per_s in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-30-2016, 08:48 AM
  2. If statement with INDEX MATCH
    By JPSIMMON in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-13-2015, 01:19 PM
  3. [SOLVED] INDEX MATCH with If statement
    By geliedee in forum Excel General
    Replies: 1
    Last Post: 04-14-2015, 07:49 AM
  4. [SOLVED] Index/Match formula with If statement
    By protechds in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 01-31-2015, 10:22 PM
  5. [SOLVED] If Statement (Match/Index)
    By usmanfarok in forum Excel General
    Replies: 12
    Last Post: 09-26-2012, 04:42 AM
  6. Index & Match with IF statement
    By reggie1000 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-20-2007, 01:49 PM
  7. Index() & Match() or just an if() Statement?
    By JustMe602 in forum Excel General
    Replies: 6
    Last Post: 12-12-2006, 04:24 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