/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

1 vote325 views1 answer
Geting request header in loopback4
TypeScript
0 vote339 views4 answers
How to implement read more and readless in angular
TypeScript
0 vote305 views1 answer
Mixpanel react native typescript
TypeScript
0 vote359 views1 answer
Java write arraylist of objects to file
TypeScript
0 vote327 views1 answer
Benefits of waxing body hair
TypeScript
1 vote356 views1 answer
DbQueryEventNode
TypeScript
11 votes344 views4 answers
Max value array of object javascript
TypeScript
-2 votes359 views1 answer
The operation couldn’t be completed. Unable to locate a Java Runtime that supports apt. Please visit http://www.java.com for information on installing Java.
TypeScript
7 votes384 views3 answers
Class 'kotlin.Unit' was compiled with an incompatible version of Kotlin. The binary version of its metadata is 1.5.1, expected version is 1.1.15.
TypeScript
11 votes329 views2 answers
React tsx component example
TypeScript