LOL - Who needs the second trap? #NA is just as good an indicator as
anything I could chuck in, and assuming the OP had used that last argument
of 0 in each of his VLOOKUPs then the formula will return an error if the
value doesn't exist in the second table either.

--
Regards
Ken.......................


"Biff" wrote in message
...
Hi Ken!

Yes, I know ISERROR is the "catch-all".

Just wondering why you and RD didn't include an error trap
for the second lookup?

FALSE or 0? sheesh!

Wouldn't that be the same as:

=CONCATENATE(A1,B1) or =A1&B1

Biff

<snip