I am stuck for comparison of two columns in two different sheets of Excel. I used different ways and formula but they don't work.

In *Sheet1* in `column L`

I have *Date* by format of e.g 1/19/2012 and `column M`

is *"Time"* by format of (e.g 19:00).

In *Sheet2* `column B`

is *Date* with the same format of *Sheet1*, and `column C`

is *"Time"* with the same format of *Sheet1*.

I want to compare **date and time** of two sheets and check if they are matched then bring the appropriate value from *Sheet2* `column D`

to a new `column O`

in *Sheet1* .

I used the formula `=L2 & "-" & M2`

in *Sheet 1* in `column N`

to have a merged column and used `=B2 & "-" & C2`

in *Sheet2* in `column A`

to have a merged column.

Now Im trying to compare *Sheet1* `Column N`

and *Sheet2* `Column A`

and see if they are matched then bring related value from *Sheet2* `Column D`

to *Sheet1* `Column O`

but it doesn't work.

**Note**: *Sheet1* has 1876 rows but *Sheet2* has 8785 rows.