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.