Hello everyone
I have another formula that I really do not know where to start with, what I am trying to do is; In column "D" is the staff ID number and then in row "1" from column "O" to "S" is the date.
Sheet one
Column
D_________O______P_____Q_____R______S
ID No........1-10.......2-10.......3-10......4-10......5-10
21
22
23
24
25
Sheet two
is the staff graphic. with an example below.
Column
A...............B...........C..........D..........E..........F
ID ........1-10.....2-10.....3-10.....4-10.....5-10
21...........X..........X..........5..........4.........UP
22...........H..........H..........H..........H.........5
23...........5..........5..........4..........4.........X
24...........X..........X..........2..........2..........2
Now what I need to do is enter a formula in cell "O2" then match the ID number in D2 and the date in cell "O1". then look in the staff graphic in sheet two find the staff members ID number in column "A" and match the date in the first row. But in sheet one I only want to know if some one is rostered to "X", "UP" or "H" if it is not one of those then do nothing.
I would like to thank any one for any suggestions or help in advance and of cause I will be also sending a big thankyou to those that can help me solve this.
Paul
Moscow
I have another formula that I really do not know where to start with, what I am trying to do is; In column "D" is the staff ID number and then in row "1" from column "O" to "S" is the date.
Sheet one
Column
D_________O______P_____Q_____R______S
ID No........1-10.......2-10.......3-10......4-10......5-10
21
22
23
24
25
Sheet two
is the staff graphic. with an example below.
Column
A...............B...........C..........D..........E..........F
ID ........1-10.....2-10.....3-10.....4-10.....5-10
21...........X..........X..........5..........4.........UP
22...........H..........H..........H..........H.........5
23...........5..........5..........4..........4.........X
24...........X..........X..........2..........2..........2
Now what I need to do is enter a formula in cell "O2" then match the ID number in D2 and the date in cell "O1". then look in the staff graphic in sheet two find the staff members ID number in column "A" and match the date in the first row. But in sheet one I only want to know if some one is rostered to "X", "UP" or "H" if it is not one of those then do nothing.
I would like to thank any one for any suggestions or help in advance and of cause I will be also sending a big thankyou to those that can help me solve this.
Paul
Moscow