Hi All,

I copied three columns (City, State, Zip) from a web site which I
presume is HTML to a blank Excel 2007 sheet. I performed a copy past
special past values to a second sheet to get rid of any hyper links or
formatting.
Now here's where it get's tricky.
Assuming these three columns are A, B & C, I made a VLOOKUP in
column D.
I referenced column C (zip) to a table on another sheet which had
supplementing information.
The VLOOKUP returned an #N/A.
Now if I double click one of the zip codes in column C and then hit
enter, the VLOOKUP will work. Why won't it work if I DON'T do this?
I have thousands of these numbers so I need a way to do this in mass.

Any ideas?

Thanks for your help in advance.