Formula Help

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

woodcb - 06 Feb 2008 19:19 GMT

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.

Reply to this Message

Gary''s Student - 06 Feb 2008 19:53 GMT

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.

Signature

Gary''s Student - gsnu200767

> 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.

Reply to this Message

Sandy Mann - 06 Feb 2008 21:27 GMT

Do you want:

This return in only one cell or any cell in a range of cells?

Different returns for different numbers enterd?

Signature

HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

sandymann2@mailinator.com
Replace @mailinator.com with @tiscali.co.uk

>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.

Reply to this Message