Is it possible to do one formula for the following true/false (yes/no?) check:
If column K has a "V", but none of the other criteria, then check array #1 for a true/false if the number in column D is in it.
If column K has an "H", but none of the other criteria, check array number #2 for a true/false if the number in column D is in it)
If column K has a "V" AND column R<12, but none of the other criteria, check array #3 for a true/false if the number in column D is in it.
If column K has an "H" AND column S<12, but none of the other criteria, check array#4 for a true/false if the number in column D is in it.
I can provide more information but I'm not sure what else you'd need to say if this is possible.
Thanks!
Nanaia
If column K has a "V", but none of the other criteria, then check array #1 for a true/false if the number in column D is in it.
If column K has an "H", but none of the other criteria, check array number #2 for a true/false if the number in column D is in it)
If column K has a "V" AND column R<12, but none of the other criteria, check array #3 for a true/false if the number in column D is in it.
If column K has an "H" AND column S<12, but none of the other criteria, check array#4 for a true/false if the number in column D is in it.
I can provide more information but I'm not sure what else you'd need to say if this is possible.
Thanks!
Nanaia