Hold down the ALT + F11 keys to open the Microsoft Visual Basic for Applications window.Ģ. ![]() Normally, there is no direct way for us to extract and return the multiple matching values and separated by comma into one cell, here, you can create a User Defined Function to solve this job, please do as follows:ġ. Return multiple lookup values in one comma separated cell with Kutools for Excel Return multiple lookup values in one comma separated cell with User Defined Function How could we get and return multiple lookup values in one comma separated cell in Excel? In Excel, we can apply the VLOOKUP function to return the first matched value from a table cells, but, sometimes, we need to extract all matching values and then separated by a specific delimiter, such as comma, dash, etc… into a single cell as following screenshot shown. How to return multiple lookup values in one comma separated cell?
0 Comments
Leave a Reply. |