I believe this will work for you:
=LOOKUP(A1,{"Regular Hours","Funeral Leave"},{8,0})

Of course, that's just a small sample. You have to add in the rest by
yourself.

HTH,
Ryan---


--

Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Rocktaxi" wrote:

Hello all. I have a formula that I trying to write to go along with an
employee timesheet that is using Excel to track.

In Column A I have the days of the week listed

In Column B, I have a drop down list of possible values. I have them
labeled as the PayCodes. "Regular Hours", "Vacation", "Suspension",
"FMLA Unpaid", "Military Leave", Unpaid Personal Leave" ... and a few
others.

In Column C, I want to return a value of either "8" or "0" for paid or
unpaid time earned for the day based on the code in column B.

So basically, it's a simple, "If column B = Regular Hours, show a
value of 8 but if column B = Funeral Leave, show a value of 0.

I have a total of 13 different "Pay types" that I have listed in two
different ranges and I've tried naming those ranges and referencing
each, i.e, IF(B1="Unpaid time off categories",8,0) but the simplest of
formula's does not seem to work. I've even tried super complex
formulas that are a mile long listing out each individual pay category
and they don't work either.

Of course, if I just do {IF (B1="Vacation",8,0)} Then that will return
my value of 8 but then if I change the drop down to any of the other
12 categories, I still get 8 returned so that formula is not correct
either.

Any thoughts from anyone?
.