![]() If the initial date test hadn't matched then put "Date doesn't match" in B2. If they don't match at this point then put "Time doesn't match" in B2. If they do match then put the contents of C2 from sheet 2 in to B2. IF A2 from sheet 1 equals A2 on sheet 2, then also check IF B2 on sheet one equals B2 on sheet 2. Here is the formula in C2: =IF(A2=Sheet2!A2,IF(B2=Sheet2!B2,Sheet2!C2,"Time doesn't match"),"Date doesn't match") If either one fails, then we know they don't match. If they do, then we use a second test to see if your times match. So what we do is first check if your dates match. ![]() On the first page of the wizard, select the table that has unmatched records, and then click Next. In the New Query dialog box, double-click Find Unmatched Query Wizard. One the Create tab, in the Queries group, click Query Wizard. The IF formula in Excel looks like this: "IF(Test,)". Use the Find Unmatched Query Wizard to compare two tables. 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. They are close to yours.Īs 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. Here are the two worksheets I have setup. You mentioned sheet rows but sheet rows this will only match on those first 1876 rows. ![]() Note that this will only work for sequential rows. This can be done using 2 IF() statements within Excel. If they do match, you want to copy a column from sheet2 back to sheet1. 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.įrom what I understood, you have 2 columns on sheet1 that you want to match against 2 columns on sheet2. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |