/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

2 votes186 views1 answer
Key value pairs typescript
TypeScript
2 votes196 views1 answer
Vscode custom snippets how to use file name
TypeScript
0 vote197 views1 answer
Brickccolor scripts roblox
TypeScript
0 vote213 views1 answer
How can i take multiple inputs from the user in discord.js
TypeScript
2 votes190 views2 answers
Get last elements of list python
TypeScript
0 vote199 views1 answer
Compare two objects deep
TypeScript
4 votes191 views2 answers
Typescript get type
TypeScript
-1 vote217 views1 answer
Apexcharts dataURI style
TypeScript
1 vote214 views1 answer
Get all documents in collection firestore flutter
TypeScript
0 vote181 views1 answer
Mongodb nest.js
TypeScript