VLOOKUP Problem
Posted by Bob on January 23, 2002 1:52 PM
I have a strange question about VLOOKUP. I have data in a worksheet that came from an external data source, using a query with Synergy Driver. When I try to use VLOOKUP with this information I keep getting #N/A. When I enter the data myself, VLOOKUP works. Is there something weird about the external data? Im trying to avoid entering 3200 lines of data by hand.
Posted by IML on January 23, 2002 2:00 PM
Text vs Numbers, trailing spaces?
try highlighting the "lookup" column on your data table. Select text to columns from the data menu and hit finish?
Does it work now?
If not, look for trailing spaces in your table. If this is the case, try making use of the trim function.
good luck
Posted by Bob on January 23, 2002 2:36 PM
Re: Text vs Numbers, trailing spaces?
I tried them both, but neither one worked.But I do appreciate you trying to help
Posted by Steve Hartman on January 23, 2002 2:43 PM
Just grasping at straws here but are you sure the data is being parsed? If it is space delimited it could appear to be in columns but actually have all the data for one row in the first cell. I've had problems with the parsing on data files generated by other applications before.
Posted by IML on January 23, 2002 2:44 PM
Re: Text vs Numbers, trailing spaces?
Could you post your look up formula and the first few rows of your table?
Posted by IML on January 23, 2002 2:58 PM
Another straw
If you are looking up A1 from table, try
=vlookup(A1+0,table,row,0)
