@majko98 May I suggest one small adjustment to your schedule as it's more difficult to calculate with a text like "1-9" than with numbers. Split what you have in D into two elements. One column for the lower limit and another for the upper limit. Then your formula could be like this:
=IF(AND(B2=C2,A2>=D2,A2<=E2),"Okay","wrong")
Please see attached workbook for an example.
