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
Index and Match.xls
