Thank you so much! I do want to get this into a single cell, as well, but
this is useful for some other results I need. Thanks so much!!!

"Domenic" wrote:

Assumptions:

A1:B5 contains your source data

First row contains your headers/labels


Formula:

E2, copied across:

=IF(COLUMNS($E1:E1)<=COUNTIF($A$2:$A$5,$D2),INDEX( $B$2:$B$5,SMALL(IF($A$2
:$A$5=$D2,ROW($A$2:$A$5)-ROW($A$2)+1),COLUMNS($E1:E1))),"")

....where D2 contains the program name of interest. The formula needs to
be confirmed with CONTROL+SHIFT+ENTER, not just ENTER. Actually, if you
need to, you can enter your list of program names in Column D, starting
at D2, enter the formula in E2, copy across and down.

Hope this helps!

In article ,
Rashmi wrote:

Hi Ken,
The data is string. I want to lookup on program name and return all the
procs in which the program is in. Here is an example of the data:

PgmName ProcName
VAC001 VM29DX
VAC001 VR68MX
VAC001 VZ14RX
VAC005 VJ15DX

If I do a lookup on VAC001, I want the function to return
VM29DX,VR68MX,VZ14RX. Example:

Pgm Procs
VAC001 VM29DX,VR68MX,VZ14RX

I don't know how many hits each progam name will find (between 1-16).

Thanks for any help you can provide!

Rashmi