In terms of the error trap, that's easy - if a little long

=if(iserror(vlookup(etc),"error message",vlookup(etc))

it's long because you enter the vlookup formula twice!