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.