All posts by jasu

Google Sheets Vlookup array

I was about to go nuts trying to figure out why I couldn’t enter an array for a VLOOKUP in Google Sheets. Quite a bit of Googling later it turns out that there’s BACKSLASH to separate arrays into columns – but only if you’re using a locale which uses a comma as number separator (instead of dot in the US/UK) and semi-colon for separating function values.

Thanks to

VLOOKUP with 2-dimensional array in one cell for Google Sheets

Google Sheets – lookup a date and return the weekday (as text, not as an integer).