Hello,

In sheet 1 col. A I have many zip codes and In sheet 2 I have 5 col. A,B,C,D
are zip codes (They Do not match with sheet1 col. A) and in col. "E" I have
phone numbers.
How can I do a macro that compares sheet1 Col.A with sheet2 Col. A,B,C,D and
find the closest match and if found copy corresponding cell in Col. E which
is phone number to sheet1 next to zip code?

thank you.

--
Message posted via http://www.officekb.com