Need excel formating help - Have excel automatically populate a column

[mike101338]

I have the unique opportunity to streamline a process within our company. It's unique because our customer is complaining to us for not billing quick enough. The customer is right, we are about 3 months behind

I have an excel workbook. Within the first page of the workbook is a column containing part numbers, approximately 200. The next column is for clasifying the product, 10 seperate product clasifications. I want to enter the part number and have excel automatically populate the clasification column.

I understand how to do simple "yes, no" if statements. Can I program excel to handle this many options? I'm not getting it to work

[Jim Wynne]

Originally Posted by mike101338

I have the unique opportunity to streamline a process within our company. It's unique because our customer is complaining to us for not billing quick enough. The customer is right, we are about 3 months behind

I have an excel workbook. Within the first page of the workbook is a column containing part numbers, approximately 200. The next column is for clasifying the product, 10 seperate product clasifications. I want to enter the part number and have excel automatically populate the clasification column.

I understand how to do simple "yes, no" if statements. Can I program excel to handle this many options? I'm not getting it to work

I don't have any direct help for you, but I do have a source for some. The Microsoft newsgroups are an excellent source for expert peer-to-peer help with MS products. The group you want, (using a newsreader such as Outlook Express or Firefox) is microsoft.public.excel.programming. To access the group through a web-based interface, go here: http://support.microsoft.com/newsgroups/?pr=918 and click on "excel.programming" in the lefthand column.

[Cathie]

I'm not sure if doing an auto filter will help but for me, we have many different "project" numbers and using the auto filter, I'm able to see all of the submissions for each client just by picking the project number. (Data - Autofilter)

Not sure if that would help but could make it a little easier until you find a sure fix.

Cathie

[Steve Prevette]

Originally Posted by mike101338

I have an excel workbook. Within the first page of the workbook is a column containing part numbers, approximately 200. The next column is for clasifying the product, 10 seperate product clasifications. I want to enter the part number and have excel automatically populate the clasification column.

Take a look at the "hlookup" and "vlookup" functions in Excel help. If you still have problems after that, I can set you up a little example.

[Al Rosen]

Originally Posted by mike101338

I have the unique opportunity to streamline a process within our company. It's unique because our customer is complaining to us for not billing quick enough. The customer is right, we are about 3 months behind

I have an excel workbook. Within the first page of the workbook is a column containing part numbers, approximately 200. The next column is for clasifying the product, 10 seperate product clasifications. I want to enter the part number and have excel automatically populate the clasification column.

I understand how to do simple "yes, no" if statements. Can I program excel to handle this many options? I'm not getting it to work

Mike, how does the part no. relate to the classification? Does one particular digit within the p/n identify the class. Can you give us an example?

[mshell]

Paste this into the cell that you want the value to appear in and change the cell references and values as needed.

=IF(A2>89,"A",IF(A2>79,"B", IF(A2>69,"C",IF(A2>59,"D","F"))))

[mike101338]

Originally Posted by mshell

Paste this into the cell that you want the value to appear in and change the cell references and values as needed.

=IF(A2>89,"A",IF(A2>79,"B", IF(A2>69,"C",IF(A2>59,"D","F"))))

mshell, thanks a bunch. That is exactly what I was looking for. My problem was those #@%$ (). I had one wrong and couldnt see it until I looked at your script!!!!!!!!!!!!!

[mshell]

You are welcome. Glad to be of assistance.