Thanks Biff. I'll give this a try.
"Biff" wrote:
Hi!
This can be done easily if the values returned are returned to individual
cells.
See Domenic's reply.
If you absolutely need to have the returned values all in a single cell it's
not so easy and requires a special add-in that has a function to do this.
That add-in can be found he
http://xcell05.free.fr/
Click the English button and look for the MOREFUNC add-in.
Biff
"Rashmi" wrote in message
...
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
"Ken Wright" wrote:
Example?
is the data numeric or text. If numeric do you mean you want to sum all
the
values in one column where they meet the VLOOKUP criteria (If so then you
really want SUMIF and not VLOOKUP).
Give us some more details, and perhaps an example of your data plus the
desired output so we don't have to guess at what you want to do.
--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03
------------------------------Â*------------------------------Â*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------Â*------------------------------Â*----------------
"Rashmi" wrote in message
...
I have data where the lookup column has more than one row resulting. I
want
to retrieve all matches and put the result in one cell. Can anyone
help?
Thanks!!