/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 vote116 views1 answer
Typescript get unknown property
TypeScript
1 vote177 views1 answer
Ts disable is declared but its value is never read
TypeScript
0 vote182 views1 answer
Hsbc uk
TypeScript
1 vote163 views1 answer
Cannot find module jquery typescript ionic
TypeScript
6 votes161 views3 answers
Get all documents in collection firestore
TypeScript
3 votes160 views1 answer
Empty observable rxjs
TypeScript
1 vote171 views1 answer
Use of value_counts in python
TypeScript
3 votes180 views3 answers
Cannot find module typescript
TypeScript
0 vote173 views1 answer
Typescript class import csv file
TypeScript
1 vote161 views1 answer
District affected by latur earthquake
TypeScript