What Are The Five Parts Of Vlookup Function?

What are the five parts of VLookup function?

 

I paste directly from excel help below. Is there anything specific you are asking, apart from what is mentioned in the help?  

1. lookup_value Required. The value to search in the first column of the table or range. The lookup_value argument can be a value or a reference. If the value you supply for the lookup_value argument is smaller than the smallest value in the first column of the table_array argument, VLOOKUP returns the #N/A error value.  

2. table_array Required. The range of cells that contains the data. You can use a reference to a range (for example, A2:D8), or a range name. The values in the first column of table_array are the values searched by lookup_value. These values can be text, numbers, or logical values. Uppercase and lowercase text are equivalent.  

3. col_index_num Required. The column number in the table_array argument from which the matching value must be returned. A col_index_num argument of 1 returns the value in the first column in table_array; a col_index_num of 2 returns the value in the second column in table_array, and so on.  

If the col_index_num argument is:  

Less than 1, VLOOKUP returns the #VALUE! error value.  

Greater than the number of columns in table_array, VLOOKUP returns the #REF! error value.  

4. range_lookup Optional. A logical value that specifies whether you want VLOOKUP to find an exact match or an approximate match:  

If range_lookup is either TRUE or is omitted, an exact or approximate match is returned. If an exact match is not found, the next largest value that is less than lookup_value is returned.  

Important If range_lookup is either TRUE or is omitted, the values in the first column of table_array must be placed in ascending sort order; otherwise, VLOOKUP might not return the correct value.  

For more information, see Sort data in a range or table.  

If range_lookup is FALSE, the values in the first column of table_array do not need to be sorted.  

If the range_lookup argument is FALSE, VLOOKUP will find only an exact match. If there are two or more values in the first column of table_array that match the lookup_value, the first value found is used. If an exact match is not found, the error value #N/A is returned.