i have 14 names i want to assign a number value to, like 1 thru 14 and when i input a number in a colum row the name appears in that cell. say 5=robert or 11=bob and my colum to input the numbers h, so h10 input is 5, robert would show in that cell.
Perhaps most easy route would be to create a sheet where you have this master list of name and numbers
and then you can use vlookup in the main sheet to create relation between what number you type and what shows up
so if you create master list as
then in main sheet if A column represents where you would type in number and B represent where name should show up, you can use some thing like