Removing #N/A
IF(ISNA(MATCH(1,($C$7:$C$34=H86)*($AR$7:$AR$34=$E$ 64),0)),"",INDEX($K$7:$K$34,MATCH(1,($C$7:$C$34=H8 6)*($AR$7:$AR$34=$E$64),0)))
--
__________________________________
HTH
Bob
"Anto111" wrote in message
...
Hi guys,
I have applied the following formula:
{=INDEX($K$7:$K$34,MATCH(1,($C$7:$C$34=H86)*($AR$7 :$AR$34=$E$64),0))}
When the number in AR7:AR34 does not match the number in E64 it returns
#N/A.
I need to change this #N/A to a blank so as I can get an average of the
cells that meet the specific criteria.
Kind regards and many thanks in advance,
Ant
|