How to use VLOOKUP from another sheet in Google Sheets

In Google Sheets, VLOOKUP works even if the data you want to search is on a different sheet.
In this example, we'll find someone's email address based on their ID. The list of employees is in Sheet2:

Formula in C3
=VLOOKUP(C2,Sheet2!B4:D7,3,FALSE)
A
B
C
D
E
F
G
1
2
ID
👈 Try changing this value
3
Email
elizabeth@example.com
4
5
6
7
8
Sheet1
Sheet2
Open in Google Sheets
Show arrows
Separator

Procedure

  1. Enter =VLOOKUP in cell C3, where you want the Email address to appear.
  2. Enter the Lookup value C2, which contains the ID (103) you want to look for.
  3. Enter the Search range Sheet2!B4:D7, which is the data range containing all the ID and Email values in the sheet names Sheet2.
  4. Enter Column number 3, as the Email column is the 3rd column of the Search range.
  5. Enter FALSE to look for an exact match.

Result

The final formula is: =VLOOKUP(C2, Sheet2!B4:D7, 3, FALSE)
VLOOKUP returns the value in C3, which is elizabeth@example.com.

Show reference