Hi,

"Richard Buttrey" wrote in message
Why wouldn't the simpler
=if(iserror(vlookup blah blah)),"???",vlookup(more blah))
suffice?

That was the third option I offered. The first option is the shortest, the
second only checks for a specific error and is shorter than the third one.
All three should be equal performance wise.

Regards,
KL