Hi,

Try this

=if(iserror(vlookup(A3,B4:100,2,0)),"",vlookup(A3, B4:100,2,0))

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"burtlake" wrote in message
...
I am using VLOOKUP to determine addresses from a master list. However I
have
found that if the Lookup Value is NOT in the Table Array, I will get
incorrect information.

For example if the Table Array has entries for Schmidt and Schultz, and I
attempt to lookup Schnell (which is not in the Table Array), I will get
the
value for Schultz, which is incorrect.

How can this be avoided? Or, how can I get a message saying the Lookup
Value was not found - rather than getting incorrect results?