westend9876
Member
Can someone tell me why part of this formula returns value while the other part does not. Each IF(AND) is identical except for referencing one different cell (J159 and Q159):
=IF(AND(AA159<>"",J159="Retracement"),MATCH(AF159,INDIRECT(AE159):INDIRECT(Y159))+ROW(),IF(AND(AA159<>"",Q159="Retracement"),MATCH(AF159,INDIRECT(AE159):INDIRECT(Y159))+ROW(),""))
The second IF(AND returns value but the first one does not:
IF(AND(AA159<>"",Q159="Retracement"),MATCH(AF159,INDIRECT(AE159):INDIRECT(Y159))+ROW(),
=IF(AND(AA159<>"",J159="Retracement"),MATCH(AF159,INDIRECT(AE159):INDIRECT(Y159))+ROW(),IF(AND(AA159<>"",Q159="Retracement"),MATCH(AF159,INDIRECT(AE159):INDIRECT(Y159))+ROW(),""))
The second IF(AND returns value but the first one does not:
IF(AND(AA159<>"",Q159="Retracement"),MATCH(AF159,INDIRECT(AE159):INDIRECT(Y159))+ROW(),