Could you give some more realistic information about your problem, we can try to give best?
With the data you've given we can simply writes the code using select case statement.
With the data you've given we can simply writes the code using select case statement.

