Hi
try the following array formula
=INDEX(result,SMALL(IF(lookup array=lookup value,ROW(lookup
array)),ROW(1:1)))
and copy this down

--
Regards
Frank Kabel
Frankfurt, Germany


John Sharkey wrote:
I have a list of names and telephone numbers. Many people on the list
have multiple numbers. When I use Index(result,Match(lookup
value,lookup array,0)), I always get the first phone number. I would
like to be able to find the second and third phone numbers of
individuals.

Is there a way to do this?

Thanks.