Programming worksheet

D

Dave

I have set up a Rota for various staff within Excel there
is a worksheet for each department. I also have a
Holiday Sheet set up so if you enter H in any cell on the
Rota it will automatically transfer to Holiday sheet. I
have done this using the IF function.

I now want to extend this to Using S for Sickness M for
maternity etc but if i try using multiple entries of IF
function i just keep getting error.


Any Suggestions?
 
P

Paul Black

Hi Dave,

Without Seeing the Formulas try this.
We will Assume that there is a Sheet Named "Department1".
We will Assume that the H,M,S, etc is Input in Cell "B1" of the Sheet
Named "Department1".
Set up a VLOOKUP Table with H,M,S etc ( Sorted Alphabetically ) on a
Sheet Named "LOOKUP" in Cells A1:A50.

Use the Following Formula in the "Holiday Sheet" :-
=if(Department1!$B1>" ",VLOOKUP(Department1!$B1,LOOKUP!$A$1:$A$50,1),"
")

Change the References Accordingly.
Hope This Helps
Paul
 
P

Paul Black

Hi Dave,

Without Seeing the Formulas try this.
We will Assume that there is a Sheet Named "Department1".
We will Assume that the H,M,S, etc is Input in Cell "B1" of the Sheet
Named "Department1".
Set up a VLOOKUP Table with H,M,S etc ( Sorted Alphabetically ) on a
Sheet Named "LOOKUP" in Cells A1:A50.

Use the Following Formula in the "Holiday Sheet" :-
=if(Department1!$B1>" ",VLOOKUP(Department1!$B1,LOOKUP!$A$1:$A$50,1),"
")

Change the References Accordingly.
Hope This Helps
Paul
 
D

David Jellis

The Formula that works is

=IF('Late Shift'!B7="H","H","")

the formula that doest work is

=IF('Late Shift'!B7="H","H",""),IF('Lateshift'!B&="S","S","")

i have also tried

=IF('Late Shift'!B7="H","H",""),('Lateshift'!B&="S","S","")

and
=IF(('Late Shift'!B7="H","H",""),('Lateshift'!B&="S","S",""))

and other variations on the same theme



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
 
Top