View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
jmj713 jmj713 is offline
external usenet poster
 
Posts: 57
Default Automatic Data Entry

Try this in I1, and copy down as needed:

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


That works perfectly! Thanks so much.