View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default 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