index match problem

[kjabaly]

i have a problem with formula if u please i need help......
in tomrrow column i will write alphabet initials,
in cell AK14,15,16,17,18,19 i need an id nr.that will clean tomorrow and in cell AL14,15,16,17,18,19 room nr.....
ps.leaving old data as it is..
if i write letter K on any cell in highlighted column (and that column change automatically each day)i need the id number and room number (the same row) in cells AK14 AL14....