Hi Spiky,
It should be possible to get the result in one cell because I only need to
know if any of the combinations are TRUE or 1. It doesn't matter which one or
how many.

Yes it is possible to add one col. However I believe it should be possible
to run this calculation with an array formula. The problem is just how to set
it up. I need to learn how to put an array formula inside a SUMPRODUCT
formula.
--
Thanks
John_J


Spiky skrev:

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",""))