Search function using commas

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Kylie (Kylie_at_discussions.microsoft.com)
Date: 02/01/05 

Date: Tue, 1 Feb 2005 07:57:07 -0800

I have created a list of names on a seperate work*** and each has a unique
number

1 John Smith
2 Susan
3 Bill
etc

Then on different worksheets in a single cell I want to reference these
names.
So on one work*** in a single cell I might want 1,3 (which would read as
John Smith, Bill).

Say I type "1,3" in cell B1. I have this in B2:
=INDEX(Sheet5!A:A,VALUE(LEFT(B1,SEARCH(",",B1)-1)))&" ,
"&INDEX(Sheet5!A:A,VALUE(MID(B1,SEARCH(",",B1)+1,100)))

This works fine. How do I then expand this function so I can reference more
than two names EG in Cell B1 put 1,3,4,6,7 etc

Thanks for your help
Kylie

Quantcast