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).

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.