View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
SJT
 
Posts: n/a
Default 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.