Thanks everyone for the help.
I was trying to apply the updates to my excel sheets but I am not able to get them to work. I named my table Lookup_table in Sheet 1 and added the formulas to columns I and H. I also added a field to help me count how many times a rep may go over 5 minutes. I know I am applying something incorrectly I just can't put my finger as to what area I am not applying correctly.
Here is my updated Worksheet
Thanks again
Bookmarks