VBA Script for Searching for Text, Returning Other Text

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

Column L
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)