Advanced Excel Help

MS Excel:  How to use the INDEX Function (WS) This Excel tutorial explains how to use the Excel  INDEX function  with syntax and examples. Description The Microsoft Excel INDEX function returns a value in a table based on the intersection of a row and column position within that table. The first row in the table is row 1 and the first column in the table is column 1. The INDEX function is a built-in function in Excel that is categorized as a  Lookup/Reference Function . It can be used as a worksheet function (WS) in Excel. As a worksheet function, the INDEX function can be entered as part of a formula in a cell of a worksheet. If you want to follow along with this tutorial, download the example spreadsheet. Download Example Syntax The syntax for the INDEX function in Microsoft Excel is: INDEX( table, row_number, column_number ) Parameters or Arguments table A range of cells that contains the table of data. row_number The row position ...

MS Excel:  How to use the HYPERLINK Function (WS) This Excel tutorial explains how to use the Excel  HYPERLINK function  with syntax and examples. Description The Microsoft Excel HYPERLINK function creates a shortcut to a file or Internet address. The HYPERLINK function is a built-in function in Excel that is categorized as a  Lookup/Reference Function . It can be used as a worksheet function (WS) in Excel. As a worksheet function, the HYPERLINK function can be entered as part of a formula in a cell of a worksheet. Syntax The syntax for the HYPERLINK function in Microsoft Excel is: HYPERLINK ( link, [display_name] ) Parameters or Arguments link A path to the file or the URL to the Internet address. display_name Optional. It is the value that appears in the cell. If this parameter is omitted, then the  link  will appear in the cell. Returns The HYPERLINK function creates a hyperlink to a file or Internet address. Applies ...

MS Excel:  How to use the HLOOKUP Function (WS) This Excel tutorial explains how to use the Excel  HLOOKUP function  with syntax and examples. How to handle errors such as #N/A and retrieve the correct results is also discussed. Description The Microsoft Excel HLOOKUP function performs a horizontal lookup by searching for a value in the top row of the  table  and returning the value in the same column based on the  index_number . The HLOOKUP function is a built-in function in Excel that is categorized as a  Lookup/Reference Function . It can be used as a worksheet function (WS) in Excel. As a worksheet function, the HLOOKUP function can be entered as part of a formula in a cell of a worksheet. Syntax The syntax for the HLOOKUP function in Microsoft Excel is: HLOOKUP( value, table, index_number, [approximate_match] ) Parameters or Arguments value The value to search for in the first row of the  table . table Two or more r...

MS Excel:  How to use the COLUMNS Function (WS) This Excel tutorial explains how to use the Excel  COLUMNS function  with syntax and examples. Description The Microsoft Excel COLUMNS function returns the number of columns in a cell reference. The COLUMNS function is a built-in function in Excel that is categorized as a  Lookup/Reference Function . It can be used as a worksheet function (WS) in Excel. As a worksheet function, the COLUMNS function can be entered as part of a formula in a cell of a worksheet. Syntax The syntax for the COLUMNS function in Microsoft Excel is: COLUMNS( reference ) Parameters or Arguments reference A reference to a range of cells or an array. Returns The COLUMNS function returns a numeric value. Applies To Excel 2016, Excel 2013, Excel 2011 for Mac, Excel 2010, Excel 2007, Excel 2003, Excel XP, Excel 2000 Type of Function Worksheet function (WS) Example (as Worksheet Function) Let's look at...

MS Excel:  How to use the COLUMN Function (WS) This Excel tutorial explains how to use the Excel  COLUMN function  with syntax and examples. Description The Microsoft Excel COLUMN function returns the column number of a cell reference. The COLUMN function is a built-in function in Excel that is categorized as a  Lookup/Reference Function . It can be used as a worksheet function (WS) in Excel. As a worksheet function, the COLUMN function can be entered as part of a formula in a cell of a worksheet. Syntax The syntax for the COLUMN function in Microsoft Excel is: COLUMN( [reference] ) Parameters or Arguments reference Optional. It is a reference to a cell or range of cells. If the  reference  parameter is omitted, it assumes that the  reference  is the cell address in which the COLUMN function has been entered in. Returns The COLUMN function returns a numeric value. Applies To Excel 2016, Excel 2013, Excel 2011 f...

MS Excel:  How to use the CHOOSE Function (WS, VBA) This Excel tutorial explains how to use the Excel  CHOOSE function  with syntax and examples. Description The Microsoft Excel CHOOSE function returns a value from a list of values based on a given position. The CHOOSE function is a built-in function in Excel that is categorized as a  Lookup/Reference Function . It can be used as a worksheet function (WS) and a VBA function (VBA) in Excel. As a worksheet function, the CHOOSE function can be entered as part of a formula in a cell of a worksheet. As a VBA function, you can use this function in  macro code  that is entered through the Microsoft Visual Basic Editor. Syntax The syntax for the CHOOSE function in Microsoft Excel is: CHOOSE( position, value1, [value2, ... value_n] ) Parameters or Arguments position The position number in the list of values to return. It must be a number between 1 and 29. value1, value2, ... value_n A list...

MS Excel:  How to use the AREAS Function (WS) This Excel tutorial explains how to use the Excel  AREAS function  with syntax and examples. Description The Microsoft Excel AREAS function returns the number of ranges in a reference. The AREAS function is a built-in function in Excel that is categorized as a  Lookup/Reference Function . It can be used as a worksheet function (WS) in Excel. As a worksheet function, the AREAS function can be entered as part of a formula in a cell of a worksheet. Syntax The syntax for the AREAS function in Microsoft Excel is: AREAS( reference ) Parameters or Arguments reference A range of cells. If you specify more than one range, you must enclose your ranges in parentheses. Returns The AREAS function returns a numeric value. Applies To Excel 2016, Excel 2013, Excel 2011 for Mac, Excel 2010, Excel 2007, Excel 2003, Excel XP, Excel 2000 Type of Function Worksheet function (WS) Example (as Wor...

MS Excel:  How to use the ADDRESS Function (WS) This Excel tutorial explains how to use the Excel  ADDRESS function  with syntax and examples. Description The Microsoft Excel ADDRESS function returns a text representation of a cell address. The ADDRESS function is a built-in function in Excel that is categorized as a  Lookup/Reference Function . It can be used as a worksheet function (WS) in Excel. As a worksheet function, the ADDRESS function can be entered as part of a formula in a cell of a worksheet. Syntax The syntax for the ADDRESS function in Microsoft Excel is: ADDRESS( row, column, [ref_type], [ref_style], [sheet_name] ) Parameters or Arguments row The row number to use in the cell address. column The column number to use in the cell address. ref_type Optional. It is the  type of reference  to use. If this parameter is omitted, it assumes that the  ref_type  is set to 1. It can be any of the following values:...

MS Excel:  How to use the MATCH Function (WS) This Excel tutorial explains how to use the Excel  MATCH function  with syntax and examples. Description The Microsoft Excel MATCH function searches for a value in an array and returns the relative position of that item. The MATCH function is a built-in function in Excel that is categorized as a  Lookup/Reference Function . It can be used as a worksheet function (WS) in Excel. As a worksheet function, the MATCH function can be entered as part of a formula in a cell of a worksheet. Syntax The syntax for the MATCH function in Microsoft Excel is: MATCH( value, array, [match_type] ) Parameters or Arguments value The value to search for in the  array . array A range of cells that contains the  value  that you are searching for. match_type Optional. It the type of match that the function will perform. The possible values are: match_type Explanation 1 (default) The MATCH function ...