MATCH Function
 

I would like to use the MATCH function to return the value in a range that
meets a certain condition. For example, I would like it to look at the sum
of two cells across a number of columns and when the sum of those cells is
greater than 100 than return the position of that cell in the array. For
example, I would like to add the values of rows 10 and 15 across columns b -
f and when that sum is greater than 100 I would like the formula to return
the first position in the range for which that is true. So if the sum of c10
+ c15=105 the formula would return "2" since it is the second column in the
range that begins with "b". Thank you for your assistance.

MATCH Function
 

=MATCH(TRUE,B10:F10+B15:F15100,0)

This is an array formula, to be validated by Ctrl+Shift+Enter

HTH
--
AP

"SJT" a écrit dans le message de news:
...
I would like to use the MATCH function to return the value in a range that
meets a certain condition. For example, I would like it to look at the
sum
of two cells across a number of columns and when the sum of those cells is
greater than 100 than return the position of that cell in the array. For
example, I would like to add the values of rows 10 and 15 across columns
b -
f and when that sum is greater than 100 I would like the formula to return
the first position in the range for which that is true. So if the sum of
c10
+ c15=105 the formula would return "2" since it is the second column in
the
range that begins with "b". Thank you for your assistance.

MATCH Function
 

Thank you for your help.

"Ardus Petus" wrote:

=MATCH(TRUE,B10:F10+B15:F15100,0)

This is an array formula, to be validated by Ctrl+Shift+Enter

HTH
--
AP

"SJT" a écrit dans le message de news:
...
I would like to use the MATCH function to return the value in a range that
meets a certain condition. For example, I would like it to look at the
sum
of two cells across a number of columns and when the sum of those cells is
greater than 100 than return the position of that cell in the array. For
example, I would like to add the values of rows 10 and 15 across columns
b -
f and when that sum is greater than 100 I would like the formula to return
the first position in the range for which that is true. So if the sum of
c10
+ c15=105 the formula would return "2" since it is the second column in
the
range that begins with "b". Thank you for your assistance.