W woodcb Feb 6, 2008 #1 I am really computer (dumb)! I want to create a formula so when I type in the #1 John Smith will be entered into that cell.
I am really computer (dumb)! I want to create a formula so when I type in the #1 John Smith will be entered into that cell.
G Gary''s Student Feb 6, 2008 #2 Let's say we want to enter a name based upon a number. Consider using two cells. A1 will have the number and in B1: =CHOOSE(A1,"John Smith","Mary Wilson", "Nigel Winslow") If you have lots of names, then usea VLOOKUP() table.
Let's say we want to enter a name based upon a number. Consider using two cells. A1 will have the number and in B1: =CHOOSE(A1,"John Smith","Mary Wilson", "Nigel Winslow") If you have lots of names, then usea VLOOKUP() table.
S Sandy Mann Feb 6, 2008 #3 Do you want: This return in only one cell or any cell in a range of cells? Different returns for different numbers enterd? -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings (e-mail address removed) Replace @mailinator.com with @tiscali.co.uk
Do you want: This return in only one cell or any cell in a range of cells? Different returns for different numbers enterd? -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings (e-mail address removed) Replace @mailinator.com with @tiscali.co.uk
