/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 votes110 views1 answer
How to call angular 8 form validation ngif
TypeScript
0 vote120 views1 answer
Accessing widgets in screen manager kivy
TypeScript
3 votes113 views1 answer
Angular access page route
TypeScript
1 vote103 views1 answer
Dispatcher servlet as its web application context
TypeScript
1 vote117 views1 answer
Luxon react ts install
TypeScript
8 votes131 views3 answers
Your account has reached its concurrent builds limit
TypeScript
7 votes113 views3 answers
Typescript ignore
TypeScript
0 vote126 views1 answer
ERROR TypeError: this.element.children.forEach is not a function
TypeScript
0 vote122 views1 answer
Pending = pending$ async type 'boolean null' is not assignable
TypeScript
2 votes113 views1 answer
Typescript get the mime type from base64 string
TypeScript