Hi Bruce,
Actually, Lance will want to use "TABLEFIND()" to look up the values in another View. It has the looping capability that I think is necessary here.
There is a description of the function in the F1-Help text and in the
Release Note where it was added in 2014.