The syntax for VLOOKUP is: VLOOKUP (lookup_value, table_array, col_index_num[, exact This spreadsheet contains sample data to show how VLOOKUP applies to a set of rows and columns: In this example ...

Since pre-2019 versions of Excel don't support XLOOKUP, don't discard VLOOKUP and HLOOKUP altogether! There may still be cases when you need to use them, like if you're sending a spreadsheet to ...

they will automatically update in Sheet 2 as well. Using VLOOKUP is ideal if you’re searching for specific data in a column and want to pull corresponding information from another sheet.