/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 vote301 views1 answer
Automation over manual testing
TypeScript
0 vote302 views1 answer
Error TS2564: Property
TypeScript
0 vote345 views1 answer
How to git pull all projects in a folder
TypeScript
1 vote312 views1 answer
Promise.all does not wait
TypeScript
11 votes336 views4 answers
Max value array of object javascript
TypeScript
0 vote307 views1 answer
Not able to use fonts awesome in react
TypeScript
0 vote339 views1 answer
How to send attachments to api
TypeScript
0 vote334 views1 answer
How to combine types in typescript
TypeScript
0 vote634 views1 answer
Mongo change all documents on field
TypeScript
7 votes369 views1 answer
Typerscript online compiler
TypeScript