Need to read data from array find a pattern and replace in blank column

[ic3cold]

I am trying to do a formula or macro to do this:

1. I have an array with several patterns say (pat1,pat2,pat3,etc) = cat1
2. I have a column with several patters say the column is like

pat1
pat2
pat3
etc
3. I need to FIND patn in that column and then insert catn based on what it finds.
4. So it will use a REPLACE to enter catn in that column.

----------------------------------------------------------------

To describe in detail what I have is a column with subcategories I need to assign a category in a column that is now blank.
So I find the subcategories patterns that match their corresponding categories.
As the spreadsheet has over 75k rows, it has to browse the subcategories column and replace the blank spaces in the categories column rows with the appropriate category.


<input id="gwProxy" type="hidden"><!--Session data--><input *******="if(typeof(jsCall)=='function'){jsCall();}else{setTimeout('jsCall()',500);}" id="jsProxy" type="hidden">