Using VLOOKUP to compare two columns in Excel Compare two columns in Google sheets using VLOOKUP The values 19001, 19003, 1906 are present in the two lists.įigure 5. VLOOKUP returning #N/A for unmatched valueīelow table shows the final results after comparing the two lists using VLOOKUP. Excel VLOOKUP returning matched value in two columnsįor the next value in column B, “19002”, the VLOOKUP function returns “#N/A” in cell D4 because “19002” is not found in column C.įigure 4. The range_lookup is FALSE, which means that the function will look for an exact match.Īs a result, the value in cell D3 is “ 19001 ”, because the value in column B “19001” is found in column C.įigure 3. Otherwise, the function will return the value “ #N/A ”. The col_index_num is 1, which returns the value in the first column relative to the table_array if the value in column B is found in column C. Our lookup_value is the value in column B (B3), while our table_array is the set of values in column C, $C$3:$C$9. Step 3 : Copy the formula in cell D3 to cells D4:D9 by clicking the “+” icon at the bottom-right corner of cell D3 and dragging it down Enter the formula in cell D3: =VLOOKUP(B3,$C$3:$C$9,1,FALSE) In order to determine if a value in the first column (List 1) exists in another column (List 2) and return the value itself, we follow these steps: if FALSE, VLOOKUP will only find an exact match.if TRUE or omitted, VLOOKUP returns either an exact or approximate match.– optional value can either be TRUE or FALSE.col_index_num – the column number in the table_array corresponding to the information we want to retrieve, relative to the lookup_value.table_array – the range of cells containing the data we want to find or retrieve. ![]()
0 Comments
Leave a Reply. |