Forum Discussion
Need help with syntax for using an "OR" statement to join two formulas
=IF(OR(XLOOKUP(D7,DATABASE!D:D,DATABASE!AE:AE)="",XLOOKUP(D7,DATABASE!D:D,DATABASE!AC:AC)="Not Required"),IF(XLOOKUP(D7,DATABASE!D:D,DATABASE!AE:AE)="","Awaits_training","Not Applicable"),XLOOKUP(D7,DATABASE!D:D,DATABASE!AE:AE))
This formula uses the OR function to check if either of the two conditions are met. If either condition is true, the formula returns “Awaits_training” if the first XLOOKUP returns an empty string, or “Not Applicable” if the second XLOOKUP returns “Not Required”. If neither condition is true, the formula returns the result of the first XLOOKUP.
I hope this helps!
=IF(OR(XLOOKUP(D7,DATABASE!D:D,DATABASE!AE:AE)="",XLOOKUP(D7,DATABASE!D:D,DATABASE!AC:AC)="Not Required"),IF(XLOOKUP(D7,DATABASE!D:D,DATABASE!AE:AE)="","Awaits_training","Not Applicable"),XLOOKUP(D7,DATABASE!D:D,DATABASE!AE:AE))
This formula uses the OR function to check if either of the two conditions are met. If either condition is true, the formula returns “Awaits_training” if the first XLOOKUP returns an empty string, or “Not Applicable” if the second XLOOKUP returns “Not Required”. If neither condition is true, the formula returns the result of the first XLOOKUP.
I hope this helps!
- Wow, that was quick!!
It does exactly what I want. Thanks a lot for the guidance.
Les King- I am glad that I could help you.
I wish you continued success with Excel!- Thanks so much, Nikolino!
