I'm working on 2 employee schedules, I'm trying to get cells in one schedule
to reference another (person works at both facilities). the problem I'm
having is, I want the cells at the second facility to reference the first and
differentiate between days on, off and at the other facility. making it so I
only have to enter this info once thus eliminating discrepences. I have both
on one sheet. any help would be great.

I think VLOOKUP(or MATCH?) is what you want but it would help if you could
supply a sample of the data and the comparisons to be made.

"waladd" wrote:

I'm working on 2 employee schedules, I'm trying to get cells in one schedule
to reference another (person works at both facilities). the problem I'm
having is, I want the cells at the second facility to reference the first and
differentiate between days on, off and at the other facility. making it so I
only have to enter this info once thus eliminating discrepences. I have both
on one sheet. any help would be great.

ok, if "Charlie" is on at building 1 I want it to read "S" on building 2's
schedule, if he's on at building 2, I enter "PH" on building 1's schedule
and want it to show up as "ON", if he's OFF I want it to reflect that on
building 2' schedule

"Toppers" wrote:

I think VLOOKUP(or MATCH?) is what you want but it would help if you could
supply a sample of the data and the comparisons to be made.

"waladd" wrote:

I'm working on 2 employee schedules, I'm trying to get cells in one schedule
to reference another (person works at both facilities). the problem I'm
having is, I want the cells at the second facility to reference the first and
differentiate between days on, off and at the other facility. making it so I
only have to enter this info once thus eliminating discrepences. I have both
on one sheet. any help would be great.

thanks for help, figured it out, I think:
=IF(E31="ON","S",IF(E31="PH","ON","OFF"))

only showing formula in cell though, hiting the fx button shows result, but
it's not displaying it in the cell

"waladd" wrote:

ok, if "Charlie" is on at building 1 I want it to read "S" on building 2's
schedule, if he's on at building 2, I enter "PH" on building 1's schedule
and want it to show up as "ON", if he's OFF I want it to reflect that on
building 2' schedule

"Toppers" wrote:

I think VLOOKUP(or MATCH?) is what you want but it would help if you could
supply a sample of the data and the comparisons to be made.

"waladd" wrote:

I'm working on 2 employee schedules, I'm trying to get cells in one schedule
to reference another (person works at both facilities). the problem I'm
having is, I want the cells at the second facility to reference the first and
differentiate between days on, off and at the other facility. making it so I
only have to enter this info once thus eliminating discrepences. I have both
on one sheet. any help would be great.