Example 1: Basic
=VLOOKUP(J1,A1:C5,3,FALSE)
This takes the value in cell J1, and looks for it in the first column of the range A1:C5. If found, it returns the cell value in the corresponding third column.
Example 2: Across sheets
=VLOOKUP(J1,Sheet2!A1:C5,3,FALSE)
This is the same as the simple example, but looks for it on Sheet2.
Example 3: Across workbooks
=VLOOKUP(J1,[Book2.xlsx]Sheet1!A1:C5,3,FALSE)
This is the same as the simple example, but looks for it in the file Book2.xlsx.
Example 1: Basic
=VLOOKUP(J1,A1:C5,3,FALSE)
This takes the value in cell J1, and looks for it in the first column of the range A1:C5. If found, it returns the cell value in the corresponding third column.
Example 2: Across sheets
=VLOOKUP(J1,Sheet2!A1:C5,3,FALSE)
This is the same as the simple example, but looks for it on Sheet2.
Example 3: Across workbooks
=VLOOKUP(J1,[Book2.xlsx]Sheet1!A1:C5,3,FALSE)
This is the same as the simple example, but looks for it in the file Book2.xlsx.