The next two sections of the Vlookup tutorial describe two Vlookup examples, in which an exact match is required and a closest match is required.Note: To apply this Look for a value in list, firstly, you should download the Kutools for Excel, and then apply the feature quickly and easily.Īfter installing Kutools for Excel, please do as this:ġ.
If the value is omitted, it uses the default value of TRUE.Ī reminder of the Vlookup syntax, in the form of a handy Vlookup Quick Reference Card, can be printed from the Microsoft Office website. If an exact match to the lookup_value is not found, return an error. Note: if this option is used, the left-hand column of the table_array must be in ascending order.
If an exact match is not found, use the closest match below the lookup_value. The can be set to TRUE or FALSE, meaning: TRUE The array of data that is to be searched for the lookup_value.Note: The Vlookup function searches in the left-most column of this array.Īn integer, specifying the column number of the supplied table_array, that you want to return a value from.Īn optional logical argument that describes what the function should return in the event that it does not find an exact match to the lookup_value. Where the function arguments are: lookup_value
VLOOKUP( lookup_value, table_array, col_index_num, )