VLOOKUP Formatting

Support
1

Hi all,

So I have a VLOOKUP function that looks at a data from a subtable. It does perfectly what it needs to do and pulls out the information I need but… it presents the data in a single line separated by commas “,”.

Shows like this: apple,orange,kiwi,banana

I need it like this:
apple
orange
kiwi
banana

So my question is, is there a way to split each data match that it finds in a new line within the same field.

I can do that for example CHAR(10), like I have done previously with UNIQUE(A1,CHAR(10)+" "), but I can’t find a way to add the CHAR(10) in the VLOOKUP.

If I put it in the front of VLOOKUP, just moves all of the matches in a new line but does not separate each in new line.

So if my post makes any sense I’d appreciate help on this. Or if someone have different approach how to do that.

2

Hi,

I think changing the value separator when using the VLOOKUP formula is not supported. If needed, I will check with our developers to see if this could be supported in the future.

3

Hi Fabio,

Thanks for the reply.

After some testing I managed to get what I want with the use of additional field.

So I created another field and used the SUBSTITUTE(A1,“,”,“\n”), linked this to A1 where is my VLOOKUP field.

Now everything that has a comma “,” in the VLOOKUP filed is getting a new line in the another field I created. So I just hide the VLOOKUP field and made the newly created field with the SUBSTITUE as main representative of the information on my listing page.

1 Like
4

Wow, that’s very creative!