/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

0 vote204 views1 answer
Coding Exercise: Double Time Modify this recursive program to correctly count down in increments of 2.
TypeScript
0 vote203 views1 answer
Typescript find in all words
TypeScript
1 vote189 views1 answer
@angular/fire/angularfire2.d.ts:37:49 - error TS2344: Type 'T[K]' does not satisfy the constraint '(...args: any) => any
TypeScript
13 votes204 views4 answers
Change checkbox jquery alert
TypeScript
8 votes196 views5 answers
Property 'value' does not exist on type 'EventTarget & Element'.
TypeScript
0 vote177 views1 answer
Adding import of app routing module
TypeScript
-1 vote176 views1 answer
Angular conditional directives
TypeScript
1 vote276 views3 answers
Stripe create subscription
TypeScript
30 votes204 views3 answers
Set number of decimals python
TypeScript
3 votes207 views3 answers
C# check list of objects for value
TypeScript