index match problem

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....

Thank you .... its not two kitchen ,its two guys to clean it.....

It works! - Thank you so much!