Excel – Match up date and time values in different Excel sheets

microsoft excelworksheet-function

I have an excel file and need the following.
There are two sheets in one Excel file. The first sheet shows date and time values in column C & D. The second sheet does this too in column A & B.

I want to match up the date and time from sheet 1 with sheet 2 and when there is a match put column C (date) of sheet 2 in column G of sheet 1.

For example in sheet 1 cell C3 & D3 are "2/24/2009" & "15:00". In sheet 2 that matches with A13 & B13 and so we take C13 from sheet 2 and place it in sheet 1 G3.

I want to be able to replace the cells in sheet 1 and sheet 2 and they should be able to repopulate with correct data.

Best Answer

This can be done without changing the original data layout or joining any data. You can use an Index/Match combo like this:

=IFERROR(INDEX(Sheet2!$C$1:$C$10,MATCH(Sheet1!C2+Sheet1!D2,INDEX(Sheet2!$A$1:$A$10+Sheet2!$B$1:$B$10,0),0)),"")

enter image description here

Related Question