Lookup and reference

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 …

How to use Excel INDEX function 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 …

How to use Excel COLUMNS function 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 …

How to use Excel COLUMN function Read More »

AREAS function in excel

Version in which AREAS function can work: AREAS function in excel will work in Excel for Android phones Excel Mobile Excel Starter Excel 2016 Excel 2013 Excel 2010 Excel 2007 Excel 2016 for Mac Excel for Mac 2011 Excel Online Excel for iPad Excel for iPhone Excel for Android tablets. About AREAS function in excel: …

AREAS function in excel Read More »

Excel address function

Version in which ADDRESS function can work: Excel ADDRESS function will work in Excel for Android phones Excel Mobile Excel Starter Excel 2016 Excel 2013 Excel 2010 Excel 2007 Excel 2016 for Mac Excel for Mac 2011 Excel Online Excel for iPad Excel for iPhone Excel for Android tablets . About excel ADDRESS function: The …

Excel address function Read More »