Index formula

The UK's most regular instructor-led training courses.
Training information: excel in courses · Excel course london · VBA courses London

Resolved · Low Priority · Version 2003

Index formula

Elina has attended:
Excel VBA course
Excel VBA course

by - delegate Elina [1 post] (2008 May 1 Thu, 16:52) Reply

How can one create index/match formula in VBA?

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003/XP	2008 Jul 17 Thu + 18 Fri	Bloomsbury	3	book now	£475	£495
2003/XP	2008 Jul 30 Wed + 31 Thu	Bayswater	5	book now	£450	£485
2003/XP	2008 Aug 7 Thu + 8 Fri	Bloomsbury	6	book now	£450	£485
2003/XP	2008 Aug 14 Thu + 15 Fri	Bloomsbury	5	book now	£450	£485
2003/XP	2008 Aug 26 Tue + 27 Wed	Bayswater	6	book now	£450	£485
2003/XP	2008 Sep 8 Mon + 9 Tue	Bayswater	7	book now	£345	£399
Full Schedule: See all 48 Excel VBA course dates. Bookings currently available until 26th November 2009.

RE: index formula

by - trainer Stephen gold contributer [283 posts] (2008 Jun 12 Thu, 10:45) Edited on 2008 Jun 12 Thu, 10:46 Reply

Hi Elina

Thank you for your question

All of the worksheet functions are accessable as methods of the application object

For example

V1 = Application.Worksheetfunction.Match(Arg1,Arg2..)

Returns the result of the match function, (with arg1, arg2 etc. replaced by the relevant arguments) to the variable v1

This same technique will work for any of Excel's standard worksheet functions

Hope this is helpful, please feel free to get in touch if you require anything else

Regards

Stephen

· 3 Reasons Why Excel Training Courses For Employees Can Improve Your Business
· Basic Excel Training
· Identifying Suitable Candidates For VBA For Excel Training
· Benefits of learning about Excel charts
· Microsoft Excel Features and Functions for Accountants

Please browse our web site to find out more about
excel in courses and other Microsoft training courses.

Excel tip:

Select only cell that contain text to lock format

For selecting cells that only contain Text in Excel

By selecting cells that only contain text, you can delete, fill or protect cells of this type.

Use short cut to Go to box (F5) or Edit, Go to
In the dialog box, click special button & select Constants and only check text or any other desired type.

Click OK.

And text cells will all be highlighted for you to apply format. Please note only works on one sheet at a time.

View all Excel hints and tips