I have this formula that I am using to pull data data worksheet NSN8. No
problems.

=IF(COUNTIF(NSN8!A:A,D1088)=0,"N/A",IF(COUNTIF(NSN8!A:A,D1088),INDEX(NSN8!C:C,MATCH (D1088,NSN8!A:A,0))))

I have created another worksheet NSN09 and started to pull that data in the
next row:

=IF(COUNTIF(NSN09!A:A,D1089)=0,"N/A",IF(COUNTIF(NSN09!A:A,D1089),INDEX(NSN09!C:C,MAT CH(D1089,NSN09!A:A,0))))

Instead of receiving data from worksheet NSN09, I am getting error #N/A.

Why is this?

Thanks,

Roy