/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 vote197 views1 answer
How to pass node arguments in nextjs
TypeScript
1 vote141 views1 answer
Pip install from requirements txt
TypeScript
0 vote193 views1 answer
Accessing widgets in screen manager kivy
TypeScript
0 vote222 views1 answer
Discuss climate changes during the Tertiary and Quaternary Periods, and the effects of these changes on geology and vegetation.
TypeScript
0 vote173 views1 answer
Hong Kong Human Rights and Democracy Act opinion
TypeScript
4 votes183 views1 answer
React typescript scss
TypeScript
0 vote188 views1 answer
From list of lists to dataframe
TypeScript
2 votes256 views1 answer
Expected 2 arguments but got 1. viewchild angular
TypeScript
0 vote188 views1 answer
Ignore hosts option in network proxy in ubuntu 16.04
TypeScript
0 vote198 views1 answer
How to take inputs in one line in c
TypeScript