Hi I have tried but this is friving me crazy. I am trying to keep track of
the shifts i work and the pay per shift. Each shift has a different rate. In
the colums i have date, shift, pay, hours and gross pay. The first doesnt
need a formula and the last 2 i have worked out. The problem is making it so
that everytime I have eg a Morning shift, not having to type in morning. I
was hoping to just type in a number and excel looked up what that number and
replaced it with whichever shift it corresponded to. The second possibly more
complicated one is a formula that could look at what was typed in column
named "shift" and in the same row in the colum "pay" put the pay rate eg
Morning = 25.5119 Afternoon = 28.7009 If that isnt able to be done i can just
use the first formula changed around a bit. Hope someone can help me!!!