After creating a lookup and assigning that lookup to a field in the dataflow, you need to
correct the exception records in the Business Steward Portal.
In the Exception Editor, select the dataflow that is producing the exception
records.
For the first problematic record, click the field that you assigned the lookup
to.
Click the drop-down button in that field and select the correct label for that
record.
Remember: This label is not necessarily the same as the value. For
example, if you want your field to have a value of "California" you might click
a label that says "CA".