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).
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.