Classification to a specific Range

[slacknoise]

Hi,

I have a list of Companies indicated by a specific Number in this case "SIC Code" (column B). Given are different industries in this case (Consumer, Manufactoring, Others) with specific ranges in column A. In column C I would like to indicate the respective Industry classification according to each SIC code. Attached is a simplified version.

I hope somebody can help me with that. Thanks in advance.

Paul

[ChemistB]

Hi Paul,
it requires a little reorganization. First you need to make a table with the lowest value for each grouping in 1 column with the industry in the next (Col E and F). Second, change your SEC numbers to numbers not text. You can format cells>Custom > 0000 to keep the preceeding zeros.

Then in C2

=VLOOKUP(B2,$E$2:$F$22,2) dragged down.
Will that work for you? See attachment

[slacknoise]

Hi,
Thank you for the quick response. Your result looks good. The only problem is that the reorganization will be quite time consuming as i am facing 12 industry ranges with more than 15 subranges.Well, if there is no other way than using the vlookup with true, I will have to deal with it then. Thank you very much i will try it out and let you know if it works.
regards,
Paul

[slacknoise]

ok so i have reorganized everything and it should actually work. However there seems to be a small formating problem. If you could help me, that would be great. I cant find the mistake

[slacknoise]

ok problem solved, somehow it blocked me from formating it into numbers

[ChemistB]

Glad you got it working. Good luck.

[slacknoise]

thank you very much