INDEX and MATCH – an efficient alternative to VLOOKUP

Although VLOOKUP in Excel is a very useful function, it suffers a drawback. If the lookup value to be searched is not in the first column of lookup table, VLOOKUP wouldn’t work. In the last part of this learning series, titled "VLOOKUP: Right to Left Lookup" I have taken you through a trick to address this. Here... Continue Reading →

July 24, 2013 0

Mastering LOOKUPs in Excel learning Series

Here I thought of compiling a learning series covering the basics to classics of Excel Lookup functionality. So I have divided them into parts organized in some logically organized fashion. However, you are free to access and learn them in any order. Part 1: Introduction to VLOOKUP Part 2: VLOOKUP: Approximate match example Part 3:... Continue Reading →

July 21, 2013 0

Up ↑

%d bloggers like this:

Tag: lookups

INDEX and MATCH – an efficient alternative to VLOOKUP

Like this:

Share this:

Like this:

Share this:

Like this: