Vlookup

• The vlookup function is a built-in function in Excel that is categorised as a lookup/reference function.
• Vlookup function is used to search a specific information in your spreadsheet.
• The vlookup function performs a vertical lookup by searching for a value in the first column of a table and returning the value in the same row in the index_number position.
• Syntax is vlookup (value, table, index_number, approximate_match).
• Value: The value to search for in the first column of the table.





• Table: Two or more columns of data that is sorted in ascending order.





• Index_number: The column number in table from which the matching value must be returned. The first column is 1.
• If index_number is less than 1, the vlookup function will return #VALUE!.
• If index_number is greater than the number of columns in table, the vlookup function will return #REF!.





• Approximate_match: It is optional. Enter FALSE to find an exact match. Enter TRUE to find an approximate match. If this parameter is omitted, TRUE is the default.
• If you specify FALSE for the approximate_match parameter and no exact match is found, then the vlookup function will return #N/A.





• If you specify TRUE for the approximate_match parameter and no exact match is found, then the next smaller value is returned.

Vlookup from another sheet

• You can use the vlookup to lookup a value when the table is on another sheet using the formula vlookup (value, sheet name!range, index_number, approximate_match).

Vlookup from another workbook

• You can use the vlookup to lookup a value in another workbook. For example, if you wanted to have the table portion of the vlookup formula be from an external workbook, then you could try the formula vlookup (10251, 'C:\[data.xlsx]Sheet1'!A1:B6, 2, FALSE).

My notes