The only issue I am still having is how to incorporate the INT function so that I get whole number without the decimals. I have formatted the cell the formulas below still see the decimal points and it is throwing the data off. I have tried numerous combinations and can't figure out how to incorporate the INT function into:

=LOOKUP(A2,{0,75,100,150,200},{1,2,3,4,5})


As well as:

=IF(C9<75,1,IF(AND(C9<=99,C9>=75),2,IF(AND(C9<=149,C9>=100),3,IF(AND(C9<=199,C9>=150),4,5))))

Thanks again all!