/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 vote172 views1 answer
Set environment variable typescript
TypeScript
0 vote196 views1 answer
How to label points in scatter plot in python
TypeScript
3 votes192 views1 answer
Typescript add global variable to window
TypeScript
0 vote164 views1 answer
Flutter constructor default value
TypeScript
0 vote177 views1 answer
Accessing widgets in screen manager kivy
TypeScript
0 vote165 views1 answer
Supertest typescript
TypeScript
0 vote217 views2 answers
Error: "Filesystem" plugin is not implemented on android
TypeScript
0 vote230 views1 answer
Find unique elements in pandas and their connection with other column
TypeScript
0 vote167 views1 answer
Does key repeats in hashmap
TypeScript
2 votes175 views1 answer
Router navigate pass params
TypeScript