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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Auto Fill Word Documents 4
Delete all data after a symbol in a field 0
Newbie Help - IF Yes No Function 0
SUMPRODUCT formula I think w/ wild card & number vs number as text 8
Copy addition formula of non-consecutive horizontal cells 2
Autonumber field in Excel that behaves the same as Access 0
Display weeks from a Milestone 0
Excel - Wich Function should I use? 1

Top