search and replace number

[starchaser_one]

Hi everyone,

A friend of mine asked me if it's possible to make a timetable.
I started with a basic table, where you can fill in the hours per day, per employee with a validation list.
Easy but it works.
However he asked me something else :

Is it possible to don't use a validation list, but use numbers/codes which stands for a certain time period?
for example : every time he fills in "1" it stands for 08:00-17:00 ; "2" is 08:00-15:30,....
After a macro has run, the numbers and codes will change into the right hours.

I hope the attachments makes it clear. I've used both methods

Should I work with VLookup?

Thanks for your advice
Star