Trying to help out with a form, cant seem to figure out how to combine multiple long text cells. Using if errors out stating that it cant handle more than 255 characters. Currently copying to another cell with multiple if's then concatenating to another cell, but this seems cumbersome. Tried to figure out vlookup but I cannot make it work. Any suggestions?
A simplified picture looks like this:
info selection
1 text1 x
2 text2
3 text3 x
4 text4 x
5
6 text1
text3
text4
7
Bookmarks