Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
vlookup STRANGE
I am copying and pasting into a spreadsheet vin #'s from a website. Then i am
copying and pasting my own vin#'s next to it. I have about 50 vin #'s that are in the information that I copied from the website. I have done millions of vlookup formula but its not recognizing the vins, I think it is not in a number format. Sometimes a green error tab will pop up in the text and I can then convert it to a number and it will work, but there is no error. I can email the sheet to someone to see if you can help me. Thanks, I think its something simple that I am missing. Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
vlookup STRANGE
I'd review the notes for troubleshooting =vlookup() formulas from Debra
Dalgleish: http://contextures.com/xlFunctions02.html#Trouble Hamed parhizkar wrote: I am copying and pasting into a spreadsheet vin #'s from a website. Then i am copying and pasting my own vin#'s next to it. I have about 50 vin #'s that are in the information that I copied from the website. I have done millions of vlookup formula but its not recognizing the vins, I think it is not in a number format. Sometimes a green error tab will pop up in the text and I can then convert it to a number and it will work, but there is no error. I can email the sheet to someone to see if you can help me. Thanks, I think its something simple that I am missing. Thanks -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
why this strange result with vlookup | Excel Worksheet Functions | |||
Strange vlookup results | Excel Programming | |||
Strange vlookup problem | Excel Discussion (Misc queries) | |||
Strange VLOOKUP Problem | Excel Discussion (Misc queries) | |||
Strange Vlookup problem | Excel Worksheet Functions |