Else If

[mallets123]

Is there a function which will check in a specified cell for a number
(should be from 1-10) and return a specific value based what number it
found in that cell?

Ex.
IF(A1=1,"text1")
IF(A1=2,"text2")
IF(A1=3,"text3")
IF(A1=4,"text4")
IF(A1=5,"text5")
IF(A1=6,"text6")
IF(A1=7,"text7")
IF(A1=8,"text8")
etc...

 

[Chip Pearson]

Try

="text"&A1

or

=CHOOSE(A1,"text1","text2","text3")

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"mallets123"
in message
news:[email protected]...

 

[Rajah]

If you're sure it's going to be between 1 and 10, the CHOOSE function
will work for up to 29 values. It will give you a #VALUE error if A1
has a number greater than 10.

=CHOOSE(A1,"text1","text2","text3","text4","text5","text6","text7","text8","text9","text10")

 

[RagDyeR]

You could try this:

=INDEX({"text1","text2","text3","text4","text5"},A1)

--

HTH,

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

in message
Is there a function which will check in a specified cell for a number
(should be from 1-10) and return a specific value based what number it
found in that cell?

Ex.
IF(A1=1,"text1")
IF(A1=2,"text2")
IF(A1=3,"text3")
IF(A1=4,"text4")
IF(A1=5,"text5")
IF(A1=6,"text6")
IF(A1=7,"text7")
IF(A1=8,"text8")
etc...