Converting values to text

  • Thread starter Thread starter Keith Rathband
  • Start date Start date
K

Keith Rathband

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","Aardvark","Guineafowl")

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


Gord Dibben MS Excel MVP
 
Back
Top