I have re-created your spreadsheet, with the exception of the "combined" column because it isn't necessary if you were only using it to be able to match.
From what I understood, you have 2 columns on sheet1 that you want to match against 2 columns on sheet2. If they do match, you want to copy a column from sheet2 back to sheet1. This can be done using 2 IF() statements within Excel. Note that this will only work for sequential rows. You mentioned sheet1 has 1876 rows but sheet2 has 8785 rows; this will only match on those first 1876 rows.
Here are the two worksheets I have setup. They are close to yours.
![Excel Sheet 2](https://i.stack.imgur.com/QPNh5.png)
As you can see in the pictures, I have made rows 2 and 3 the same in each sheet, and then I made the date and time not match in row 4, and only the time not match in row 5.
If both items match, it takes the information from column C on sheet 2 and shows it in column C on sheet 1, which I believe is what you're asking for.
The IF formula in Excel looks like this: "IF(Test,[Value if True],[Value if False])". So what we do is first check if your dates match. If they do, then we use a second test to see if your times match. If either one fails, then we know they don't match.
Here is the formula in C2:
=IF(A2=Sheet2!A2,IF(B2=Sheet2!B2,Sheet2!C2,"Time doesn't match"),"Date doesn't match")
To break down the formula, it says:
IF A2 from sheet 1 equals A2 on sheet 2 [IF(A2=Sheet2!A2], then also check IF B2 on sheet one equals B2 on sheet 2 [IF(B2=Sheet2!B2]. If they do match then put the contents of C2 from sheet 2 in to B2 [Sheet2!C2]. If they don't match at this point then put "Time doesn't match" in B2. If the initial date test hadn't matched then put "Date doesn't match" in B2.
Best Answer
On Sheet1, in cell C1, enter the following formula, which uses VLOOKUP: to find the corresponding price on Sheet2.
= VLOOKUP(A1, Sheet2!A:B, 2, FALSE)
Make sure that Sheet2 is sorted by SKU, or VLOOKUP won't work right.
Select column B on Sheet1, select Format->Conditional Formatting, change "Cell Value Is" to "Formula Is", and enter
= B1 <> C1
If you want the cell to turn green when there's no matching SKU, use this instead:
= IF(ISNA(C1), TRUE, B1 <> C1)
Click on format and select the green formatting you want for the mismatch cells.
Hide column C, if you want.