View Single Post
  #2  
Old July 27th, 2004, 05:47 PM
Frank Kabel
external usenet poster
 
Posts: n/a
Default using Vlookup to find multiple results

Hi
though possible with array formulas I would use Data -
Filter for this kind of application.

-----Original Message-----
I'm designing a form to lookup and select data from a
large database where individuals may have multiple
entries in the same column. Vlookup and/or index/match
will seem to find either the first or the last but how
can you find the other entries where there are more than
two?
.