But if there are two or more values in the first column of table_array that match the lookup_value, the vlookup will only use the value of the first found. If an exact match value can’t be found, it will return a #N/A error value. If the range_lookup is either FALSE or is 0, the VLOOKUP function will only return an exact match.Otherwise, VLOOKUP might not return the correct value. Important: In this circumstance, the values in the first column of the table_array must be sorted in ascending order =VLOOKUP(lookup_value, table_array, col_index) =VLOOKUP(lookup_value, table_array, col_index, TRUE) If an exact match can’t be found, it will match the next smallest value. If the range_lookup is either TRUE or is omitted, the VLOOKUP function will return an exact match or an approximate match.Range_lookup ( optional): This is a logical value that determines whether this VLOOKUP function will return an exact match or an approximate match: The first column number is 1 for the left-most column of table_array.Table_array ( required): The table contains two or more columns where the lookup value column and the result value column locating.Ĭol_index ( required): The specific column number (it is an integer) of the table_array, which you will return the matched value from. It must be in the first column of the table_array range. Lookup_value ( required): The value you are searching for.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |