nautilus68
New Member
- Joined
- Sep 16, 2008
- Messages
- 4
Hello,
So i have this spreadsheet that references another spreadsheet. It compares two rows in spreadsheet "error" and returns a value in spreadsheet "audit".
I have multiple columns each with a slightly different formula but the main issue is i am trying to autofill in the rest of the rows in "audit" but autofill is not maintaining the relationship of the numbers. Basically i need it to add 2 each time not just add 1.
Example:
Audit!E6: =Error!J9
Audit!E7: =Error!J11
but autofill does not maintain the +2 each time and only adds +1.
i have more complex formulas
Example:
Audit!J5: =IF(Error!H7=Error!H8,"AGREE","Steadfast code: {"&Error!H8&"} "&Error!Q8)
Audit!J6: =IF(Error!H9=Error!H10,"AGREE","Steadfast code: {"&Error!H10&"} "&Error!Q10)
And:
Audit!B5: =IF(A5<>"FALSE",Error!C7)
Audit!B6: =IF(A6<>"FALSE",Error!C9)
Understand what i am trying to do? really need autofill to pick up on the relationship of the numbers but not sure how. Any help would be appreciated.
Thanks!!!!
So i have this spreadsheet that references another spreadsheet. It compares two rows in spreadsheet "error" and returns a value in spreadsheet "audit".
I have multiple columns each with a slightly different formula but the main issue is i am trying to autofill in the rest of the rows in "audit" but autofill is not maintaining the relationship of the numbers. Basically i need it to add 2 each time not just add 1.
Example:
Audit!E6: =Error!J9
Audit!E7: =Error!J11
but autofill does not maintain the +2 each time and only adds +1.
i have more complex formulas
Example:
Audit!J5: =IF(Error!H7=Error!H8,"AGREE","Steadfast code: {"&Error!H8&"} "&Error!Q8)
Audit!J6: =IF(Error!H9=Error!H10,"AGREE","Steadfast code: {"&Error!H10&"} "&Error!Q10)
And:
Audit!B5: =IF(A5<>"FALSE",Error!C7)
Audit!B6: =IF(A6<>"FALSE",Error!C9)
Understand what i am trying to do? really need autofill to pick up on the relationship of the numbers but not sure how. Any help would be appreciated.
Thanks!!!!