Help with an If/And/Else Formula (I Think)

[Dnoslo]

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.

Page 1

Page 2

=IF(‘Jan 1 – 7’!C4=”Kim McLane”, “WC Pos 1”,IF(‘Jan 1 – 7’!C4=””, IF(‘Jan 1 – 7’!C6=”Kim McLane”, “WC Pos 2”,IF(‘Jan 1 – 7’!C6=””, (‘Jan 1 – 7’!C8=”Kim McLane”, “WC Pos 3”,IF(‘Jan 1 – 7’!C8=””,)))

 

[FDibbins]

1st, I think you left out an IF...
=IF(‘Jan 1 – 7’!C4=”Kim McLane”, “WC Pos 1”,IF(‘Jan 1 – 7’!C4=””
, IF(‘Jan 1 – 7’!C6=”Kim McLane”, “WC Pos 2”,IF(‘Jan 1 – 7’!C6=””
,IF (‘Jan 1 – 7’!C8=”Kim McLane”, “WC Pos 3”,IF(‘Jan 1 – 7’!C8=””,)))

2nd, you could probably do this with a MATCH, something like ...
="WC Pos "&match(”Kim McLane”,‘Jan 1 – 7’!C4:C8,0)

 

[Dnoslo]

Hi FDibbins,

You might be right. I'll give it a try in the morning.

Thank you