/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

12 votes166 views3 answers
Remove dots from li
TypeScript
0 vote159 views1 answer
How to Convert MATLAB Scripts to Python
TypeScript
0 vote160 views1 answer
Do feral cats have rabies?
TypeScript
1 vote161 views2 answers
Typescript list concat
TypeScript
0 vote180 views1 answer
Create and use constants in angularjs
TypeScript
2 votes122 views2 answers
Typescript array insert at index
TypeScript
2 votes186 views1 answer
Mark occurances of elements in array cpp
TypeScript
7 votes161 views3 answers
How to make a rounded button
TypeScript
6 votes160 views1 answer
Timeout typescript
TypeScript
0 vote126 views0 answer
TypeScript