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 Training and help » Index/match functions
Index/match functions
Resolved · Medium Priority · Version 2000
Fri 18 Sep 2009, 15:33Delegate Mark said...
Mark has attended:
Excel Advanced course
Index/match functions
Please explain how the following formula works. i.e. how do the index and match functions work?
=INDEX('P&L & BS Data'!$1:$65536,MATCH($D$2&"."&M$28,'P&L & BS Data'!$A:$A,0),MATCH($L48&"M"&RIGHT(100+$K48,2)&".IAS Actuals.US Dollar",'P&L & BS Data'!$1:$1,0))
Tue 22 Sep 2009, 11:09Trainer Simon said...
RE: Index/match functions
Hi Mark,
Thank you for your question.
I will attach an excel spreadsheet in my next email showing you an example of an Index and Match function.
Late this afternoon I will send you an example of an array function.
Regards
Simon
Attached files...
Index and Match.xlsTue 29 Sep 2009: Automatically marked as resolved.
Training information:
See also:
|
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:Find cells that match a formatIn Excel you may wish to find cells that contain a specific formatting such s colour. |
