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

Lookup and reference functions

Description

The description for the function RTD is not available yet.

Availability

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

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

Syntax

RTD(ProgID,Server,Topic1,Topic2,,Topic253)

Arguments

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

DesignationDescription
ProgID
Server
Topic1
Topic2
:
Topic253

 


Description

The description for the function TRANSPOSE is not available yet.

Availability

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

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

Syntax

TRANSPOSE(Array)

Arguments

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

DesignationDescription
Array

 


Description

The description for the function VLOOKUP is not available yet.

Availability

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

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

Syntax

VLOOKUP(Lookup_value,Table_array,Col_index_num,Range_lookup)

Arguments

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

DesignationDescription
Lookup_value
Table_array
Col_index_num
Range_lookup

 

 
Top