VLOOKUP / Condition Formatting Help
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 |
VLOOKUP / Condition Formatting Help
can you please give us an example?
Thanks, -- Farhad Hodjat "bluesifi" wrote: 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 |
All times are GMT +1. The time now is 08:11 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com