Forum Discussion
Solved
How to use logical function with dates and multiple criteria
Hi, I have two sets of data with dates. I'm trying to return a false if a date is present in one column but not in the other. I seem to be having trouble using an absolute range so that I can ap...
=ISNUMBER(MATCH(B3,$D$3:$D$15,0))Maybe with this formula. The formula returns FALSCH (which is FALSE in german) if the date is missing in the other column.
=ISNUMBER(MATCH(B3,$D$3:$D$15,0))Maybe with this formula. The formula returns FALSCH (which is FALSE in german) if the date is missing in the other column.
OliverScheurich That's really helpful. It worked as needed. You can see that I was able to apply it to screen the column to the right. What I needed to do was compare it to the J column, but I got around that by using conditional formatting. The J column is a function from another sheet.