Using VLookup and Concatenate

[sp123]

Hi All

I have a range of values (Example - Age) in a worksheet (wksht1) and in another worksheet i have a the list (Example Name and Age). I would like to use in a single Macro to do a VLOOKUP and get all the Names. Once i have the names I would like to concatenate them into a single cell separated with commas.


I have been struggling to solve this for a long time.
Pls help me

Thanks
Sp123

[antoka05]

See attached file... I hope it can help you.

Regards,
Antonio

[Dav]

The previous answer may be what you want, you have not posted an example and what you are asking for is ambiguous. Alternatively it may be what is attached

Regards

Dav

[sp123]

Thanks a lot! Works like a charm