MATCHCOMPOSITE
Description
A common use case for MATCHCOMPOSITE is to consolidate column data from different sheets. Example: If there are 2 sheets, where you have data on a sheet, along with notes about that same data in a column on a different sheet, you can use MATCHCOMPOSITE to consolidate the column data from those 2 sheets into 1 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