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.