Return a list of data, rather than just one value for a lookup
 

Is it possible to do a lookup similar to a vlookup where the formula will
return all of the records that match the criteria rather than just the first
instance?
--
Drew

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