Zend certified PHP/Magento developer

Using IF formula and filtering columns from a different sheet

I’m using an IF formula in sheet B so if the value equals to 1 in column L of sheet A it returns the value in Column A from sheet A to Column A of sheet B in the same row.

However, I’m using filters in Sheet A so when I filter other columns my existing values in sheet B disappear and looking for Feeback on how I can keep the values in Sheet B even when using a filter in sheet A. Sheet BSheet A