/TypeScript/Google sheets return multiple columns with vlookup

Google sheets return multiple columns with vlookup

# Basic syntax:
=ARRAYFORMULA(VLOOKUP(search_key, search_range, {columns,#s,to,return}, is_search_range_sorted))

# Example usage:
=ARRAYFORMULA(VLOOKUP($A$14, $A$1:$G$9, {2,3,6,7}, FALSE))
# This formula returns entries from columns 2, 3, 6, and 7 when the 
# entry in cell A14 is found in the range from A1 to G7.

Source: benlcollins.com

Similar codes

4 votes373 views10 answers
Array
TypeScript
1 vote306 views1 answer
Serenity.is LinkingSetRelation add column-picker-button
TypeScript
0 vote301 views1 answer
How to validate email address in typescript
TypeScript
0 vote356 views1 answer
Inteface method extension angular
TypeScript
-1 vote344 views3 answers
Merge two arrays of objects lodash
TypeScript
1 vote309 views1 answer
Sqlite.create "capacitor" cannot read property 'then' of undefined
TypeScript
0 vote293 views2 answers
Typescript one of the array items
TypeScript
0 vote305 views1 answer
Android fundamentals 02.3: Implicit intents open website won't work
TypeScript
0 vote283 views1 answer
Pointer vers dépots distants git hub
TypeScript
1 vote339 views1 answer
Serenity.-is add column picker button
TypeScript