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 located in the top row of a table. For vertical lookup VLOOKUP function is used.  Syntax  =HLOOKUP (value, table, row_index,…

Continue Reading

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 a feeder for INDEX. It has two forms- Array and Reference.  Array form In the Array form, first argument in…

Continue Reading

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 range of cells or an array formula, or an array. Keynotes A name range may also be used in COLUMNS…

Continue Reading

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 the reference made to a cell or a range of cells whose Column number has to be found. It is…

Continue Reading

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 is entered in the index number. Syntax =CHOOSE(Index_num,value1,value2,….) Argument Index_num- It is the value argument to be selected. Must be a number between 1 and…

Continue Reading

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: The Excel AREAS function returns the number of areas in a reference. The area can be a range of contiguous cells or a single cell.…

Continue Reading

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 returns a text  of cell address based on the given row and column number. Syntax for excel ADDRESS Function: =ADDRESS(row_num, column_num, [abs_num], [a1], [sheet_text])…

Continue Reading
Close Menu