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)
Recent comments
5 years 34 weeks ago
6 years 20 weeks ago
6 years 32 weeks ago
6 years 35 weeks ago
6 years 36 weeks ago
6 years 42 weeks ago
6 years 50 weeks ago
6 years 50 weeks ago
6 years 50 weeks ago
6 years 50 weeks ago