I would say you could do this with an if statement,
=if(a1= "Shift 1","2:00",if(a1="Shift 2", "7:00")," ")

I don't have excel with me but I am pretty sure this would work.
RagDyer/All, do you think this is a bit sloppy?

"RagDyer" wrote:

Try this in I1, and copy down as needed:

=LOOKUP(D1,{0,"Shift 1","Shift 2";"","2:00","7:00"})

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"jmj713" wrote in message
...
How about being more specific with your question.

Surely. What I have is either "Shift 1" or "Shift 2" in Column D. I need a
formula that will automatically enter into Column I either "2:00" or
"7:00"
respectively.