Hi Russ

Vlookup works with a unique list. You should only have 1 instance of a
unique name in that list, and if I am not mistaken, it should also be sorted,
for VLookup to work properly. If you use FALSE in your formula, it will then
find an exact match. If you use TRU, it will find the closest match. Why
not remove the duplicates? If however you are trying to find out how many
instances of a name there are in a given list, use Data|Autofilter, and
filter for the specific name. You will then see all the instances of that
name.
--
ve_2nd_at. Randburg, Gauteng, South Africa


"Russ B" wrote:

For vlookup, If there are two or more values in the first column of
table_array that match the lookup_value, the first value found is used. I
have several matches for each lookup value. Which function/functions can i
use to show all the matches under each lookup value.

Thank ou in anticipation!
Russ