How does the function determine if it's right or wrong?
--
HTH,
Barb Reinhardt



"shress" wrote:

Hi,

I am stuck with a problem. I need to compare two columns. one with ZIP and
other with street names. A Single ZIP has numerous streent names. Is there a
function which will say if the address is Right or Wrong?
for example:
11000 Apple Street <Right
11000 Banana Street <Right
11000 Mango Street <Wrong

and so on

Thanks,