So I am creating a list of names so that I can quickly input room assignments for students to report to on certain days. The idea is that I can type the letter "a" on a day next to a student's name and that "a" appears as a room number on a schedule section of my spreadsheet. I am using 1-9 and a-z as these code letters.
The formula I am using is =LOOKUP(D:D,Y:Y,Z:Z ) . The D column is my input space. The Y and Z columns are my data chart with corresponding room number and the formula cell is the schedule. As an example, the letter "c" refers to Room # C110 on my chart. So when I type a "c" in the D column it drops a "C110" in the formula cell.
This all works flawlessly on my spreadsheet until I try to use letters v, w, x, y, z. The numbers 1-9 work just fine and work as intended. As does a-u. However, even though v-z are on my chart the formula creates a "0" value when I attempt to input those codes.
Help! I don't see why this should not work!
See my video to help give you a better understanding of my issue.
