Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code for IF
Hello All,
I have a range of cells (A1:A3000) with codes for items in a warehouse, there are about 3000 items, there are also 10 cathegories. I want to, in range B1:B3000 write the name of the cathegory that the item belong; the items' codes are totaly different one from the other, example: A B ACTU VALVES EFTG CONDUIT COND CONDUIT IFTG TUBING XMTR TRANSMITTER I have done this using a lot nested IF on cells B:B3000. Is there a way to write a code to do this faster? Thanks in Advance, -- Cesar |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
split post code (zip code) out of cell that includes full address | Excel Discussion (Misc queries) | |||
How can I modify my code to offset the defined range and repeat theprocedure instead of duplicating my code? | Excel Programming | |||
Run VBA code only worksheet change, but don't trigger worksheet_change event based on what the code does | Excel Programming | |||
Protect Sheet with code, but then code will not Paste error. How do i get around this. Please read for explainations.... | Excel Programming | |||
Excel code convert to Access code - Concat & eliminate duplicates | Excel Programming |