SummaryIn this post, you will learn how to use VLOOKUP in Excel from different worksheet/sheets.
PurposeCompare & Lookup the value in a table by matching with given criteria.
Syntax=VLOOKUP (lookup_value, table_array, col_index_num, [range_lookup])
ArgumentLookup_value – The value to look for in the first column of a table.
Table_array – The table from which to retrieve a value.
col_index_num – The column in the table from which you want the value in result column
Range_lookup – [optional] TRUE = approximate match (default). FALSE = exact match
Example:In the below example, we have explained how to use VLOOKUP from different sheet. In this example, we compare the sheet 1 value from sheet 3 and find out the state based on the serial no.
In this example, we have showed how to use VLOOKUP from different sheet.
Same way you can use this function for different workbook. You need to just identity the lookup value in both the tables.