EXCELL [Closed]

Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
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

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
767
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
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!