C
Crazyhorse
I am using the Function INDEX and MATCH. It works. It does not work well when
you want to add up the results but the result returns a #N/A. I would like to
return a Zero instead on a #N/A. Here is my Formula that I am using.
=INDEX(Detail!$F$2:$F$1292,MATCH(1,(Detail!$A$2:$A$1292=Summary!C$5)*(Detail!$G$2:$G$1292=Summary!$A$11),0))
This returns #N/A and I would like it to return a Zero.
Thanks in Advance for any help.
you want to add up the results but the result returns a #N/A. I would like to
return a Zero instead on a #N/A. Here is my Formula that I am using.
=INDEX(Detail!$F$2:$F$1292,MATCH(1,(Detail!$A$2:$A$1292=Summary!C$5)*(Detail!$G$2:$G$1292=Summary!$A$11),0))
This returns #N/A and I would like it to return a Zero.
Thanks in Advance for any help.