Forum home » Delegate support and help forum » Microsoft Excel Training and help » training ms excel advanced - What is a vlookup?
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
training ms excel advanced - What is a vlookup?
Resolved · Low Priority · Version Standard
Reply Thu 13 Sep 2007, 09:44Delegate Melanie said...
For upcoming training course dates see: Pricing & availability
RE: what is a vlookup?
The VLookup function in Excel searches for value in the left-most column of a table_array/range and returns the value in the same row identyfied by the index_number.
The VLookup function has the following syntax:
VLookup( Value, Table_Array, Index_number, not_exact_match )
Value is the value to search for in the first column of the table_array.
Table_array is the two or more columns of data, sorted in ascending order.
Index_number is the column number in the Table_array from which the matching value must be returned. The first column of the Table_array is 1.
Not_exact_match determines if you are looking for an exact match based on value. Enter FALSE to find an exact match. Enter TRUE to find an approximate match. This means that if an exact match isn't found, then VLookup will look for the nearest value that is less than the selected value.
Regards
Carlos
|