98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Index formula
Index formula
Resolved · Low Priority · Version 2003
Thu 1 May 2008, 16:52Delegate Elina said...
Elina has attended:
Excel VBA Intro Intermediate course
Excel VBA Intro Intermediate course
Index formula
How can one create index/match formula in VBA?
Thu 12 Jun 2008, 10:45
Edited on Thu 12 Jun 2008, 10:46Trainer Stephen said...
RE: index formula
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
Training information:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Adjusting the Elevation and Rotation in a 3-D ChartFor any 3-D chart you create, you can adjust the chart |
