Formula Help

W

woodcb

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

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

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

[email protected]
Replace @mailinator.com with @tiscali.co.uk
 
Top