View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ken Johnson
 
Posts: n/a
Default Return a list of data, rather than just one value for a lookup

Hi Drew,

Check out Chip Pearson's Arbitrary Lookup where you can specify which
occurrence to get

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

Ken Johnson