Google Sheets | CHOOSEROWS | MATCH | Functions | Example | Spreadsheet | Tutorial | Extract Row Data
Use the Google Sheets CHOOSEROWS and MATCH functions together to extract specific rows of an array. Substitute MATCH for the row_num1 and row_num2 arguments of CHOOSEROWS, assuming you want to extract two rows that meets the criterion specified in MATCH.
=====================================
Food & Health Series Using 2D Animation
All the Parts of How to Prevent Diabetes series is based on research findings.
How to Prevent Diabetes Part 1
• How to Prevent Diabetes Part 1 | A Si...
How to Prevent Diabetes Part 2
• How to Prevent Diabetes Part 2 | Bitt...
How to Prevent Diabetes Part 3
• How to Prevent Diabetes Part 3 | Simp...
How to Prevent Diabetes Part 4
• How to Prevent Diabetes Part 4 | One ...
How to Prevent Diabetes Part 5
• How to Prevent Diabetes Part 5 | What...
=====================================
-------------------------------------
How to Use CHOOSEROWS in Google Sheets?
Extract one or more rows of data using CHOOSEROWS:
• Google Sheets | CHOOSEROWS | Function...
-------------------------------------
How to Use MATCH in Google Sheets?
Get the position of a specific data in a range using MATCH:
• Google Sheets Match | Match Function ...
-------------------------------------
How to Use TOCOLS in Google Sheets?
Transpose one or more rows of data into columns:
• Google Sheets Match | Match Function ...
-------------------------------------
How to Use TOROWS in Google Sheets?
Transpose one or more rows of data into rows:
• Google Sheets | TOROW | Function | Ex...
-------------------------------------
How to Use TO_PURE_NUMBER in Google Sheets?
Convert a formatted number into a pure number by removing any of its formatting:
• Google Sheets |TO_PURE_NUMBER | Funct...
-------------------------------------
How to Use XLOOKUP for Reverse Search in Google Sheets?
XLOOKUP can search for the search key in the regular or reverse order in the lookup range:
• Google Sheets | XLOOKUP | Function | ...
-------------------------------------
How to Use LAMBDA and BYCOL in Google Sheets?
Create and test your own function using LAMBDA, and then use your function in a function like BYCOL:
• Google Sheets | LAMBDA | BYCOL | Func...
-------------------------------------
How to Use XMATCH in Google Sheets?
XMATCH returns the position of the specified search key in a row or column:
• Google Sheets | XMATCH | Function | E...
-------------------------------------
CHOOSEROWS Function Formula
=CHOOSEROWS(array, [row_num1, …])
Start the formula with an equal-to symbol.
CHOOSEROWS is the name of the function.
array is the range with one or more rows.
row_num1 is the row number of the array from which to extract data.
row_num1, can be, for example, a hard-coded number, cell address, or function that returns a number.
row_num2, row_num3, and others are optional and are row number 2, 3, and others.
For more info on CHOOSEROWS, refer to its tutorial whose links is given
above.
MATCH Function Formula
=MATCH(search_key, range, [search_type])
Start the formula with an equal-to symbol.
search_key is the data you want to search.
range is the area of the spreadsheet that may have the search_key.
search_type specifies the search method. For example, the value of 0 for search_type makes MATCH to conduct an exact search.
For more info on MATCH, refer to its tutorial whose links is given above.
CHOOSEROWS and MATCH Function Formula
Substitute the MATCH function for row_num1 and row_num2 arguments of
CHOOSEROWS, assuming you want to extract two rows from an array.
The row_num1 and row_num2 arguments each are a number and the MATCH function returns a number. So, MATCH can be substituted for these two arguments.
The two functions combo formula is:
=CHOOSEROWS(array, MATCH(search_key, range, [search_type], MATCH(search_key, range, [search_type])
Example
=CHOOSEROWS(A3:D7, MATCH("ny236", C3:C7, 0), MATCH("bo502", C3:C7, 0)
MATCH will search for an exact match of the strings ny236 and bo502 in the range C3 to C7 and, if found, will return their position as a number for each. CHOOSEROWS will then return the data, pertaining to these strings, from the range A3 to D7.
Review this video tutorial, which gives the steps to use the Google Sheets CHOOSEROWS and MATCH functions together with an example.