Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copies From The Internet
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pasting from the Internet | Excel Discussion (Misc queries) | |||
excel and internet. | Excel Discussion (Misc queries) | |||
Internet Queries | Excel Discussion (Misc queries) | |||
Excel & internet | Excel Discussion (Misc queries) | |||
internet explorer | Excel Discussion (Misc queries) |