Hi... I've wasted a full day today trying to do vlookup with zipcodes. Some
zipcodes start with zeros. I want to import county from one worksheet with
zip codes into another worksheet with zipcodes containing other data. But I
can't trim and clean my data like I do with account numbers because I lose
the leading zeros on some zip codes. And for some strange reason I can't get
the zipcodes on both worksheets into the same format. If I make them both
zip code format it won't work. If I make them both text, some but not all of
the leading zeros are lost. I can't get them into identical format for
vlookup. I'm at a loss here with this usually simple vlookup task that has
been a bear today. PLEASE advise.
--
Thanks!