Results 1 to 16 of 16

Index array solution

Threaded View

  1. #1
    Registered User
    Join Date
    07-23-2012
    Location
    Los Angeles, CA
    MS-Off Ver
    Excel 2003
    Posts
    14

    Index array solution

    I'm trying to correct this formula because it's not returning the right value.

    =INDEX(EBITDA_Forecasted!$FP$5:$IU$5,MATCH(TRUE,EBITDA_Forecasted!$FP7:$IU7>0,))

    What I'm trying to do is index row 5 (dates going across) and looking for row 7 (when treatments are >0) and returning the date value.

    Did I mess up the formula somewhere?
    Last edited by holycowbanana85; 07-24-2012 at 04:49 PM.

Thread Information

Users Browsing this Thread

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

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