Jul 08 2022 04:35 AM
Is it possible to use text join along with vlookup function to get values from different columns in to one cell? If so how can this be done. If it is not possible with these two functions is there any other method to do this.
Jul 08 2022 04:44 AM
Could you explain in more detail what you want.
And could you attach a sample workbook (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar? Thanks in advance.
Jul 08 2022 04:45 AM
SolutionJul 09 2022 11:32 PM
Jul 08 2022 04:45 AM
Solution=TEXTJOIN(",",,VLOOKUP(C10,F5:I8,{2,3,4},FALSE))
You can try this formula.