(C) 2012 - 2017 by Mourad Louha · All rights reserved.

Lookup and reference functions

Description

The description for the function ADDRESS is not available yet.

Availability

The ADDRESS function is available in the following Microsoft Excel versions.

ProductAvailableCategoryNotes
Excel 2013YesLookup & Reference
Excel 2010YesLookup & Reference
Excel 2007YesLookup & Reference
Excel 2003YesLookup & Reference

Syntax

ADDRESS(Row_num,Column_num,Abs_num,A1,Sheet_text)

Arguments

The ADDRESS has the following arguments. Required arguments are bold.

DesignationDescription
Row_num
Column_num
Abs_num
A1
Sheet_text

 


Description

The description for the function AREAS is not available yet.

Availability

The AREAS function is available in the following Microsoft Excel versions.

ProductAvailableCategoryNotes
Excel 2013YesLookup & Reference
Excel 2010YesLookup & Reference
Excel 2007YesLookup & Reference
Excel 2003YesLookup & Reference

Syntax

AREAS(Reference)

Arguments

The AREAS has the following arguments. Required arguments are bold.

DesignationDescription
Reference

 


Description

The description for the function CHOOSE is not available yet.

Availability

The CHOOSE function is available in the following Microsoft Excel versions.

ProductAvailableCategoryNotes
Excel 2013YesLookup & Reference
Excel 2010YesLookup & Reference
Excel 2007YesLookup & Reference
Excel 2003YesLookup & Reference

Syntax

CHOOSE(Index_num,Value1,,Value254)

Arguments

The CHOOSE has the following arguments. Required arguments are bold.

DesignationDescription
Index_num
Value1
:
Value254

 


Description

The description for the function COLUMN is not available yet.

Availability

The COLUMN function is available in the following Microsoft Excel versions.

ProductAvailableCategoryNotes
Excel 2013YesLookup & Reference
Excel 2010YesLookup & Reference
Excel 2007YesLookup & Reference
Excel 2003YesLookup & Reference

Syntax

COLUMN(Reference)

Arguments

The COLUMN has the following arguments. Required arguments are bold.

DesignationDescription
Reference

 


Description

The description for the function COLUMNS is not available yet.

Availability

The COLUMNS function is available in the following Microsoft Excel versions.

ProductAvailableCategoryNotes
Excel 2013YesLookup & Reference
Excel 2010YesLookup & Reference
Excel 2007YesLookup & Reference
Excel 2003YesLookup & Reference

Syntax

COLUMNS(Array)

Arguments

The COLUMNS has the following arguments. Required arguments are bold.

DesignationDescription
Array

 


Description

The description for the function FORMULATEXT is not available yet.

Availability

The FORMULATEXT function is available in the following Microsoft Excel versions.

ProductAvailableCategoryNotes
Excel 2013YesLookup & Reference
Excel 2010No
Excel 2007No
Excel 2003No

Syntax

FORMULATEXT(Reference)

Arguments

The FORMULATEXT has the following arguments. Required arguments are bold.

DesignationDescription
Reference

 


Description

The description for the function GETPIVOTDATA is not available yet.

Availability

The GETPIVOTDATA function is available in the following Microsoft Excel versions.

ProductAvailableCategoryNotes
Excel 2013YesLookup & Reference
Excel 2010YesLookup & Reference
Excel 2007YesLookup & Reference
Excel 2003YesLookup & Reference

Syntax

GETPIVOTDATA(Data_field,Pivot_table,Field1,Item1,,,Field126,Item126)

Arguments

The GETPIVOTDATA has the following arguments. Required arguments are bold.

DesignationDescription
Data_field
Pivot_table
Field1
Item1
:
:
Field126
Item126

 


Description

The description for the function HLOOKUP is not available yet.

Availability

The HLOOKUP function is available in the following Microsoft Excel versions.

ProductAvailableCategoryNotes
Excel 2013YesLookup & Reference
Excel 2010YesLookup & Reference
Excel 2007YesLookup & Reference
Excel 2003YesLookup & Reference

Syntax

HLOOKUP(Lookup_value,Table_array,Row_index_num,Range_lookup)

Arguments

The HLOOKUP has the following arguments. Required arguments are bold.

DesignationDescription
Lookup_value
Table_array
Row_index_num
Range_lookup

 

 
Top