Previous Topic Next Topic

EXCELL

Closed
MIKE - Feb 10, 2010 at 02:30 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Feb 10, 2010 at 02:45 PM
Hello,
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.

can anyone help
Related:

1 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Feb 10, 2010 at 02:45 PM
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
1 name1
2 name2
...

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

=vlookup(a2, 'MasterList'!A2:B15, 2, false)
1