How to use Excel FORMULATEXT function

Introduction FORMULATEXT function in excel is a Math/Trig function. It is a worksheet function. This function is used to retrieve a formula from a reference in form of a text string. Syntax =FORMULATEXT(Reference) Arguments Reference- t is the reference made to a range or cell. Keynotes Reference argument can be from other worksheet also. If the other worksheet to which READ MORE

How to use Excel MATCH function

Introduction MATCH function in excel is a lookup function. It helps in locating cell number corresponding to a lookup value of a row, column or table. It does this by searching for specific value in a range of cells and returns position of value. For Example, if the range A3:A6 have the values 10, 15, 20 respectively then function =MATCH(20,A3:A6,0) READ MORE

How to use Excel HYPERLINK function

Introduction HYPERLINK function in excel a shortcut function that creates a shortcut in the cell in which it is used. This shortcut may contain a reference to another cell of the same worksheet or another worksheet OR may contain a link to a network, internet, web, and intranet. When one clicks on the cell containing that hyperlink, excel opens the READ MORE

How to use Excel ROWS function

Introduction ROWS function in excel is a lookup or reference function. It provides us with number of rows in an array or reference. We have to enter a range in Excel format and it returns number of rows present in that range. For example row A1:A6 gives 6 as the result.     Syntax =ROWS(Array) Arguments array – It can be READ MORE

How to use Excel ROW function

Introduction ROW function in excel is a reference function. It returns the row number of a cell to which reference is made. If we provide no reference than function returns the reference value of the cell in which the function is written. For example =ROW(A9) returns 9 as A9 is the 9th row in Excel. Syntax =ROW(Reference) Arguments Reference- It READ MORE

How to use Excel INDIRECT function

Introduction INDIRECT function in excel is a reference function. It is used to change a text string to a valid reference in formula. It can be used when a reference in form of text need to be changed into a valid reference. This reference does not change when rows and columns are added into the sheet.  Syntax =INDIRECT(ref_text, a1 ) READ MORE

How to use Excel HLOOKUP function

Introduction HLOOKUP function in excel is a lookup function. This function is used to return data from a row in a table. Here ‘H’ stands for horizontal as the function moves horizontally to right in a row to lookup a value. It is used in three ways- Exact value, approximate value, Wildcard value. It is used when comparison values are READ MORE

How to use Excel INDEX function

Introduction INDEX function in excel is a lookup or reference function. It is used to return reference or value from a table or array to another location. It uses both row and column position to retrieve the value. It can return a row, column or a single cell. It is often used in combination with MATCH function, MATCH acts as READ MORE

How to use Excel COLUMNS function

Introduction COLUMNS function in excel is a lookup or reference function. It provides us with number of COLUMNS in an array or reference. We have to enter a range in Excel format and it returns number of COLUMNS present in that range. For example row A1:C6 gives 3 as the result.     Syntax =COLUMNS(Array) Arguments array– It can be the READ MORE

How to use Excel COLUMN function

Introduction COLUMN function in excel is a reference function. It returns the COLUMN number of a cell to which reference is made. If we provide no reference than function returns the reference value of the cell in which the function is written. For example =COLUMN(C9)returns 3 as C9 is the 3RD   Column in Excel. Syntax =COLUMN(Reference) Arguments Reference– It is READ MORE