"IF" function with multiple truths

[waladd]

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.

[Toppers]

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.

[waladd]

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.

[waladd]

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.