+ Reply to Thread
Results 1 to 5 of 5

Matching value in a column array with result in another column array

  1. #1
    Registered User
    Join Date
    03-02-2013
    Location
    Manila,Philippines
    MS-Off Ver
    Excel 2011
    Posts
    24

    Matching value in a column array with result in another column array

    hello Forum,

    Greetings from Cebu, Philippines
    Here is my question, and I do post a pdf illustration to support my question

    I have two columns of 12 hard core figures
    Col D are percentages; Col C are months numbers (from 1 to 12)

    I try to set up a function that will result in the following:
    I want as a result of the function the lowest month number in col C array matching any percentage in Col D array that is superior to zero.

    Not sure my question is clear, but I think the attachment shall clarify the question

    Thank you all
    Attached Files Attached Files

  2. #2
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,412

    Re: Matching value in a column array with result in another column array

    With C5:C16 is consecutive months of a year

    try:

    =MATCH(TRUE,INDEX(D5:D16>0,),0)
    Quang PT

  3. #3
    Forum Expert
    Join Date
    02-10-2019
    Location
    Georgia, USA
    MS-Off Ver
    Office 365
    Posts
    2,808

    Re: Matching value in a column array with result in another column array

    If you're still on Excel 2011, you can try this formula:

    =INDEX(C5:C16,MATCH(1,--(D5:D16>0),0))

    If you're on a recent version, you can also try this:

    =MINIFS(C5:C16,D5:D16,">0")

  4. #4
    Registered User
    Join Date
    03-02-2013
    Location
    Manila,Philippines
    MS-Off Ver
    Excel 2011
    Posts
    24

    Re: Matching value in a column array with result in another column array

    thank you....
    I tried the second answer (MINIFS) and it works well
    The first answer (INDEX) didn't work......
    Anyway a BIG thank you

  5. #5
    Registered User
    Join Date
    03-02-2013
    Location
    Manila,Philippines
    MS-Off Ver
    Excel 2011
    Posts
    24

    Re: Matching value in a column array with result in another column array

    a BIG thank you

+ 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: 3
    Last Post: 01-29-2019, 02:40 PM
  2. dynamic array for matching value in another column
    By aleenkhan in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-10-2017, 08:20 PM
  3. Replies: 3
    Last Post: 03-07-2016, 09:54 PM
  4. Replies: 5
    Last Post: 11-24-2015, 08:15 AM
  5. Array based on matching Row & Column
    By Katch22 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-07-2015, 07:36 AM
  6. [SOLVED] 2 Column Lookup with 6 Column array Col index number is Varies Within Entire Array
    By Weasyb in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-05-2015, 12:54 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