Google Sheets – How to Fix Array Comma-Delimiter Not Working in Functions

formulasgoogle sheets

I was trying to do a VLOOKUP in a column and print results of a column left to the on to be searched. So I tried put them into an Array to move the search column to the front. But for some reason the comma delimiter doesn't work in Formulas.

What I tried to do:

=VLOOKUP("search-term"; {B:B, A:A}; FALSE)

This results in a formula parse error, also the B:B Range is not colored. This also results in a formula parse error:

{B:B , A:A}

I can workaround by using:

=VLOOKUP("search-term"; TRANSPOSE({TRANSPOSE(B:B); TRANSPOSE(A:A)}); FALSE)

But that gets really chaotic really fast. Is there a reason why the comma delimiter doesn't work?

Best Answer

You can't use , because of your locale. You should use \ instead. 

{B:B\A:A}
Related Topic