Simple nested IF statement not working correctly

Employee Data.xlsx
I am building a tracking tool to show me whether a certain ID occurs in other tabs or not.
The formula at the bottom works for all 3 cases for 85% of the rows, but I get #VALUE! error for the rest.

BACKGROUND:
Each tab contains IDs from different sources, and the first tab, TOTAL, has all the IDs that exist in all other tabs.
TOTALS is a checklist that shows if the IDs listed in it occurs in each of the tabs
For most tabs, I use the formula

Please Login or Register  to view this content.

, which shows whether that name occurs in the Attendance tab "Y" or not "N".

PROBLEM:
For one specific tab, if the ID is not in that tab , put "N", OR the ID is there but there is a certain value in column "Form6", put "6", otherwise, put "Y".

Please Login or Register  to view this content.

Maybee you need the IFERROR fomula.

See attached:

Thanks for your fast reply, Rambo.

The IFERROR formula did not solve the underlying issue.
Sheet TOTAL Cell H17 (for ID99) contains "6" instead of "Y", since this ID exists in Sheet SI, and column J does not contain a"Y"
Cell H18 (for ID100) contains "Y" instead of "N", which it should since this ID exists in Sheet SI, and column J contains a "Y"

Does you have an idea why this occurs?

I changed the formula to

Please Login or Register  to view this content.

and it works fine now. =)