Formula not showing correctly

When i run a formula(=IF(COUNTIF(Sheet2!A:A,Sheet1!B1)=1,IF(Sheet1!C1=1,"NEEDS 2B Removed","ACTIVE"),"")) it isnt showing correctly because the value it is looking up (Sheet1!B1) is in the separate spreadsheet9Sheet1!C) 2+ times. Is there any way around this?

I have attached a sample of what the issue is.

Thanks,