using Vlookup to find multiple results
Thanks, the problem is I'm using a variable data field in
a form. Thus, I'm selecting an employee, then looking up
various fields for kinds of benefits, beneficiaries,
amounts etc. In one case I need to display the
dependents, and there could be none or there could be as
many as four or five. Because I have over 300
individuals, I have to list the dependents in a column,
and so I can't nest vlookup's to find separate entries.
Does this make sense?
Kent
-----Original Message-----
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?
.
.
|