How To Compare Two Google Sheets?
How to Compare Two Sheets for Exact Row Matches Create a third Sheet (by clicking on the ‘+’ icon at the bottom of the window. In cell A2 of this sheet type the formula: =IF(AND(Sheet1! A2=Sheet2! A2,Sheet1! B2=Sheet2! Copy the formula down to the rest of the column by dragging the cell’s fill handle. How […]