title: Adding row to a table without messing Arrayformula
body: <p>I am looking for some workaround for my Google Sheets I share with my co-workers.
  I have a data set in Sheet1 (col's A to E), which contains data including empty rows. By using Arrayformula I am pulling data from Sheet1 to Sheet2, only if they meet specific conditions (A=&quot;1&quot; and B=&quot;DFAS&quot;). Then I apply filter to hide empty rows.</p>
  <p>Here comes my problem: next to data pulled by Arrayformula I want to be able to input data (in col's F and G) which correspnds to specific rows from Sheet1, and it has to stay there. The problem is that if I add new rows in Sheet1 the result of Arrayformula shifts but col's F and G in Sheet2 stays as they were, and it all gets messed up.
  Do you have any idea how to work around it?
  I am sharing the google sheets file: <a href="https://docs.google.com/spreadsheets/d/1MvuEDqidLPKfSHATYQ68X9pJFhixTg9TJrq4F3crgUs/edit?usp=sharing" rel="nofollow noreferrer">https://docs.google.com/spreadsheets/d/1MvuEDqidLPKfSHATYQ68X9pJFhixTg9TJrq4F3crgUs/edit?usp=sharing</a></p>