| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
data from internet not showing up
I copied and pasted a table from the internet that has "*Bobby Abreu" in cell
B3. In cell AF3 I have the formula: =VLOOKUP(IF(LEFT(B3, 1)="*", MID(B3, 2, 100), B3), draft, 2, FALSE), resulting in an error (#N/A). If I manually type "*Bobby Abreu" in cell B3, then the correct result, "65", turns up in cell AF3. I've gone through evaluate formula and both times it shows that vlookup is searching for "Bobby Abreu" in the draft table, however, when I have the internet data in, it keeps showing the error. I don't want to have to manually type in the names, as there are about 600. Is there something with the format of the cell that is causing this, or some kind of hidden characters in the internet data? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Linking data from the Internet | Excel Worksheet Functions | |||
| update data from internet | Excel Worksheet Functions | |||
| Newbie - can I get into excel data from the Internet? | Excel Discussion (Misc queries) | |||
| Getting Data for excell off of the internet | Excel Discussion (Misc queries) | |||
| Getting Data from the Internet to Excel | Excel Discussion (Misc queries) | |||
Threaded Mode
