VLOOKUP

[jalenben1]

In Excel I have a spreadsheet where I wrote a VLOOKUP statement as follows:

=IF($X2<=VLOOKUP($H2,Sheet1!$1:$D9,2,FALSE),"Met","Missed")

to which it tells me if a MTTR is Met or Missed. I have the following criteria

Critical 4:00
Major 8:00
Minor 12:00
Minor 13:00
Minor 14:00
Minor 15:00
Minor 16:00
Minor 17:00
Minor 18:00

Critical = 4 hours
Major = 8 hours
Minor 12 - 18 hours

If I have a MTTR as 14:40 and the ticket is MINOR how would I do my formula to show if a ticket is Met or Missed. I have a lot of tickets that have hours between 12-18 hours but it is only giving me whether a ticket is Met or Missed from 12 hours. How can I redo my VLOOKUP to show my that if MTTR is between 12 - 18 that it will say the MTTR is Met and any tickets afyer 18 Hours then it is Missed

 

[SkipVought]

Hi,

Here's your table
[tt]
Stat Dur
Critical 0:00
Major 4:00
Minor 8:00
[tt]
Your formula
[tt]
=INDEX(Stat,MATCH(D3,Dur,1),1)
[/tt]
where D3 contains your Duration criteria

Skip,

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