I am trying to build a formula that would return a value in a column based on if an 'if' function is true, but then loops to check the new row down. So for example. =if(A2="1", B2,...then check is A3 = "1" and give me data from cell B3.
Any help would be great....
Mark
Bookmarks