Value match with an array

's Computer Specifications

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.

's Computer Specifications

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.
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Lookup Formula: Return 1st match, then 2nd match, then 3rd match	Scott	Microsoft Excel Misc	4	11th Dec 2009 06:50 AM
VBA IIf(myCell.Value = Array(myCell2(1).Value, myCell2(2).Value,myCell2(3).Value,myCell2(4).Value) ,"OK","No Match)	EagleOne@discussions.microsoft.com	Microsoft Excel Programming	2	24th Apr 2009 11:25 PM
Match using array of column and row references to match with	jkfin1	Microsoft Excel Worksheet Functions	1	16th Sep 2008 04:39 PM
index match array function-returning only first match, need last.	=?Utf-8?B?SnVsaWUgT2xzZW4=?=	Microsoft Excel Worksheet Functions	3	29th Dec 2006 01:50 AM
Match as well as does not match array function	=?Utf-8?B?VmlrcmFtIERoZW1hcmU=?=	Microsoft Excel Misc	7	25th Apr 2006 09:15 AM