Hi there

I have 2 data sheets, and I would like to update the values in a column in one of them from a similar one in the other, based on when values match in two other similar columns between the sheets
i.e
I have Column Names "DC" and "TIME" in both sheets
Sheet-1 has a row and value for DC for every minute in the day
Sheet-2 has rows only for a subset of sheet-1 and the value of "DC" may be different.
I want to be able to update the value of "DC" in sheet-1 for all the rows where there are matching values for the "TIME" rows in both sheets, i.e. update "DC" in sheet-1 from sheet-2 for every row that is in sheet-2

e.g.
sheet-1 looks like this

TIME DC

1039 9
1040 9
1041 9

sheet-2 looks like this

TIME DC

1015 7
1040 7
1120 7

I'd like sheet-1 to end up looking like this, based on the matching TIME=1040 row
TIME DC

1039 9
1040 7
1041 9

I have 2 weeks worth of data (at 1m intervals) to process, so I need a formula or similar to make this update.

Thanks in advance for any help