How do I transform numbers (different ranges) to text (diff. range
 

I am trying to make my worksheet convert numbers to text. I want my whole F
column to convert 20 to say MUO-20, 21-50 to say MUO-50, 51-100 to say
MUO-100, 101-200 to say MUO-200, and <200 to say MUO-300. Is this possible?
I appreciate any help.

Thanks in advance.

How do I transform numbers (different ranges) to text (diff. range
 

I think you have a couple of typos in your description.

I assume 20 means =<20 and <200 means 200

Enter this formula in G1 then double-click on the fill handle to copy down to
end of date in F.

=LOOKUP(A1,{0,21,51,101,201},{"muo-20","muo-50","muo-100","muo-200","muo-300"})


Gord Dibben MS Excel MVP


On Tue, 12 Dec 2006 13:49:01 -0800, Ty Eaton <Ty
wrote:

I am trying to make my worksheet convert numbers to text. I want my whole F
column to convert 20 to say MUO-20, 21-50 to say MUO-50, 51-100 to say
MUO-100, 101-200 to say MUO-200, and <200 to say MUO-300. Is this possible?
I appreciate any help.

Thanks in advance.