Attendance tracking

My Requirements are as follows

1) Holiday List sheet as list of holidays as per locations - Need a macro to update in Tracker Sheet as H to lookup from Holiday Sheet
( Module 2 as VBA code written which needs to be altered)

2) If i update in cell G10 as 1 it should give a result as AL , M10 as 2 it should give result as CL ... etc as per above table
Give a VBA code script where if i enter 1 it should auto update as AL or CL