Script: excel search for text in one column that categorizes that text in another column

[Swanladye]

Hi! I am new to VBA scripting and. I am trying to have excel search for text in one column and categorize that text with a text value in another column. For example, I have column L with the list below

Logical Disk Free Space is low
Center: VC Application Error
Megabytes of Memory is too low
Megabytes of Memory is too low
Available Megabytes of Memory is too low
Logical Disk Free Space is low
Available Megabytes of Memory is too low
Logical Disk Free Space is low
Metric CPU Usage = 91%
WMI is unhealthy

I want to have a script that will search for different text values in column L and return a value in column R.

Column L Column R
Logical Disk Free Space is low = Logical Disk
Center: VC Application Error =
Megabytes of Memory is too low = Memory
Metric CPU Usage = 95% = CPU
Megabytes of Memory is too low = Memory
Available Megabytes of Memory is too low = Memory
Logical Disk Free Space is low = Logical Disk
Available Megabytes of Memory is too low = Memory
Logical Disk Free Space is low = Logical Disk
Metric CPU Usage = 91% = CPU
WMI is unhealthy =

I have played around with the following, but no luck yet:
=LOOKUP(L2, {"CPU","Disk","Memory"}, {"cpu","disk","memory"})
=VLOOKUP(L2, {"CPU","CPU";"Memory","memory";"Logical Disk","disk"},2,0)

 

[Swanladye]

Better explanation below. Hi! I am new to VBA scripting and. I am trying to have excel search for text in one column and categorize that text with a text value in another column. For example, I have column L with the list below

Logical Disk Free Space is low
Center: VC Application Error
Megabytes of Memory is too low
Megabytes of Memory is too low
Available Megabytes of Memory is too low
Logical Disk Free Space is low
Available Megabytes of Memory is too low
Logical Disk Free Space is low
Metric CPU Usage = 91%
WMI is unhealthy

I want to have a script that will search for different text values in column L ("Logical Disk", "Memory" "CPU") and return a value in column R.

Column L list ...................................................................Column R
Logical Disk Free Space is low.............................................Logical Disk
Center: VC Application Error...............................................
Megabytes of Memory is too low..........................................Memory
Metric CPU Usage = 95 ......................................................CPU
Megabytes of Memory is too low..........................................Memory
Available Megabytes of Memory is too low.............................Memory
Logical Disk Free Space is...................................................Logical Disk
Available Megabytes of Memory is too low.............................Memory
Logical Disk Free Space is low.............................................Logical Disk
Metric CPU Usage = 91%....................................................CPU
WMI is unhealthy...............................................................

I have played around with the following, but no luck yet:
=LOOKUP(L2, {"CPU","Disk","Memory"}, {"cpu","disk","memory"})
=VLOOKUP(L2, {"CPU","CPU";"Memory","memory";"Logical Disk","disk"},2,0)