Learn Microsoft Excel Online Free
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 »
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 »
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 »
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 »
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 »
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 »
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 »
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 »
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 »
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 »
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 »
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 »
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 »
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 »
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 »
