Nel post
*Busy Bee* ha scritto:

I have a list of over 300 accounts #.

100000 Cash
100100 Petty Cash
200100 A/R
etc...

Each range represents a different category. The ranges are
100000-199999 is an A, 200000-29999 is a B. 300000 - 319999 is a C,
320000-399999 is D etc... I need to identify each row as being an A,
B, C etc... so I can sort and add/subtract depending on its
identifyer.

I know I can combine several "if" statement but is there an easier
way? I do not know VBA so would rather avoid it.

Thx!


I think you colud use VLOOKUP function. See on line help and then if you
should have any problem, post again here.

--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy