Converting A Number To Text
 

Greetings!

I'm stumped on converting a number to text; that is, how can I get cell
A2 to display "apple" when A1 has "1" entered? Or, if I enter "2" in
A1, I want A2 to display "peach."

Any help would be greatly appreciated!

Thank you,

Tommy


--
tomfernandez1
------------------------------------------------------------------------
tomfernandez1's Profile: http://www.excelforum.com/member.php...o&userid=33518
View this thread: http://www.excelforum.com/showthread...hreadid=533072

Converting A Number To Text
 

set up a table and use a lookup


--
duane


------------------------------------------------------------------------
duane's Profile: http://www.excelforum.com/member.php...o&userid=11624
View this thread: http://www.excelforum.com/showthread...hreadid=533072

Converting A Number To Text
 

For general matching you would set up a table with 1,2,3 in the first
column, and Apple, Peach, Pear in the second column, then use

=VLookup(A1,D1:E99,2,False)

where D1:E999 is the extent of your table.

Alternately, if you are using just numbers in A1 you can simply setup a
list of words and use

=OFFSET(E1,A1-1,0)

either method would supply the words required.

HTH


tomfernandez1 Wrote:
Greetings!

I'm stumped on converting a number to text; that is, how can I get cell
A2 to display "apple" when A1 has "1" entered? Or, if I enter "2" in
A1, I want A2 to display "peach."

Any help would be greatly appreciated!

Thank you,

Tommy


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=533072

Converting A Number To Text
 

Another way if your selections are few.....in A2 put this formula

=LOOKUP(A1,{"a",0,1,2,3,4},{"","","apple","Peach", "pear",""})

Any text in A1 will return blank, and any number 4 or larger will return
blank. Decimals will return in accordance with their integer.

Vaya con Dios,
Chuck, CABGx3




"tomfernandez1"
wrote in message
news:tomfernandez1.26a1my_1145056501.3176@excelfor um-nospam.com...

Greetings!

I'm stumped on converting a number to text; that is, how can I get cell
A2 to display "apple" when A1 has "1" entered? Or, if I enter "2" in
A1, I want A2 to display "peach."

Any help would be greatly appreciated!

Thank you,

Tommy


--
tomfernandez1
------------------------------------------------------------------------
tomfernandez1's Profile:
http://www.excelforum.com/member.php...o&userid=33518
View this thread: http://www.excelforum.com/showthread...hreadid=533072

Converting A Number To Text
 

Read this to learn about vlookup.

http://contextures.com/xlFunctions02.html

vlookups may seem complex at first but do the examples & you'll get the
gist and you'll never look back.


--
John James
------------------------------------------------------------------------
John James's Profile: http://www.excelforum.com/member.php...o&userid=32690
View this thread: http://www.excelforum.com/showthread...hreadid=533072

Converting A Number To Text
 

Check out the Choose() function in help
Its good for up to 29 choices.

enter into your cell A2 = Choose(a1,"apple","peach","banana","watermelon")
<< 4 of possible 29

HTH,
Jim May

"tomfernandez1"
wrote in message
news:tomfernandez1.26a1my_1145056501.3176@excelfor um-nospam.com...

Greetings!

I'm stumped on converting a number to text; that is, how can I get cell
A2 to display "apple" when A1 has "1" entered? Or, if I enter "2" in
A1, I want A2 to display "peach."

Any help would be greatly appreciated!

Thank you,

Tommy


--
tomfernandez1
------------------------------------------------------------------------
tomfernandez1's Profile:
http://www.excelforum.com/member.php...o&userid=33518
View this thread: http://www.excelforum.com/showthread...hreadid=533072