index, match, offset worksheet function
 

Hi all,

I am a new excel user i am using excel 2003 for analysis purpose ,please
tell me what is the use of above metioned excel function, and where do i get
complete information about these functions

Thanx & regards,
Sand

index, match, offset worksheet function
 

See Help ("Index", "Match", "Offset").

All these topics describe "the use" of the functions, and "information
about" these functions. The information is comprehensive, but if you
have specific questions that aren't addressed, post them here.

In article ,
sand wrote:

Hi all,

I am a new excel user i am using excel 2003 for analysis purpose ,please
tell me what is the use of above metioned excel function, and where do i get
complete information about these functions

index, match, offset worksheet function
 

index, match, offset is not one Excel function, but 3.
In each case, the answer is Excel help.
Type the function name into help, and it will describe the function, show
the syntax, usually give examples, and often give a "See Also" link to
related functions.

Beyond that, Googling either the web or the archives of these groups will
give you vast amounts of extra info.
--
David Biddulph

"sand" wrote in message
...
Hi all,

I am a new excel user i am using excel 2003 for analysis purpose ,please
tell me what is the use of above metioned excel function, and where do i
get
complete information about these functions

Thanx & regards,
Sand

index, match, offset worksheet function
 

Debra Dalgleish has lots of notes on =vlookup() and =index(match()) he
http://www.contextures.com/xlFunctions02.html (for =vlookup())
and
http://www.contextures.com/xlFunctions03.html (for =index(match()))
and
http://contextures.com/xlFunctions02.html#Trouble


sand wrote:

Hi all,

I am a new excel user i am using excel 2003 for analysis purpose ,please
tell me what is the use of above metioned excel function, and where do i get
complete information about these functions

Thanx & regards,
Sand

--

Dave Peterson