I think MConcat( ) may be a user-defined function. As far as I know, it is
not an Excel 2003 or earlier function.
That said, if you put the subjects into Col C and 'mconcat' both columns,
will it do what you want?
--
Hope this helps.
Thanks in advance for your feedback.
Gary Brown


"lehigh46" wrote:

Hi All,

I have a list of hand typed subjects in column B2 thru B20
I use MCONCAT to group them into cell B1

I now have the need to bring in the subjects via VLOOKUP.
Obviously, MCONCAT will not group formulas.

Any suggestions?

Thanks for your help in advance.