formatting columns

  • Thread starter Thread starter Sue
  • Start date Start date
S

Sue

I need, as an example, to have Column B auto complete
based on info in Column A. In other words...

I will be entering numbers in column A, I need column B to
respond to the numbers...

If I type in 1 in column A, then "Dogs" should appear in
column B. If I type in 2 in Column A, then "Cats" should
automatically appear in Column B... and so forth.

I am doing this in preparation of creating a database in
Access, but using an export from the antiquated database
done in Clarion until I have time to create the Access
data base, and convince my boss the Access is the way to
go.
 
Hi Sue
For the sample you just mentioned, use:

=IF(A1=1,"dogs","Cats")

I get the feeling though, that it isn't just cats and dogs.
If there are more of the critters, you will have to expand
like so:

=IF(A1=1,"dogs",IF(A1=2,"Cats",IF(A1=3,"Fish","snails")))

You can use 7 nested IF's.

Regards
Michael
 
You could try this for numbers 1 to 4:

=CHOOSE(A1,"cat","dog","rat", "bat")

This can work for up to 29 different choices.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

I need, as an example, to have Column B auto complete
based on info in Column A. In other words...

I will be entering numbers in column A, I need column B to
respond to the numbers...

If I type in 1 in column A, then "Dogs" should appear in
column B. If I type in 2 in Column A, then "Cats" should
automatically appear in Column B... and so forth.

I am doing this in preparation of creating a database in
Access, but using an export from the antiquated database
done in Clarion until I have time to create the Access
data base, and convince my boss the Access is the way to
go.
 
Hey RagDyer
Isn't it amazing, just when I thought I was making
progress in Excel......somebody shows me how much I
haven't. I can see a heap of uses for CHOOSE
Regards
Michael
 
Back
Top