MATCHCOMPOSITE
Description
A common use case for MATCHCOMPOSITE is to consolidate column data from 2 sheets into
1, where you have data on a sheet, along with notes about that same data in a column
on a different sheet. MATCHCOMPOSITE copies values in one or more columns from the
location to the right of a source array, and returns values to the right of a
destination array. You use a composite key of columns to match copied data to the
correct rows in the destination.
Syntax
MATCHCOMPOSITE(
destination_matrix
,
destination_column_indexes
,
source_matrix
,
source_column_indexes
,
return_column_indexes
, [
ifNA
])
- destination_matrix: The area of data in the destination.
- destination_column_indexes: The position of the columns that make up the composite key in the destination.
- source_matrix: The array of the data in the source. You can specify only a cell range, not a column range.
- source_column_indexes: The position of the columns that make up the composite key in the source.
- return_column_indexes: The position of the columns in the source that you want the formula to return.
- ifNA: The default value to return if the function doesn't find a match. The default is an empty string.
Related Functions
MATCH
GROUPBY