If all values in the lookup column are greater than the search key, an #N/A error is returned. If an exact match is not found, the formula searches for the closest match that is less than or equal to search_key. More precisely, it searches for exact match first. In this case a Vlookup formula returns an approximate match. If is_sorted is TRUE or omitted (default), the first column of range must be sorted in ascending order, i.e.Is_sorted - indicates whether the lookup column is sorted (TRUE) or not (FALSE). If it's greater than the number of columns in range, VLOOKUP returns the #REF! error. If index is less than 1, a Vlookup formula returns the #VALUE! error. Index - the column number in range from which a matching value (value in the same row as search_key) should be returned. The Google Sheets VLOOKUP function always searches in the first column of range. Range - two or more columns of data for the search. For example, you can search for the word "apple", number 10, or the value in cell A2. Search_key - is the value to search for (lookup value or unique identifier). The first 3 arguments are required, the last one is optional: The syntax for the Google Sheets VLOOKUP function is as follows: The VLOOKUP function in Google Sheets is designed to perform a vertical lookup - search for a key value (unique identifier) down the first column in a specified range and return a value in the same row from another column.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |