Syntax =VLOOKUP (search_key, range, index, [is_sorted]) Inputs search_key: The value to search for in the first column of the range. range: The upper and lower values to consider for the search. index: …

QUERY function Runs a Google Visualization API Query Language query across data. Sample Usage QUERY(A2:E6,"select avg(A) pivot B") QUERY(A2:E6,F2,FALSE) Syntax QUERY(data, query, …

Notes The LOOKUP function will only work properly if data in search_range or search_result_array is sorted. Use VLOOKUP, HLOOKUP, or other related functions if data is not sorted. If search_key is …

To return the value itself or another value corresponding to the row or column the match is found in, use INDEX, HLOOKUP, or VLOOKUP. See Also VLOOKUP: Vertical lookup. Searches down the first …

See Also QUERY: Runs a Google Visualization API Query Language query across data. VLOOKUP: Vertical lookup. Searches down the first column of a range for a key and returns the value of a …

XLOOKUP function The XLOOKUP function returns the values in the result range based on the position where a match was found in the lookup range. If no match is found, it returns the closest match.

QUERY function SPARKLINE Create & use named functions LAMBDA function Visit the Learning Center Using Google products, like Google Docs, at work or school? Try powerful tips, tutorials, and …

Filter Google Sheets function list FILTER function SORT function SORTN Visit the Learning Center Using Google products, like Google Docs, at work or school? Try powerful tips, tutorials, and …

Google Sheets function list Google Sheets supports cell formulas typically found in most desktop spreadsheet packages. Functions can be used to create formulas that manipulate data and calculate …

LOOKUP() is effectively a wrapper to the SELECT() function. As with SELECT(), any column references are interpreted from the perspective of the data set being searched, not that of the data set from …