They are trying to combine one csv/lookup with the values of a second lookup. If you were going to go the lookup route you would do the generating search, then run the lookup against the 'correct' priority data, to return the correct priority as something like 'new_priority', and then coalesce on that.
... View more