(C) 2012 - 2018 by Mourad Louha · All rights reserved.
Privacy  ·  Imprint

Lookup and reference functions

Description

The description for the function HYPERLINK is not available yet.

Availability

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

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

Syntax

HYPERLINK(Link_location,Friendly_name)

Arguments

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

DesignationDescription
Link_location
Friendly_name

 


Description

The description for the function INDEX is not available yet.

Availability

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

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

Syntax

INDEX(Array,Row_num,Column_num)

Arguments

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

DesignationDescription
Array
Row_num
Column_num

 


Description

The description for the function INDIRECT is not available yet.

Availability

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

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

Syntax

INDIRECT(Ref_text,A1)

Arguments

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

DesignationDescription
Ref_text
A1

 


Description

The description for the function LOOKUP is not available yet.

Availability

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

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

Syntax

LOOKUP(Lookup_value,Lookup_vector,Result_vector)

Arguments

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

DesignationDescription
Lookup_value
Lookup_vector
Result_vector

 


Description

The description for the function MATCH is not available yet.

Availability

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

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

Syntax

MATCH(Lookup_value,Lookup_array,Match_type)

Arguments

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

DesignationDescription
Lookup_value
Lookup_array
Match_type

 


Description

The description for the function OFFSET is not available yet.

Availability

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

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

Syntax

OFFSET(Reference,Rows,Cols,Height,Width)

Arguments

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

DesignationDescription
Reference
Rows
Cols
Height
Width

 


Description

The description for the function ROW is not available yet.

Availability

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

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

Syntax

ROW(Reference)

Arguments

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

DesignationDescription
Reference

 


Description

The description for the function ROWS is not available yet.

Availability

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

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

Syntax

ROWS(Array)

Arguments

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

DesignationDescription
Array

 

 
Top