=Index()

Use this forum for any general discussion and questions about Excel
DaveMarriott
Posts: 5
Joined: Thu May 15, 2014 1:45 pm

=Index()

Postby DaveMarriott » Wed Jul 09, 2014 1:40 pm

Thought I'd kick off a topic here. I've used =index() a reasonable amount over the years but have never really fully appreciated how awesome it is until I stumbled across this post:

http://www.excelhero.com/blog/2011/03/t ... index.html

Its really worth taking the time to read the article and understand each step.

Cheers,

Dave

MattAllington
Posts: 873
Joined: Sun May 04, 2014 4:01 pm
Location: Sydney, Australia

Re: =Index()

Postby MattAllington » Thu Jul 10, 2014 8:08 pm

Thanks for the great link Dave. I never cease to be astounded by some people and here deep deep understanding of some topics. Index/Match is something I have heard a lot about in forums, and they all say Index/Match is far superior to vlookup. I have always had trouble getting used to the index/match syntax. But what I discovered a few weeks ago is that if you write the formulae back to front (ie start from the inside and work out) it is MUCH easier to get your head around. So what I do now is first write the Match() formula and save that. Then I wrap that in an Index() formula. If you do it that way, it is easy.

What do others think of index/match vs vlookup?
Matt Allington is Professional Self Service BI Consultant, Trainer and Author of the book "Learn to Write DAX". You can hire me at http://Exceleratorbi.com.au
http://exceleratorbi.com.au/what-is-power-pivot/
http://xbi.com.au/learndax

rwilson
Posts: 23
Joined: Fri Jun 20, 2014 10:56 am

Re: =Index()

Postby rwilson » Fri Jul 11, 2014 5:41 pm

One of my most used functions.

I stumbled across INDEX() and MATCH() a few years ago and have found the combination invaluable ever since - cCan take a bit of getting used to though.


Return to “Excel”

Who is online

Users browsing this forum: No registered users and 1 guest