/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

4 votes384 views3 answers
How to find employee names starts with in sql
TypeScript
0 vote311 views2 answers
How to check if a string contains only alphabets and space in java
TypeScript
1 vote293 views1 answer
Sonar properties exclude rule
TypeScript
2 votes305 views1 answer
Usedisclosure
TypeScript
1 vote348 views2 answers
Angular timestamp component
TypeScript
0 vote288 views1 answer
Which of the following are elements associated with the html table layout?
TypeScript
0 vote305 views1 answer
Grid layout elements in one row
TypeScript
0 vote302 views1 answer
Pass command line arguments C#
TypeScript
3 votes312 views1 answer
For of loop in ts with index
TypeScript
4 votes313 views2 answers
Magento 2 enable template hints command line
TypeScript