![]() Step 2: Use the VLOOKUP function to check whether the values from column A are present in column B. Step 1: Start the 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, and ISNA 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 to someone who doesn’t know anything about the formula/function. However, the #N/A’s are not looking that great in the data. This is how we can compare two columns in Excel using the VLOOKUP function. Also, drag the formula across rows to get the formula applied for all cells. ![]() Note that, if the function finds an exact match for the text in column A under column B, it will reflect the text, otherwise it will reflect the #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 the 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 an 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 the 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 the 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 the formula when we copy it and paste it across different cells. In our case, it is a column named Text B. Which will be the range of data within which we wanted to check the values based on lookup_value. Step 3: The second argument for the VLOOKUP function is table_array. separate it with a comma (“,”) to specify the next argument. Since we are working with cell C2, it is better to use A2 as the lookup value. Since we are trying to lookup whether the values from column Text A are present in a column named Text B, we need to specify the lookup value from column A. Step 2: The first argument we need to specify is the lookup value. ![]() Step 1: Initiate the VLOOKUP function in cell C2 by typing “=VLOOKUP(“. Follow the steps below to get the comparison within these two columns using the VLOOKUP function. In column C, we need to check whether the values in column “Text B” are matching with those in “Text A”. You can download this Compare Two Columns using VLOOKUP Excel Template here – Compare Two Columns using VLOOKUP Excel Template Example #1Ĭonsider mixed data as shown below in columns A and B of the excel sheet.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |