VLOOKUP

[jalenben1]

I have a column that have the following items below that is typed in the column based off the ticket in our ticketing database:
Critical
Critical (Not Measured)
Major
Major (Not Measured)
Minor
N/A

This is the matrix that is used:
Category Response Time Restoral Time Status
Critical 15 mins 4 hours A
Critical(Not Measured) 15 mins 4 hours C
Major 15 mins 8 hours B
Major (Not Measured) 15 mins 8 hours D
Minor 35 mins 12 hours E
Minor 35 mins 18 hours F

I need to have a VLOOKUP based on the info above. So if a category is CRITICAL or A and the MTTR (response time) is at or below 15 mins and the MTTR (restoral time) is at or below 4 hours the KPI should be MET or MISSED. I need to have a VLOOKUP to reflect that.

 

[SkipVought]

Hi,

The responses to your former thread on this general topic did not suffice?

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[jalenben1]

Could you show me the former thread?

 

[SkipVought]

copious amounts of time were expended...

thread68-1599385
thread68-1602031
thread68-1606731


Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[jalenben1]

Skip:

This is my VLOOKUP formula:

=IF($W2<=VLOOKUP($AB2,'V-LookUp'!$A$1:$B6,2,FALSE),"Met","Missed")

It seems to be working with the criteria in my last message. One thing...If I type in N/A as a category I need to see either N/A or Not Reportable as the result. The formula above works for the Critical, Critical (Not Measured), Major, Major (Not Measured) and Minor when they are typed in but not for N/A. Any Suggestions

 

[SkipVought]

Are you referning to "N/A" which is merely a text value or #N/A! which is an ERROR value?

When you say, " I need to see either N/A or Not Reportable as the result," what determines whether it returns N/A to Not Reportable? In other words, what is your LOGIC?

Please answer both questions.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[jalenben1]

I simply took out the N/A in my vlookup and when I type in N/A in the column it gives me #N/A as a result for which I can deal with unless you know of a way I can fix the vlookup to give me N/A or Not Applicable when I type in N/A in the column

 

[SkipVought]

Check out the NA() function.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[jalenben1]

Where is the NA()function?

 

[SkipVought]

In Excel!

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}