How To Use VLOOKUP in Excel With Different Sheet

Summary

In this post, you will learn how to use VLOOKUP in Excel from different worksheet/sheets.

Purpose

Compare & Lookup the value in a table by matching with given criteria.

Syntax

=VLOOKUP (lookup_value, table_array, col_index_num, [range_lookup])

Argument

Lookup_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.
VLOOKUP FUNCTION
Sheet 1
VLOOKUP FUNCTION
Sheet 3

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.

scroll to top