![compare two columns in excel and find missing compare two columns in excel and find missing](https://www.exceldemy.com/wp-content/uploads/2017/07/Match-Two-Columns-19.png)
![compare two columns in excel and find missing compare two columns in excel and find missing](https://cdn.extendoffice.com/images/stories/doc-excel/find-missing-values-between-two-columns/doc-find-missing-values-between-two-columns-5.png)
Also, drag the formula across the rows to get the desired output in terms of “Present” or “Not Present”. Step 5: Close the parentheses to complete the formula and press Enter button to get the output in cell C2. Use “Present” as a value for the argument. Step 4: For value_if_false, we need to specify the value. Step 3: Now, we need to specify the values for value_if_true argument for conditional IF. See the screenshot below for a better understanding. Close the parentheses for both VLOOKUP and ISNA function. Step 2: Use VLOOKUP function to check whether the values from column A are present in column B. Step 1: Start formula with “=IF(“ and within it use ISNA as a nested function as shown below: In this example, we are going to use conditional IF, ISNA along with VLOOKUP to see whether the values from column A are present in column B or not. Let’s see another example where we try to get a more concrete solution for this issue. It may look weird for someone who doesn’t know anything about the formula/function. However, the #N/A’s are not looking that great in data. This is how we can compare two columns in Excel using VLOOKUP function.
![compare two columns in excel and find missing compare two columns in excel and find missing](https://www.excelhow.net/wp-content/uploads/2020/06/Compare-Two-Columns-5.png)
Also, drag the formula across rows to get the formula applied for all cells. Note that, if function finds an exact match for the text in column A under column B, it will reflect the text, otherwise it will reflect #N/A error. Step 6: Use closing parentheses to complete the formula and press Enter to get the output. Note that, we can also use the Boolean values for TRUE and FALSE as 1 and 0 respectively under VLOOKUP function. We will be interested here in exact matches thus we will use FALSE as range_lookup argument. Since it specifies whether we want an exact match or approximate match, we can use TRUE (approximate match) or FALSE (exact match) for the same. Step 5: The last argument is optional which is range_lookup. Since we only have one column selected as table_array, we can use col_index_num value as 1. Step 4: Third and most important argument is to specify the column index from the table_array which can be used to lookup the values. You can use keyboard shortcut F4 to fix the table range. Thus, select range from B2:B9 as a table_array and fix it using dollar signs so that the range will be the same for formula when we copy it and paste across different cells. Which will be the range of data within which we wanted to check the values based on lookup_value. Step 3: Second argument for VLOOKUP function is table_array. separate it with comma (“,”) to specify the next argument. Since we are working with cell C2, it is better to use A2 as lookup value. Since we are trying to lookup whether the values from column Text A are present in column named Text B, we need to specify lookup value from column A. Step 2: The first argument we need to specify is lookup value. Step 1: Initiate the VLOOKUP function in cell C2 by typing “=VLOOKUP(“. We will discuss Examples of Compare Two Columns in Excel. Examples of Compare Two Columns in Excel using VLOOKUP
COMPARE TWO COLUMNS IN EXCEL AND FIND MISSING HOW TO
We will see some examples using which we can specify how to compare two columns in Excel using the VLOOKUP function.
![compare two columns in excel and find missing compare two columns in excel and find missing](https://datachant.com/wp-content/uploads/2017/06/Screenshot_55.png)
Range_lookup – is an optional argument that specifies whether we need an exact matching value (FALSE) or approximate matching values (TRUE).col_index_num – is the column number in the range of data from which we are going to get the values after lookup.table_array – is the table/range of the data within which we want to check specific values based on the lookup value.lookup_value – is the value which is used as reference while looking up.As this function is potent to capture/looks up the data among several other columns based on a lookup value. When we have two columns and need to check whether reference values from one column are available in another column, VLOOKUP can be the best alternative to do so. Excel functions, formula, charts, formatting creating excel dashboard & others How to Compare Two Columns in Excel Using VLOOKUP?