Comparing Fields with Multiple Data Ranges

If i have two fields that i need to compare and in one field i have a word that corresponds with a range (0-79.9="does not meet", 80-100="meets", 100+="exceeds") and in the other field, the user will input a number and the number they input has to correspond with the range associated with the word in the first cell, how do i validate that the number they input corresponds with the range associated with the word in the first cell? For example, they can't have the word "exceeds" with a score of 85 because a score of 85 falls into the "meets" range. They can't have a "meets" with a score of 70 because a score of 70 falls in the "does not meet" range. I am looking for a formula that will compare the two fields and will allow me to display a message if the two fields do not match.

From your post, my assumption like this:
Column A for user input, Column B for validation:

Try this :

Please Login or Register  to view this content.