So, it is better to omit this argument in case you need to perform either an approximate or an exact match. The default value of ‘ range_lookup’ is TRUE.It returns a ‘#REF!’ error if the value of ‘ column_index’ is greater than the number of columns in the ‘ table_array’.It returns a ‘#VALUE!’ error if the value of ‘ column_index’ is less than 1.Excel VLOOKUP returns a ‘#N/A’ if it is not able to find the ‘ lookup_value’ inside the ‘ table_array’.VLOOKUP function performs a case-insensitive lookup.Few Important points about the Vertical Lookup function If its value is ‘False’ then the only an exact match will be returned. Here, if an exact match is not found, the next value that is less than ‘ lookup_value’ is returned. If its value is ‘True’ then either an approximate or an exact match will be returned. ‘ range_lookup’ is a Boolean value that specifies whether you want VLOOKUP to find an exact match or an approximate match. Similarly ‘ column_index’ 2 would return values from the second column in the ‘ table_array’. A ‘ column_index’ 1 would return values from the first column in the ‘ table_array’. ‘ column_index’ is the relative index of the column whose value needs to be returned by the VLOOKUP function.

The leftmost column of this range must contain the ‘ lookup_value’. ‘ table_array’ argument can receive a range reference or a named range. ‘ table_array’ is the range with two or more columns. Here, ‘ lookup_value’ specifies the value to be searched inside the ‘ table_array’. = VLOOKUP( lookup_value, table_array, column_index, range_lookup )

To add a column to a datasheet from some other table, based on some unique (attribute)s.

To look up a single or a set of values from a data sheet.

This function is mostly used for the following tasks: By default, the table must be sorted in ascending order.” What are the uses of Vertical Lookup Function?

How to return multiple columns from a VLOOKUP?Īccording to Microsoft Excel VLOOKUP can be defined as a function, “that looks for a value in the leftmost column of a table, and then returns a value in the same row from a column you specify.

Few Practical Examples of Vertical Lookup function.

5 Beginner level examples of VLOOKUP function.

Few Important points about the Vertical Lookup function.

What are the uses of Vertical Lookup Function?.

Excel vlookup tutorial