Hello,
I want to validate the cell F3 entry if the following condition is met: OR(AND(F3="";I10>0);LOOKUP(F3;D7:F11;3;0)>0)
Meaning that if the cell F3 is empty, it will check if I10>0, if not, it will search for its correspondance in the area from D7 to F11 and check if it is bigger than 0
If I only use this formula: AND(F3="";I10>0) and the cell F3 is empty it validates the entry, since I 10 is bigger than 0
But if I use the formula OR(AND(F3="";I10>0);LOOKUP(F3;D7:F11;3;0)>0)
It only works if the cell F3 is not empty, if it is empty, it doesn't work, since it doesn't validate the entry as it was supposed to.
I think it has to do with the fact that when the cell F3 is empty, it uses the formula LOOKUP and it shouldn't, since it´s not applicable in this condition and so it doesn't validate the entry based on an error in the formula.
How to solve this in order to produce the correct output?
Thanks.
I want to validate the cell F3 entry if the following condition is met: OR(AND(F3="";I10>0);LOOKUP(F3;D7:F11;3;0)>0)
Meaning that if the cell F3 is empty, it will check if I10>0, if not, it will search for its correspondance in the area from D7 to F11 and check if it is bigger than 0
If I only use this formula: AND(F3="";I10>0) and the cell F3 is empty it validates the entry, since I 10 is bigger than 0
But if I use the formula OR(AND(F3="";I10>0);LOOKUP(F3;D7:F11;3;0)>0)
It only works if the cell F3 is not empty, if it is empty, it doesn't work, since it doesn't validate the entry as it was supposed to.
I think it has to do with the fact that when the cell F3 is empty, it uses the formula LOOKUP and it shouldn't, since it´s not applicable in this condition and so it doesn't validate the entry based on an error in the formula.
How to solve this in order to produce the correct output?
Thanks.