Check if one value in one column is in another column

Question

I want to check if the dates in the `Date2 column` match the dates in the `Date1 column` and which dates do not match. As you can see for the first 25 it matches, but in the end there are 10 rows empty which means that these values are missing. I tried: ``` =VLOOKUP(C2:C3020;B2:C3037;C2;TRUE) ``` However that only gives me `#REF!` back. Is there probably another way to find out which dates do not match? I appreciate your answer!

Accepted Answer

You should use following formula:

```
=VLOOKUP(C2;$B$2:$B$3037;1;FALSE)
```

just write it in `D2` cell and stretch it down until `D3037`. If an exact match of date from column `C` is not found in column `B`, the error value `#N/A` is returned.

To get `FOUND` and `NOT FOUND` values you can use modification of this formula:

```
=IF(ISERROR(VLOOKUP(C2;$B$2:$B$3037;1;FALSE));"NOT FOUND";"FOUND")
```

Check if one value in one column is in another column

Solution

Problem