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...
=INDEX(TEXTSPLIT(TBL[Name],","),1,1). You might need =TRIM too.
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?
May I know what is TBL[Name]? It shows there's a problem with this formula. May I know how should I solve this?
Hi ecovonrein,
I presume TBL stands for Table. This is the error that I faced when I select the table.
I dunno the naming conventions of your spreadsheet. TBL was just a placeholder for whatever name you use. From the screenshot it appears your TBL is called "Table1_2". Except that while it looks like a "Table", the #NAME suggests that it isn't actually an Excel table because the structured reference "[Name]" does not appear to be recognized. So replace that structured reference with your hard coordinates, eg =INDEX(TEXTSPLIT(B3,","),1,1).
