Hi,
I use lookup tables this way regularly. I define my default to some thing like NONE, pass the result of the lookup into a temporary value and then check this using an IF statement. I then COPY the relevant value based upon the result of the IF.
Hope this helps.
Garry
