Hi everyone!
I have a huge problem that is really making me crazy.
What I want excel to do is basically look up and create a list for all the values that start with the first 6 numbers of the class code that has to serve as a reference. I highlighted an example of what i would like excel to do for the first line. There are more than 36 thousand lines to go through for each 664 Class code. Many Commodity codes as you may guess will not be picked up by the formulae since they don't match with any of the class codes i selected for my work.
Here is a sample of the file I want to work with:
[/URL][/IMG]
Help me I am desperate, if someone could give me the exact formula instead of just a hint I would worship them forever!
max.
I have a huge problem that is really making me crazy.
What I want excel to do is basically look up and create a list for all the values that start with the first 6 numbers of the class code that has to serve as a reference. I highlighted an example of what i would like excel to do for the first line. There are more than 36 thousand lines to go through for each 664 Class code. Many Commodity codes as you may guess will not be picked up by the formulae since they don't match with any of the class codes i selected for my work.
Here is a sample of the file I want to work with:
Help me I am desperate, if someone could give me the exact formula instead of just a hint I would worship them forever!
max.
Last edited:
