AND(Contains(...), Contains(...)) Functioning
Hi all!
I have a question I have not been able to fully decipher with the documentation. I have been trying to identify if a certain combination of values in 2 columns appear in 2 other columns from another sheet. (Let's say I search value A in "Alphabet" column; and value 1 in "Order" column: I want to find out if the 2 values present in those columns with that information in a sheet are also present in another 2 columns in another sheet). In simpler words, it is a contains but entailing 2 columns.
I tried the following formula: AND(Contains(...), Contains(...)); but something that is really getting in my mind is if it is really going row by row to check the conditions (that is, a row in which for each of the 2 columns we have the values specified) or if it is just checking the whole column range and just making sure it is in the overall column range, without jointly taking into account the row by row.
Does anyone know for sure if such functioning goes row by row, or it just takes into account the condition the range and marks as checked if it is inside both columns ranges regardless of the rows in which they are in? Knowing it woul be very helpful.
Thank you in advance for any prospective help!
Answers
-
Hello Adria, I don't know what you are trying to do, what would you want if they do contain those things? For an AND, you need to embed that into a different function, like IF.
So try =IF(AND(Contains(....),Contains(...)),"True","False")
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 438 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 451 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 282 Events
- 32 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!