=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.