Thread: Index & Match
View Single Post
  #1   Report Post  
Dominique Feteau
 
Posts: n/a
Default Index & Match

I got a hand from someone on here (frank) with this function:

=INDEX(A2:O34,MATCH(1,(C37=A2:A34)*(D37=B2:B34),0) ,MATCH(C38,Months,0)+2)

I do have a questioni about it tho. How could I tweak it so that it if
there are 2 or more columns with the same value that it will add them
together?

thanks
niq