Search:

Hi Rick, such a god-sent! This VBA is marvelous

Can I follow this up by asking if this can be a lookupconcat UDF for multiple criteria?

Hi Rick, thanks for the help. I do still have some trouble with this code.

It will produce the word 'and' for even cells that only contain 1 name.

So for my example I gave previously, it worked...

Rick, this is digging up old posts, I know. But this VB really saved me so much trouble.

I do have one need from this code though, that is, to add 'and' for the last two sets to variables looked...