Hello I am trying to create a formula for an employee schedule. I have all the employee's listed on the first page, then on the subsequent pages are the different calendar weeks and positions. So I'm trying to create a formula that says If Kim McLane is in any of these cells on the Jan 1-7 tab, then put the appropriate position under her name for that day on the overview tab. This is the formula I wrote, but there is something wrong with it.
=IF(‘Jan 1 – 7’!C4=”Kim McLane”, “WC Pos 1”,IF(‘Jan 1 – 7’!C6=”Kim McLane”, “WC Pos 2”,IF(‘Jan 1 – 7’!C8=”Kim McLane”, “WC Pos 3”)))
I would appreciate whatever help anyone has. Thanks, DEB
=IF(‘Jan 1 – 7’!C4=”Kim McLane”, “WC Pos 1”,IF(‘Jan 1 – 7’!C6=”Kim McLane”, “WC Pos 2”,IF(‘Jan 1 – 7’!C8=”Kim McLane”, “WC Pos 3”)))
I would appreciate whatever help anyone has. Thanks, DEB