"IF" function with multiple truths

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding up total hours worked on employee schedule using various criteria 0
OLAP Pivot Function 1
Excel VBA For excel 0
Dynamic CONCATENATE and LOOKUP 1
Doing multiple borders 1
VLOOKUP and MID Function 9
Pivot Table Countdown 2
ComboBox on a UserForm 2

Back
Top