Thread: Removing #N/A
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips[_3_] Bob Phillips[_3_] is offline
external usenet poster
 
Posts: 2,420
Default 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