I am trying to get a true or false return if a value is found in one column and a specific date is also found in the same row. However, any way I try, the AND function searches the entire column for each value independently. If both values are found in any row then it returns true even if they don't match in their respective rows.
Help Article Resources
Check out the Formula Handbook template!