
Probably other functions can be used instead of VLOOKUP:
=TEXTJOIN(", ", TRUE, FILTER(B2:B5, A2:A5="John"))
This assumes that the example starts at A1.
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Hi,
I need to use the VLOOKUP function in order to return more results in a single cell by concatenating each result.
F.e. in this scenario:
searching for John in a cell I'd like to have "Pen, Rubber", if possible.
Any suggests to me, please?
Probably other functions can be used instead of VLOOKUP:
=TEXTJOIN(", ", TRUE, FILTER(B2:B5, A2:A5="John"))
This assumes that the example starts at A1.
Hi,
There is a limit to the number of characters that can be used in a cell, including column headers. If your headers are longer than this limit, they will be truncated when you unpivot your columns.
One solution to prevent the truncation is to shorten the text of your headers before you unpivot. You can do this manually by selecting the cell with the header, clicking on the formula bar, and editing the text to be shorter.
Another option is to use a formula in a separate row to shorten the header text. For example, you could use the LEFT function to extract the first 30 characters of the header, like this:
=LEFT(A1,30)
This formula would extract the first 30 characters from the cell in A1. You could then copy this formula across all the columns with long headers, and then use the shortened headers to unpivot your columns.
Best Regards.