Value match with an array

Discussion in 'Microsoft Excel Discussion' started by Manjunath, Jun 7, 2012.

  1. Manjunath

    Manjunath Guest

    Hey All,

    I have a value which i want to compare with an array, if we are using lookup function when the value provided is not matching the value's in array, it will select the lowest/nearest value in array.

    I want it to select the next highest value in array

    Kindly provide a solution.
     
    Manjunath, Jun 7, 2012
    #1
    1. Advertisements

  2. Manjunath

    isabelle Guest

    hi Manjunath,

    look of the result of those two formulas


    =INDEX({2,4,6,8},MATCH(3,{2,4,6,8},1))

    =INDEX({8,6,4,2},MATCH(3,{8,6,4,2},-1))

    --
    isabelle




    Le 2012-06-07 05:36, Manjunath a écrit :
    > Hey All,
    >
    > I have a value which i want to compare with an array, if we are using lookup function when the value provided


    is not matching the value's in array, it will select the lowest/nearest value in array.
    >
    > I want it to select the next highest value in array
    >
    > Kindly provide a solution.
    >
     
    isabelle, Jun 7, 2012
    #2
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Chris

    How does MATCH handle a Non-Match?

    Chris, Jul 20, 2005, in forum: Microsoft Excel Discussion
    Replies:
    1
    Views:
    181
    Debra Dalgleish
    Jul 20, 2005
  2. kcc

    Why Doesn't This MATCH Work - Array Question

    kcc, Dec 10, 2005, in forum: Microsoft Excel Discussion
    Replies:
    5
    Views:
    194
  3. Replies:
    2
    Views:
    1,204
  4. AA Arens

    Another MATCH of combining with two MATCH functions?

    AA Arens, Dec 3, 2006, in forum: Microsoft Excel Discussion
    Replies:
    1
    Views:
    286
    Pete_UK
    Dec 3, 2006
  5. jg
    Replies:
    1
    Views:
    249
    Dave Peterson
    Jun 20, 2007
Loading...

Share This Page