VLOOKUP / Condition Formatting Help

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi, hoping someone can help. I have a table that links into a database and
shows all severity 2. I have updated the Table to show Service & Severity,
as I wish to report on both Sev 2 & 3.

I have another table on another sheet, which has all the services, and I
want to have a traffic light system if we have a Sev 2 it is Red and if we
have a Sev 3 it is amber.

At the moment I have a vlookup, as I have only been reporting on Sev 2. I
now wish to report on Sev 3. Is it possible to to a vlookup to lookup the
service, and if the service had an outage and was a Sev 2 then show as Red,
if the service had an outage but it was a Sev 3, then show as Amber, in no
outage then Green
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Require formula to search across multiple worksheets 2
Cisco VPN Client - Connection Error Reason 412 5
Spaces being removed from POST data 1
VPN error troubleshooting request 0
Sumproduct Search, Sum Durations 5
can't connet to VPN server even after SP2 1
Sumproduct help 3
toolbox wizard dissapeard 1

Back
Top