Lookup and return multiple comma-separated values in Excel

[@convergencenellore2901]

Useful program and you had explanation is Excellent 🤝

[@ss208Iro]

This was great and exactly what I was looking for. Good job!

[@ExcelatWork55]

Thanks a lot for your kind words.

[@swagata_piu]

This is awesome 👍

[@ExcelatWork55]

Thank you.

[@nomadmathematician400]

Exactly what I was looking for, thanks heaps.

[@ExcelatWork55]

Glad I could help

[@aravindarajc]

Super. Thanks.

[@ExcelatWork55]

Welcome 😊

[@edwinyulianto3660]

Thanks YOU... very useful for me.

[@ExcelatWork55]

Glad you found the information useful. :)

[@diegoxrivera]

Thank you!!!

[@ExcelatWork55]

You're welcome!

[@likithnagesh1437]

Helped my req. Thanks a ton

[@ExcelatWork55]

Thank you for your kind comment, you’re most welcome.

[@ishitashakya7767]

Now on comma separated field i want to match if my value exists in it or not . Can u suggest

[@ExcelatWork55]

You can use an IF statement after getting the comma separated results.

[@jamesleleji9470]

I think this can also be used to check for duplicate names if the first name and last name were reversed using partial match Eg John Snow, Snow John

[@ExcelatWork55]

Yes, that's why I found it's often useful to return multiple values in a single list.

[@mkkaul2008]

This is good for small dataset probably under 100 but not for big dataset like ~4K records

[@pulkitkhanna8387]

How to use newline character instead of a comma delimiter?

[@ExcelatWork55]

Sorry for the delayed response. In the delimiter section, you can put the ASCII code of the symbol you want to use as the delimiter. For example, you can use something like:
TEXTJOIN(CHAR(13),TRUE,A1,B1). Note that it does not always work for some characters (especially newline character). :(

[@StephanieRickards]

how do i look up and return multiple dates and have the dates formatted as a date?

[@ExcelatWork55]

Thanks, will check and get back.