Match, Index, Offset Function Use

This is really a four part question.

I have read on google the synatx for the match, index, and offset functions and don't still understand why you would use them and in what context.

I also ran across a cell with a formula which contained all three of the functions in one syntax. How do you do that and how is it best used.

If it is possible to provide a few examples that would be helpful. I like to visualize and see what what is going on as I read along.

Thank you.
oononAsked:
Who is Participating?
 
kgerbChief EngineerCommented:
Hi oonon,
Last year I taught a course for a business who wanted specific instruction on lookup functions.  The material I created for this course is attached.  It explains Index, Match, and Offset (along with a few others).  Examples are given as well.  If you need specific help or want to post the example to which you were referring please don't hesitate.  Hope this helps.

Kyle
Look-Up-and-Logic-Functions.doc
0
 
Wayne Taylor (webtubbs)Commented:
Kyle,

That's fantastic! Have you considered submitting it as an article on EE? -> http://www.experts-exchange.com/articles/

Wayne
0
 
kgerbChief EngineerCommented:
Thanks Wayne,
That's means a lot coming from you.  I guess I never thought of posting it as an article.  Maybe I will.  I wrote another one about an introduction to VBA.  I'll e-mail it to you so as to not clutter this thread.

Kyle
0
Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
patrickabCommented:
Kyle,

I've just had a look at your course notes. They are truly excellent. I'd also be interested in reading your introduction to VBA - go on upload them here, I'm sure oonon won't mind a little clutter for a good cause.

Patrick
0
 
kgerbChief EngineerCommented:
Hi Patrick,
Please see attachment.
Macros.doc
0
 
patrickabCommented:
Kyle,

That is utterly fabulous. The amount of work you must have put in to assemble such a document beggars belief - I ask you, 6.9MB of course notes - amazing. You have an undoubted talent for technical writing.

Patrick
0
 
kgerbChief EngineerCommented:
Patrick,
Thank you.  You are very kind.  If you feel anyone may benefit please feel free to distribute.  I will try and put together a few EE articles as Wayne suggested.  Thanks again.

Kyle
0
 
kgerbChief EngineerCommented:
oonon,
Thank you for the points and the grade!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.