To ignore the duplicates in the returned matching values, please do with the below code.ġ. Vlookup to return all matching values without duplicates into one cell Then save and close this code, go back to the worksheet, and enter this formula: =CONCATENATEIF($A$2:$A$11, E2, $C$2:$C$11, ", ") into a specific blank cell where you want to place the result, then drag the fill handle down to get all the corresponding values in one cell that you want, see screenshot: XResult = VBA.Mid(xResult, VBA.Len(Separator) + 1)ģ. XResult = xResult & Separator & ConcatenateRange.Cells(i).Value If CriteriaRange.Cells(i).Value = Condition Then If CriteriaRange.Count ConcatenateRange.Count Then VBA code: Vlookup to return multiple values into one cell Function ConcatenateIf(CriteriaRange As Range, Condition As Variant, ConcatenateRange As Range, Optional Separator As String = ",") As Variant
![how to use vlookup in excel 2010 youtube how to use vlookup in excel 2010 youtube](https://howtovlookupinexcel.com/wp-content/uploads/2013/03/Image_2007_11.jpg)
HOW TO USE VLOOKUP IN EXCEL 2010 YOUTUBE CODE
Click Insert > Module, and paste the following code in the Module Window.
![how to use vlookup in excel 2010 youtube how to use vlookup in excel 2010 youtube](https://i.ytimg.com/vi/q6G-11CF83o/maxresdefault.jpg)
Hold down the ALT + F11 keys, and it opens the Microsoft Visual Basic for Applications window.Ģ. Vlookup to return all matching values into one cellġ. The above TEXTJOIN function is only available for Excel 2019 and Office 365, if you have other lower Excel versions, you should use some codes for finishing this task. Note: In the above formula, A2:A11 is the lookup range contains the lookup data, E2 is the lookup value, C2:C11 is the data range that you want to return the matching values from, " ," is the separator to separate the multiple records. Please apply the below formula into a blank cell where you want to put the result, then press Ctrl + Shift + Enter keys together to get the first result, and then drag the fill handle down to the cell you want to use this formula, and you will get all corresponding values as below screenshot shown: Vlookup to return all matching values into one cell If you have the higher version of the Excel such as Excel 2019 and Office 365, there is a new function - TEXTJOIN, with this powerful function, you can quickly vlookup and return all matching values into one cell. Vlookup to return multiple values into one cell with a useful feature Vlookup to return multiple values into one cell with User Defined Function
![how to use vlookup in excel 2010 youtube how to use vlookup in excel 2010 youtube](https://www.websiterating.com/wp-content/uploads/ExcelIsFun-1024x419.png)
HOW TO USE VLOOKUP IN EXCEL 2010 YOUTUBE HOW TO
How to vlookup to return multiple values in one cell in Excel?