index, match, offset worksheet function

[sand]

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

 

[JE McGimpsey]

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.

 

[David Biddulph]

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.

 

[Dave Peterson]

Debra Dalgleish has lots of notes on =vlookup() and =index(match()) here:
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