/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 vote356 views1 answer
Common mistakes in testing
TypeScript
11 votes314 views2 answers
How to read a list in c# once its created
TypeScript
7 votes294 views3 answers
If temp table exists drop
TypeScript
38 votes382 views4 answers
Comments inside children section of tag should be placed inside braces
TypeScript
0 vote336 views1 answer
Declaring window object in ts
TypeScript
1 vote307 views1 answer
Ts queryselectorall as htmlelement
TypeScript
0 vote346 views1 answer
How to combine pdf documents C#
TypeScript
0 vote322 views1 answer
How to stop error reporting in TypeScript?
TypeScript
37 votes378 views5 answers
Create react project with typescript
TypeScript
1 vote305 views1 answer
Use map with filter in react components from arrays of data
TypeScript