I have a load of values which i want to convert to text, the text will
depend on the value. ie

If value=1, text = DOG
If value=2, text = CAT
If value=4, text = PIG

Thanks.

I think what you'll need is the VLOOKUP function

http://www.mvps.org/dmcritchie/excel/vlookup.htm
--
HTH,
Barb Reinhardt

If this post was helpful to you, please click YES below.



"Keith Rathband" wrote:

I have a load of values which i want to convert to text, the text will
depend on the value. ie

If value=1, text = DOG
If value=2, text = CAT
If value=4, text = PIG

Thanks.

Vlookup is probably the best but consider this as well for up to 29 options

=CHOOSE(A1,"Cat","Dog","Pig","Giraffe","Wombat","A ardvark","Guineafowl")

Mike

"Keith Rathband" wrote:

I have a load of values which i want to convert to text, the text will
depend on the value. ie

If value=1, text = DOG
If value=2, text = CAT
If value=4, text = PIG

Thanks.

=LOOKUP(A1,{1,2,3,4,5},{"Dog","Cat","Rat","Pig","D ugong"})


Gord Dibben MS Excel MVP

On Sat, 4 Oct 2008 20:26:42 +0100, "Keith Rathband"
wrote:

I have a load of values which i want to convert to text, the text will
depend on the value. ie

If value=1, text = DOG
If value=2, text = CAT
If value=4, text = PIG

Thanks.