Hi,
I am having problems with dragging this formula to the right so it changes the correct way.
I am using exel 2016 dutch version.
In cel F26 i have this formula:=ALS($V$15="Werk";Urenregister!R130;ALS($V$15="Verlof";Urenregister!T130;ALS($V$15="EW";Urenregister!U130;"")))
So depending on the Value from $V$ i get the correct value from de sheet"Urenregister"
Now i would like to drag this formula to the right (horizontaly) so it would change like this.
For cell G26= =ALS($V$15="Werk";Urenregister!R131;ALS($V$15="Verlof";Urenregister!T131;ALS($V$15="EW";Urenregister!U131;"")))
For cell H6= =ALS($V$15="Werk";Urenregister!R132;ALS($V$15="Verlof";Urenregister!T132;ALS($V$15="EW";Urenregister!U132;"")))
Is this possible, if yes How pleas
I am having problems with dragging this formula to the right so it changes the correct way.
I am using exel 2016 dutch version.
In cel F26 i have this formula:=ALS($V$15="Werk";Urenregister!R130;ALS($V$15="Verlof";Urenregister!T130;ALS($V$15="EW";Urenregister!U130;"")))
So depending on the Value from $V$ i get the correct value from de sheet"Urenregister"
Now i would like to drag this formula to the right (horizontaly) so it would change like this.
For cell G26= =ALS($V$15="Werk";Urenregister!R131;ALS($V$15="Verlof";Urenregister!T131;ALS($V$15="EW";Urenregister!U131;"")))
For cell H6= =ALS($V$15="Werk";Urenregister!R132;ALS($V$15="Verlof";Urenregister!T132;ALS($V$15="EW";Urenregister!U132;"")))
Is this possible, if yes How pleas