MATCH & IF Functions
 

I am using the follow array formula =MATCH(true,b10:f10+b:15:f15100,0). Is
there a way using the IF function or another function to have the formula not
evaluate the values in say column "c" but still count column "d" as the third
column in the range? Thank you in advance for your assistance.

MATCH & IF Functions
 

=MATCH(1,(B10:F10+B15:F15100)*(COLUMN(B1:F1)<COL UMN(C1)),0)
(Array formula)

This excludes column C, which you can change in COLUMN(C1)

HTH
--
AP


"SJT" a écrit dans le message de news:
...
I am using the follow array formula =MATCH(true,b10:f10+b:15:f15100,0).
Is
there a way using the IF function or another function to have the formula
not
evaluate the values in say column "c" but still count column "d" as the
third
column in the range? Thank you in advance for your assistance.

MATCH & IF Functions
 

Thanks much.

"Ardus Petus" wrote:

=MATCH(1,(B10:F10+B15:F15100)*(COLUMN(B1:F1)<COL UMN(C1)),0)
(Array formula)

This excludes column C, which you can change in COLUMN(C1)

HTH
--
AP


"SJT" a écrit dans le message de news:
...
I am using the follow array formula =MATCH(true,b10:f10+b:15:f15100,0).
Is
there a way using the IF function or another function to have the formula
not
evaluate the values in say column "c" but still count column "d" as the
third
column in the range? Thank you in advance for your assistance.