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