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