I don't see how you are going to get one formula to check 1000 rows
and return error answers in one cell. Not without a LOT of space to
read that cell. What if 20 are 2-stop errors? Do you list them all in
one cell?

If you copy a formula down all 1000 cells, you can sort or filter on
the 3rd column and put all the errors together for quick deletion or
whatever. Or possibly skip the 3rd column and use VBA to do it
directly.

=IF(ISNA(MATCH(A1,Name_validation_list,0)),"Not
Validated",IF(SUMPRODUCT((Name=A1)*(Status="Stop") )1,"Entered
Twice",""))