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 Vlookup to return all matching values without duplicates into one cell.Vlookup to return all matching values into one cell.Vlookup to return multiple values into one cell with TEXTJOIN function (Excel 2019 and Office 365) But, sometimes, you want to return all the corresponding values which meet the criteria into one cell as following screenshot shown, how could you solve it? Normally, in Excel, when you use the VLOOKUP function, if there are multiple values to match the criteria, you just can get the first one. How to vlookup to return multiple values in one cell in Excel?
0 kommentar(er)
