Remove #N/A from formula

[jpruffle]

Hi,

I have two formula which work fine, except if the value doesn't exist then it returns a #N/A result. Can you please advise on the two formula to stop the #N/A?

Formula One:

=IF(COUNTA($P298)<=$Q$293,MATCH($Q$292,INDEX(ConKins!$C:C,N($P298)+1):INDEX(ConKins!$C:C,MATCH(BigStr,ConKins!$C:C)),0)+N(P298),"")

Formula Two:

=IF(N($P299),INDEX(ConKins!D:D,$P299),"")

Thanks in advance.

[jpruffle]

I have resolved it, just wrote the formula wrong.