volley_boy1
New Member
- Joined
- Nov 23, 2009
- Messages
- 9
Hello,
I have a formula where I'm trying to verify if 2 conditions are true, and if so, pull the info from the row where both of those conditions are met.
The problem is that both conditions I want the formula to verify are text and the AND fuction tests for logical values (and text apparently isn't a logical value).
So anyways, is there someway I can substitute the AND fuction for a different function but acheive the same result (verify that both conditions are true, if so, pull the value from the line that it's correct)??
Thank you for your help!
I have a formula where I'm trying to verify if 2 conditions are true, and if so, pull the info from the row where both of those conditions are met.
The problem is that both conditions I want the formula to verify are text and the AND fuction tests for logical values (and text apparently isn't a logical value).
So anyways, is there someway I can substitute the AND fuction for a different function but acheive the same result (verify that both conditions are true, if so, pull the value from the line that it's correct)??
Thank you for your help!