Video Tutorial: Excel VLOOKUP Function

The Excel VLOOKUP function searches for value in the left-most column of table_array and returns the value in the same row based on the col_index_num.

The syntax for the VLOOKUP function is written as follows:

=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])

lookup_value is the value to search for in the first column of the table_array, and can be a value, a reference, or a text string.

table_array is two or more columns of data that is sorted in ascending order. It can be a reference to a range or a range name.

col_index_num is the column number in table_array from which the matching value must be returned. The first column is 1.

range_lookup (optional argument) to find the closest match based on value. Enter FALSE to find an exact match. Enter TRUE to find an approximate match, which means that if an exact match if not found, then the VLookup function will look for the next largest value that is less than value.

If col_index_num is less than 1, the VLookup function will return #VALUE!.
If col_index_num is greater than the number of columns in table_array, the VLookup function will return #REF!.
If you enter FALSE for the range_lookup and no exact match is found, then the VLookup function will return #N/A.

Click below to watch the Excel 2007 VLOOKUP function step-by-step video tutorial:

Get FREE ebooks!
(Click for more info)

Subscribe to...
MS Office Tips Newsletter

E-mail Address:
First Name:

Don't worry -- your e-mail address is totally secure.
I promise to use it only to send you MS Office Tips.

Can't find what you're looking for? Try Google Search!


Back to Top

You're viewing the Excel VLOOKUP function info page, click here to go back to the Home Page