Hi,

The below formular will return N/A in instances where no data is present, is it possible to stop this occuring and just show a zero or a blank?


=INDEX(Sheet!$K$2:$K$500,MATCH(1,(D21=Sheet!$I$2:$I$500)*($G$2=Sheet!$J$2:$J$500)*($A21=Sheet!$C$2:$C$500),0))

Thanks,