+ Reply to Thread
Results 1 to 4 of 4

Index Match question

  1. #1
    Forum Contributor
    Join Date
    05-10-2011
    Location
    Central Ohio
    MS-Off Ver
    Excel 2000, and 2010
    Posts
    654

    Index Match question

    I want to Index the first value in each row (D:AB) that is greater than 0 and I am drawing a blank with the formula.

    I think the attachment explains the issue best.

    Jim O
    Attached Files Attached Files
    Last edited by JO505; 10-19-2015 at 04:22 PM.

  2. #2
    Forum Expert
    Join Date
    03-20-2015
    Location
    Primarily UK, sometimes NL
    MS-Off Ver
    Work: Office 365 / Home: Office 2010
    Posts
    2,405

    Re: Index Match question

    Put this in A3 (or whichever column you want) and drag down to to get the first non-zero value in that D:AB row:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Regards,
    Aardigspook

    I recently started a new job so am a bit busy and may not reply quickly. Sorry - it's not personal - I will reply eventually.
    If your problem is solved, please go to 'Thread Tools' above your first post and 'Mark this Thread as Solved'.
    If you use commas as your decimal separator (1,23 instead of 1.23) then please replace commas with semi-colons in your formulae.
    You don't need to give me rep if I helped, but a thank-you is nice.

  3. #3
    Forum Contributor
    Join Date
    05-10-2011
    Location
    Central Ohio
    MS-Off Ver
    Excel 2000, and 2010
    Posts
    654

    Re: Index Match question

    Thanks much, That seems to get the job done.

    Jim O

  4. #4
    Forum Expert
    Join Date
    03-20-2015
    Location
    Primarily UK, sometimes NL
    MS-Off Ver
    Work: Office 365 / Home: Office 2010
    Posts
    2,405

    Re: Index Match question

    You're welcome - thanks for the feedback and the rep.

+ 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] Index/Match Question
    By chisox721 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 12-12-2013, 05:15 AM
  2. [SOLVED] Index Match Question
    By CharterJP in forum Excel Formulas & Functions
    Replies: 18
    Last Post: 07-18-2013, 02:57 PM
  3. Index, match, match Question!. Seems so simple but can't figure it out...
    By huikimhuikim in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-12-2013, 01:57 PM
  4. [SOLVED] INDEX and MATCH question
    By Kabish in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-12-2012, 02:45 PM
  5. Index/Match question
    By mikera in forum Excel General
    Replies: 2
    Last Post: 10-22-2010, 02:03 PM
  6. Index/Match Question
    By mikera in forum Excel General
    Replies: 2
    Last Post: 01-07-2010, 07:01 PM
  7. Index/Match question Need help!
    By Brian H in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-10-2005, 09:05 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