VLOOKUP vs INDEX and MATCH
 

Hi, have been trying to master VLOOKUP and it doesn't seem to meet what I
need. I've seen some comments on using a combination of INDEX and MATCH
instead...
What I'm looking for are some worked examples on any of these three that I
can download Excel files for, to take a look at properly...

Cheers

VLOOKUP vs INDEX and MATCH
 

Andy,

Comes with an example workbook:-

http://www.cpearson.com/excel/lookups.htm

Mike

"Andy" wrote:

Hi, have been trying to master VLOOKUP and it doesn't seem to meet what I
need. I've seen some comments on using a combination of INDEX and MATCH
instead...
What I'm looking for are some worked examples on any of these three that I
can download Excel files for, to take a look at properly...

Cheers