VLookup with Comma Interval

Question

Hi all,&nbsp;&nbsp;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 there any method to achieve this?&nbsp;&nbsp;

ecovonrein · Answer

=INDEX(TEXTSPLIT(TBL[Name],","),1,1). You might need =TRIM too.

riny_van_eekelen · Answer

renjie0315&nbsp;Or perhaps Power Query. Just a quick-and dirty-solution in the attached file.&nbsp;

renjie0315 · Answer

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?

riny_van_eekelen · Answer

renjie0315&nbsp;I've used Power Query (PQ). If you are not familiar with PQ, it's not so easy to just start using it.&nbsp;You could start learning from the site in the link below.&nbsp;It clearly explains all the basics and more advanced features of Power Query.https://exceloffthegrid.com/power-query-introduction/&nbsp;&nbsp;

renjie0315 · Answer

Hi ecovonrein,May I know what is TBL[Name]? It shows there's a problem with this formula. May I know how should I solve this?

Forum Discussion

VLookup with Comma Interval

Share

Resources