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

Is there a way to do this?

Thanks

--
John Sharke
-----------------------------------------------------------------------
John Sharkey's Profile: http://www.excelforum.com/member.php...fo&userid=1588
View this thread: http://www.excelforum.com/showthread.php?threadid=27369