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.
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.
