Easy-#N/A error Which fix to use:iserror/na()/ISNA/ (in Index, Match string)

[DoraExplorExcel]

First stipulation to this sheet, I cannot use VBA or macros for this enviroment. Otherwise, this would be simple.

My sheet is laid out as such -
Input tab / output tab
On the input tab, I have new fresh clean data dropped... On the output tab (I have some preformatted paste-linked references - and all of that works and looks great. When I am using the Index and Match as a statement for every line.. I get this #NA error for all of the blank cells. (This is the majority of the cells...

=INDEX(JJs!$F$1:$F$25386,MATCH(D32,JJs!$B$1:$B$25386,0))
=INDEX(JJs!$F$1:$F$25386,MATCH(D33,JJs!$B$1:$B$25386,0))

=IF(ISERROR(INDEX(JJs!$F$1:$F$25386,MATCH(D33,JJs!$B$1:$B$25386,0)))
Said I didn't have another parenthesis..

About 25,000 IDs and I want them to match the report we pull daily.

A LOT of blanks should occur because these people are not on our lists and thats okay! but these errors just make it cluttery.

The #NA error.. I cannot get rid of, can someone assist on the right placement of the most suitable fix? I tried one, It changed the error from #N/A to #NAME instead.
For me, blank works best, but if we must, 0 is fine also. I think conditional formatting might be much for this many records. Thank you all for your reading and any suggestions you can make.

Thank you,

Dee

[corinereyes]

Hi DoraExplorExcel,

Try this to get rid of the #N/A error:

Please Login or Register  to view this content.

[DoraExplorExcel]

I always get tripped up on how to integrate these little codes. Every formula is different and they each need a different approach as to resolving their problems. I can always learn something new from the excel guru community. Thank you!