ok, hang tight!
if function: =if(logic_test,true, false)
So, let us look at the first thing:address.
So then, take that function, click on the cell, and drag it down [notice the address locations changes are relative to the cell that is calling it]. The function always needs to see if qualitying cell has HOL.
It will transfer the blank lines, so if line 12 has HOL, then line 12 on second sheet is filled, it DOES NOT LOOK FOR NEXT ROW on second sheet! What do you want for free? :)