Array literals are data sets, made up of rows and columns. They're incredibly useful. You can use them to combine data or formulas, or to set default values for cells in #GoogleSheets. But perhaps the coolest application for them is to return multiple columns with one VLOOKUP!

Array literals are data sets, made up of rows and columns. They're incredibly useful. You can use them to combine data or formulas, or to set default values for cells in #GoogleSheets. But perhaps the coolest application for them is to return multiple columns with one VLOOKUP!

— Ben Collins (@benlcollins) Jun 17, 2022

from Twitter https://twitter.com/benlcollins

June 18, 2022 at 12:04AM