Pulling a value from a ValueList based on another field.
I have a field called Grade and a field called Grain, I also have a value list called Commodities. The value list resembles the following:
102 WHEAT HVY
202 OATS HVY
What I would like to have is a calculation field that refers to the Grade. Based on the grade it will search the value list for the corresponding value so if the Grade is 100 then I would like Grain to be "100 WHEAT"