On Tue, 12 Feb 2008 19:36:17 -0800 (PST), Josh Rogers
wrote:

I'm attempting to display in a cell a concatenated list of items that
match in an array. Here is an example:

Data:
A B
1 Bob Chicken
2 Sally Steak
3 Bob Salad
4 Susan Salad
5 Bob Soda


And for the lookup:

A B
1 Bob Chicken Salad Soda
2 Sally Steak
3 Susan Salad

Column B of the lookup is the portion I'm focusing on here.
Originally, i was able to successfully do this using MCONCAT from the
morefunc addon. This worked great, except I am sending this
spreadsheet to others that do not have this addon installed, and it
isn't reasonable to ask them to install it,

The versions of morefunc that have been released in the last few years have
included the ability to distribute this add-in along with the workbook. It's
not working (yet) in 2007 but if that's not an issue, this may help.

Depending on the options you selected during installation, on the Tools menu
you should have an item labeled Morefunc. ONe of the submenu options is "Embed
morefunc in the workbook"

From Morefunc HELP:

-------------------------
INCLUDING MOREFUNC IN A WORKBOOK
Warning : for the moment (october 2007), the tool described in this page
doesn't work with Excel 2007, because of a bug in a callback function.
Hopefully, it will be fixed by a service pack. Don't use it if you want to
share workbooks using Morefunc with people who work with this Excel version.
It is now possible to include the Morefunc add-in in a workbook, so that the
new functions can be used even if the add-in is not installed. The user has
just to open the workbook, and all functions work as if they were contained in
VBA modules stored in the workbook itself.

HOW TO INCLUDE MOREFUNC IN THE ACTIVE WORKBOOK :
Open the Tools menu, and choose Morefunc = Include Morefunc in the workbook.

This dialog box is opened : **Picture present in help file**



The current version is the version of the Morefunc add-in which is currently
installed on the computer. Included version is the version number of the add-in
already stored in the workbook.

The check boxes Functions and Help file show if Morefunc and its help file are
already present in the active workbook. If you want to include or remove them,
check or uncheck the corresponding options and then click the Update button.

Morefunc will add approximately 350 K to the size of the workbook, and the help
file 150 K.

DETAILED INFORMATIONS :
Embedding Morefunc in a workbook has the following consequences :

It adds a "very hidden" worksheet ("Morefunc Storage Sheet") to the workbook.
The add-in itself and the help file are stored in this sheet as binary data.
It adds a small standard module named modRestoreMorefunc to the VBA project of
the workbook.
It inserts a call to the MorefuncTempInstall Sub in the Workbook_Open event
handler of the workbook.
None of these 3 items should be removed or altered, otherwise the new functions
won't work.

When the workbook is opened, the MorefuncTempInstall sub performs these tasks :

It checks if Morefunc is already installed (and loaded) in the current Excel
instance
If Morefunc is already loaded, it compares its version number with the one of
the Morefunc add-in stored in the workbook.
If the version of the workbook is more recent (or if Morefunc is not
installed), it reads the binary data stored in the hidden sheet, creates a
Morefunc.xll file in the temporary folder and opens it.

--ron