VBA formula with multiple variables to pull data from spread sheet.

[topnotchthrillr]

I have a large data base at work (about 28,000 rows) and I am trying to assign categories to some of the data that match a particular criteria. I wrote a simple VBA code to do this. Here is example of the code.

Please Login or Register  to view this content.

My problem is the code is returning data that is not included in my code. I don't know what I am doing wrong.

Attached is a copy of code and workbook.

Thanks for you help.

[Crooza]

WHat is it doing wrong? I looked at it briefly and it looks like it's populating the columns BK, BL and BM with the proper info as per your macro.

[topnotchthrillr]

I want to pull data with text "A708" in column C, but if you look at the results it is pulling data that matches "A162", "A703" and so on.

[Crooza]

Yep that's because your code has an OR in it that searches column A for "A00070" and if you look at where its activating the macro for your A162 and A703 in column C you'll see that there is an A00070 in column A in these instances

[topnotchthrillr]

Ok, I get it so what I am trying to get the code to do is

Add a category if column 3 is = "A708" and column 13 is "02t1061000" and if column 1 = "A00070" or "A00080" or "A5550100." All three criteria has to be present. How do I write that?

[Crooza]

try this

Please Login or Register  to view this content.

[topnotchthrillr]

Perfect!!!!!!!!!

Thank you!!!!!!!!!!

[Crooza]

no problem. you should mark as solved if there's no further issues