Thread
:
Automatic Data Entry
View Single Post
#
6
Posted to microsoft.public.excel.misc
jmj713
external usenet poster
Posts: 57
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.
Reply With Quote
jmj713
View Public Profile
Find all posts by jmj713