I have an idea although I do not know how to excute it. I have 8 labels as follows:

Below Basic: 0, Basic: 0, Proficient: 0, Advance: 0
"0-49" "50-79" "80-95" "96-100"

Now I have the following data:

John Smith 50
Jane Doe 81
Person 3 30
Person 4 99

How can I get the data to check to see what category it falls under and add to the appropriate place?