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

Originally Posted by tomfernandez1

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

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" <tomfernandez1.26a1my_1145056501.3176@excelforum-nospam.com>
wrote in message
news:tomfernandez1.26a1my_1145056501.3176@excelforum-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
>

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.

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" <tomfernandez1.26a1my_1145056501.3176@excelforum-nospam.com>
wrote in message
news:tomfernandez1.26a1my_1145056501.3176@excelforum-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
>