S
SaintJ
Dear all. I have written a conditional to formula which copies a work sheet
(cell by cell) based on which work sheet is currently selected in a drop down
menu in another work sheet (plan). Either data from work sheet st1, st2 or
st3 is copied into the cell.
=IF(LOOKUP(TODAY(),plan!$B$2:$G$2,plan!$B$3:$G$3)="st1",st1!A1:C10,IF(LOOKUP(TODAY(),plan!$B$2:$G$2,plan!$B$3:$G$3)="st2",st2!A1:C10,IF(LOOKUP(TODAY(),plan!$B$2:$G$2,plan!$B$3:$G$3)="st3",st3!A1:C10,"")))
This code works, however you may notice that the cell reference to copy to
the single cell is a range of 9 cells if the conditional function 'IF' is
satisfied. I am a bit confused since it is some time since i wrote this code
and did not notice. Now when I try to change the [value if true] from any of
the IF functions to a single cell instead of a rang eof nine cells it does
not work....
Does anyone have an idea what I may have done??
(cell by cell) based on which work sheet is currently selected in a drop down
menu in another work sheet (plan). Either data from work sheet st1, st2 or
st3 is copied into the cell.
=IF(LOOKUP(TODAY(),plan!$B$2:$G$2,plan!$B$3:$G$3)="st1",st1!A1:C10,IF(LOOKUP(TODAY(),plan!$B$2:$G$2,plan!$B$3:$G$3)="st2",st2!A1:C10,IF(LOOKUP(TODAY(),plan!$B$2:$G$2,plan!$B$3:$G$3)="st3",st3!A1:C10,"")))
This code works, however you may notice that the cell reference to copy to
the single cell is a range of 9 cells if the conditional function 'IF' is
satisfied. I am a bit confused since it is some time since i wrote this code
and did not notice. Now when I try to change the [value if true] from any of
the IF functions to a single cell instead of a rang eof nine cells it does
not work....
Does anyone have an idea what I may have done??