# Time formula

=IF(D2<>"",IF(ISNA(MATCH(A2,\$J\$2:\$J\$5,0)),"",LOOKUP(1-(VLOOKUP(A2,\$J\$2:\$K\$5,2)-D2)/D2,{0,0.5,0.75,1},{"< 50%","< 75%","< 100%","Fail"})),"")

In the attached sheet I have times reassigned and closed plus a table of times we have to resolve. Anything over those times fails, anything within those times I need % within those time to resolve. To make it easy for me to read, I wanted anything within 50% of the time to read < 50% any thing before 75% and after 50% to read < 75% and anything before 100% to read < 100%. I hope this was not to confusing. Thanks in advance for the help.
sample-sheet.xlsx
LVL 19
###### Who is Participating?

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Commented:
Try this formula in E2 copied down

=IFERROR(LOOKUP(D2/VLOOKUP(A2,\$J\$2:\$K\$5,2,0),{0,0.5,0.75,1;"< 50%","< 75%","< 100%","Fail"}),"")

see attached

regards, barry
sample-barry.xlsx
0

Experts Exchange Solution brought to you by