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 
=IF(COUNTIF(Attendance,A5)=0,"N","Y")
, 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". 
=IF(COUNTIF(SI,[@ID])=0,"N",IF(SI[@Form6]="Y","6","Y"))