How to add conditions to Match function?
 

Does anyone have any suggestions on how to add conditions to Match function?
I get 4 numbers under the cell A1:A4, and I would like to determine which
number under cell A2:A4 is larger than cell A1 and closer to A1, such as

Those numbers are 10[A1], 17[A2], 20[A3], 13[A4], then the number 13 should
be return in cell B1 in this case. On the other hands, if all numbers under
A2:A4 are smaller than A1, then returns the max number A2:A4 in cell B1.
Does anyone have any suggestions?
Thank you in advance
Eric

How to add conditions to Match function?
 

What if a number is equal to A1? What result would expect in that case?

A1 = 10
A2 = 17
A3 = 20
A4 = 10

What if all the number are the same?

Biff

"Eric" wrote in message
...
Does anyone have any suggestions on how to add conditions to Match
function?
I get 4 numbers under the cell A1:A4, and I would like to determine which
number under cell A2:A4 is larger than cell A1 and closer to A1, such as

Those numbers are 10[A1], 17[A2], 20[A3], 13[A4], then the number 13
should
be return in cell B1 in this case. On the other hands, if all numbers
under
A2:A4 are smaller than A1, then returns the max number A2:A4 in cell B1.
Does anyone have any suggestions?
Thank you in advance
Eric

How to add conditions to Match function?
 

Those numbers are 10[A1], 17[A2], 20[A3], 10[A4], then the number 10 should
be return in cell B1 in this case. I would like to determine which
number under cell A2:A4 is larger than cell A1 and closer to / equal to A1.

Do you have any suggestions?
Thank you for any suggestions
Eric

"T. Valko" wrote:

What if a number is equal to A1? What result would expect in that case?

A1 = 10
A2 = 17
A3 = 20
A4 = 10

What if all the number are the same?

Biff

"Eric" wrote in message
...
Does anyone have any suggestions on how to add conditions to Match
function?
I get 4 numbers under the cell A1:A4, and I would like to determine which
number under cell A2:A4 is larger than cell A1 and closer to A1, such as

Those numbers are 10[A1], 17[A2], 20[A3], 13[A4], then the number 13
should
be return in cell B1 in this case. On the other hands, if all numbers
under
A2:A4 are smaller than A1, then returns the max number A2:A4 in cell B1.
Does anyone have any suggestions?
Thank you in advance
Eric