![]() Using the optional range_lookup argument is complicated for many people to understand, so it's worth looking at a quick example. The col_index_num argument is the resulting range value.The table_array contains all ranges and a column that contains the range value (such as high, medium, or low).The lookup_value is the value you want to check whether it falls inside a range defined by the table_array.If the range_lookup argument is TRUE, then: If omitted, the value is TRUE by default. The range_lookup argument is either "TRUE" or "FALSE." Use TRUE for an approximate match and FALSE for an exact match. Range_lookup (optional) - Indicates whether or not the lookup-value falls within a range contained in the table array. If you reference a number greater than the number of columns in the table array, the function will return the #REF! error.The first column must contain the lookup_valueĬol_index_num (required) - This is the column number of the value you want to find.The table_array must contain at least two columns of data.Table_array (required) - This is the table of data (a range of cells) that VLOOKUP searches to find the information you need. Lookup_value (required): The value to search for in the first column of the table array. The four arguments for the VLOOKUP function are as follows: The VLOOKUP function might look confusing because it contains four arguments, but it's straightforward to use. =VLOOKUP(lookup_value,table_array,col_index_num,range_lookup)
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |