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!