Forum Discussion

nilsr's avatar
nilsr
Copper Contributor
Oct 18, 2020

Merge two ranges

Hi!
Im about to make a list that is a summery of two ranges. My two formulas will create ranges that may vary in rows but be the same amount of columns (3). What Im looking for is a way to have a joined formula including both ranges, and when the first is finished, the next one extend the list.
My first formula is complicated but is basically an extended =C6:E8 (Both 6 and 8 will differ)
My second is a filter formula =FILTER(I6:K10;ISNUMBER(MATCH(I6:I10;H14:H19;0))), creating a range with three columns and the same amount of row as values in H14:H19.
Id like to think that a solution like =(C6:E8)(=FILTER(I6:K10;ISNUMBER(MATCH(I6:I10;H14:H19;0)))) would make a list with the outcomes of the two formulas, but it doesn't. Is there a way to merge these two lists using one formulas within one cell?

Thank you very much in advance!

Best wishes.

Nils

No RepliesBe the first to reply

Resources