compare two columns in excel different sheets

Just like the previous example, we will input the price we would like to compare against the price in the “ Jan ” tab.

Begin your function with an equal sign =, then followed by the name of the function, IF, then an open parenthesis (.

Select the cell you would like to input the function in.

The formula will pull records from both tabs and separate them with a character of your choice entered into the formula. In this example, we would be able to use the IF function to show only those cells that differ in price. However, if you would like to visualize how the price differs from January to February, there is another way to do so. In this example, it is “ Match” and “ Differ”.

Similar to using the equal sign =, rows 8, 9, and 10 have a return value of “ Differ” as the price in January and February do not match.Īs mentioned earlier, we can alter the return value for both “ TRUE” and “ FALSE” to any customized value.

Remember to add a comma, between each attribute! In this example, we would use “Match” and “Differ” as our respective values.

Now we would need to add the value_if_true and value_if_false.

Similar to using the equal sign =, we will input the price we would like to compare against the price in the “ Jan ” tab.

Begin your function with an equal sign =, then followed by the name of the function, IF, then an open parenthesis (.

You would have a better understanding of how this works after we go through some examples. You can visit our tutorial on the IF function before proceeding to appreciate the formula!Ĭompared to using the equal sign to compare values, the IF function can tailor the return values if it’s “ TRUE” or “ FALSE”. Here is the syntax (the way we write) of IF function: =IF(logical_expression, value_if_true, value_if_false) The function is used to evaluate whether the data you selected meets certain criteria in a logical test, where the result is always “TRUE” or “FALSE”. The IF function is a very versatile function that can be applied to different scenarios. Using the IF Function to Compare Two Sheets

Once you press Enter, the same return values would appear.

Next, insert another equal sign = and select the value to compare against in the “ Jan ” tab, which is Jan!B4.

Then, select the value that you want to compare from Feb, which is B4.

Similar to Example 1, begin your formula with an equal sign =.

Select the cell you would like to input the formula in.

Instead of copying the values from one tab to another, here is a more direct way.

As shown below, rows 8, 9, and 10 have a return value of “ FALSE ” as there was a price increase.

After you press Enter, your return value should show “ TRUE ” or “ FALSE ”.

Then insert another equal sign =, followed by the value that you want to compare from February, B4.

Begin your formula with an equal sign =, then select the value that you want to compare from Jan, which is D4.

First, click on the cell that you want to write down your formula.

To avoid confusion, rename the respective headers.

Your sheet would now contain two columns of “Cost per piece”.

Then, copy the selected range and paste it into the “ Feb ” tab.Select the range that you would like to compare from the “ Jan ” tab.Not to worry! We are here to show you how you can compare the price list more efficiently.ĭo take note that the above scenario would be adapted for all examples used within the tutorial.Īs you can see, these are two different sets of price lists extracted from two sheets. As there are many products on the price list, it is time-consuming to compare them manually. You have received the price list for February and would like to compare the prices listed against the previous month. Every month, you would be receiving a price list from your supplier for you to restock your inventories.

Let’s say you are a toiletry retailer that sells different toiletries ranging from toothbrushes to deodorants. We can easily use the equal sign = to compare values between two columns or two sheets in Google Sheets. Using the Equal Sign to Compare Two Sheets Using the Add-ons Tool to Compare Two Sheets.Using the IF Function to Compare Two Sheets.Using the Equal Sign to Compare Two Sheets.

Compare two columns in excel different sheets