I have a string field in one list and I need to take the value of that string and pick the value of a lookup in another list. How do I do that with the shortest workflow possible? I have to do this with quite a few fields. And there are over 100 items in the list that I need to convert this field. Also, there may be about 10 or so items in the lookup.
So just to be clear, in one list the string field may be 'Blue' and I need to take that in the other list where there is a field called 'Color' that is a lookup field and in that lookup field there is an item that can be selected that is 'Blue'. In that lookup, there will be other colors as well.
I am using SharePoint 2013 and Nintex 2013.