Forum Discussion
VLookup with Comma Interval
Hi all, I would like to use VLookup to abstract the phone number and email based on the name given in cell B3 and subsequent column. However, in between the name, there is a comma, may I know is...
Hi Riny_van_Eekelen,
I have downloaded your excel file. However, I can't find any formula or method that you have done, it's a plain file basically. Would you mind to show me where can I locate it?
renjie0315 I've used Power Query (PQ). If you are not familiar with PQ, it's not so easy to just start using it. You could start learning from the site in the link below.
It clearly explains all the basics and more advanced features of Power Query.
https://exceloffthegrid.com/power-query-introduction/
