CODEWITHSUNDEEP
google-sheetsconditional-statementsgoogle-sheets-formulaarray-formulas
Sam Toufaili
Sam Toufaili

Reputation: 15

Google Sheets: How to restart Arrayformula execution in two separate tabs

I have 2 columns, in 2 separate tabs that I would like to combine in 1 column, in Tab #3. However, To combine them, I have a number of conditions that should be met in order to choose which values in tab#1 or tab#2 to transfer to tab#3

The issue I am facing is, when the conditional formula goes through all the rows in Tab#1 (using Arrayformula), Arrayformula starts executing on the row number from where it stopped at in Tab#1. I want Arrayformula to start executing, in tab#2 starting from row 1

Do you have an idea of how I can restart the Arrayformula row position (when in Tab#2)?

EDIT: here is the formula I am using In Tab 3, I added this formula:

=arrayformula(ifs('Tab 1'!A2:A<>"",Tab1'!B2:B, 'Tab 2'!A2:A<>"",'Tab 2'!A2:A))

Thanks!

Upvotes: 0

Views: 74

Answers (1)

Mart&#237;n
Mart&#237;n

Reputation: 10187

If you want to repeat the same process through the columns in both tabs you can use curly brackets. That would repeat the same process over the two tabs, but it's not that clear which is your desired result:

=ARRAYFORMULA(IF({Tab1!A2:A;Tab2!A2:A}<
"",{Tab1!B2:B;Tab2!B2:B},""))

Upvotes: 0

Related Questions