## 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 … 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 … 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 … 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 … Read more

## How to use Excel CHOOSE function

Introduction CHOOSE function in excel is a lookup function. It is to retrieve a value from a table of values. It can retrieve up to 251 values from a list based on an index number. For example, if 1 to 12 represents number of months in a year then CHOOSE retrieves a month whose value … 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: … Read more