Google Sheets Lookup Functions

Google Sheets VLOOKUP Function

This post will guide you how to use Google Sheets VLOOKUP function with syntax and examples. Description The Google Sheets VLOOKUP function lookup a value in the first column of the table and return the value in the same row based on index_num position.. The VLOOKUP function can be used to search down the first… read more »

Google Sheets ROWS Function

This post will guide you how to use Google Sheets ROWS function with syntax and examples. Description The Google Sheets ROWS function counts the number of rows in a cell reference. The ROWS function can be used to return the number of rows in a specified range in google sheets. The purpose of this function… read more »

Google Sheets ROW Function

This post will guide you how to use Google Sheets ROW function with syntax and examples. Description The Google Sheets ROW function returns the row number of a cell reference. The ROW function can be used return the row number of a specified cell in google sheets. The purpose of this function is to get… read more »

Google Sheets OFFSET Function

This post will guide you how to use Google Sheets OFFSET function with syntax and examples. Most of google spreadsheet users are very confusing and don’t know how this function works in google sheets. After leaning this function, you should know that this function is very useful and you can read the below guide to… read more »

Google Sheets MATCH Function

This post will guide you how to use Google Sheets MATCH function with syntax and examples. Description The Google Sheets MATCH function search a value in an array and returns the position of that item. The MATCH function can be used to get the position of an item in the given range or array in… read more »

Google Sheets INDIRECT Function

This post will guide you how to use Google Sheets INDIRECT function with syntax and examples. Description The Google Sheets INDIRECT function  returns the cell reference based on a text string, such as: type the text string “A2” in B1 cell, it just a text string, so you can use INDIRECT function to convert text… read more »

Google Sheets INDEX Function

This post will guide you how to use Google Sheets INDEX function with syntax and examples. Description The Google Sheets INDEX function returns a value from a table based on the index (row number and column number). You can use INDEX function to extract entire rows or entire columns. This function is used to combine… read more »

Google Sheets LOOKUP Function

This post will guide you how to use Google Sheets LOOKUP function with syntax and examples. Description The Google Sheets LOOKUP function looks up a value through a sorted row or column and returns the corresponding value from another row or column. The LOOKUP function can be used to lookup a value in a one-row… read more »

Google Sheets HLOOKUP Function

This post will guide you how to use Google Sheets HLOOKUP function with syntax and examples. Description The Google Sheets HLOOKUP function lookup a value in the top row of the table and return the value in the same column based on index_num position. The lookup values must be in the first row of the… read more »

Google Sheets GETPIVOTDATA Function

This post will guide you how to use Google Sheets GETPIVOTDATA function with syntax and examples. Description The Google Sheets GETPIVOTDATA function extracts specific data from a pivot table corresponds to the specified row and column name. The GETPIVOTDATA function can be used to retrieve an aggregated value from a given pivot table by row… read more »

Google Sheets FORMULATEXT Function

This post will guide you how to use Google Sheets FORMULATEXT function with syntax and examples. Description The Google Sheets FORMULATEXT function returns a formula as string. You can get a formula as a text string from a given cell reference. The FORMULATEXT function can be used to extract the formula as text from a… read more »

Google Sheets COLUMNS Function

This post will guide you how to use Google Sheets COLUMNS function with syntax and examples. Description The Google Sheets COLUMNS function returns the number of columns in an Array or a reference. For example, COLUMNS(B1:D4) returns 3, since the range B1:D4 contains 3 columns. The COLUMNS function can be used to get the count… read more »

Google Sheets COLUMN Function

This post will guide you how to use Google Sheets COLUMN function with syntax and examples. Description The Google Sheets COLUMN function returns the first column number of the given cell reference. For example, COLUMN(B4) returns 2, as C is the second column in the google sheets. The COLUMN function can be used to get… read more »

Google Sheets CHOOSE Function

This post will guide you how to use Google Sheets CHOOSE function with syntax and examples. Description The Google Sheets CHOOSE function returns a value from a list of values based on index. For example, =CHOOSE(2,”google”,”sheets”,”book”) returns “sheets” value, and “sheets” value is the second value listed after the index number in this formula. The… read more »

Google Sheets ADDRESS Function

This post will guide you how to use Google Sheets ADDRESS function with syntax and examples. Description The Google Sheets ADDRESS function returns a reference as a text string to a single cell. For example, =ADDRESS(2,3) returns $C$2. The ADDRESS function can return a relative or absolute reference, and you can use it to construct… read more »

Sidebar