I know the title may be confusing, but I'm not sure how to word it better.
I have a column from which my users will select an value in a look up table. Based on what they have selected, I want a work flow to run to set a second column's value to another field from the same look up index.
Column1 | Column2 Arnold | 22 Jerry | 24 Sam | 45
In my list, if my user selects "Arnold", I want a workflow to assign the number "22" to another field in my list. This is done twice so I can then compare the two "number" values (essentially determining if Arnold is younger than Jerry.. if so, Arnold is then assigned in another field as an owner). Is there a simplistic way to do this? I think I will be okay on the comparison, but properly reading from the look up table is what's confusing me right now as a novice SharePoint developer.