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.