➤ FILTER(B5:B10, IFNA(VLOOKUP(B5:B10, D5:D10, 1, FALSE), “”)””)įinally, the FILTER function sifts out the blank cells. For #N/A results, it returns a blank cell. Then, this part returns the result of the expression VLOOKUP(B5:B10, D5:D10, 1, FALSE). The column number is 1 as there is only a single column. Here, it looks for B5:B10 cell values in the range D5:D10. Then, press Enter and it’ll return the common values present in columns B and D.
Therefore, follow the steps below to perform the task.
In our first method, we’ll use this function to compare columns B and E and then fill up the missing products in column F. The VLOOKUP function can compare different columns in Excel and bring out the common data. Compare Multiple Columns in Excel and Return Matching Data Using VLOOKUP This is optional.ĥ Methods to Compare Multiple Columns Using VLOOKUP in Excel 1. 0 for an exact match, 1 for a partial match. : Tells whether an exact or partial match of the lookup_value is required. Table_array: The table in which it looks for the lookup_value in the leftmost column.Ĭol_index_num: The number of the column in the table from which a value is to be returned. Lookup_value: The value to look for in the leftmost column of the given table. VLOOKUP(lookup_value, table_array, col_index_num, ) Compare Multiple Columns Using VLOOKUP.xlsx
0 kommentar(er)
