vlookup problems
Posted by steven Hargreaves on January 22, 2002 6:22 AM
using vlookup from one worksheet to another to return a description where the relevant codes match, vlookup,a2,range,2,false = #NA, was the result.
one sheet had leading zeros so amended that still #NA built in an iserror to return 0 if #NA returned 0's but no descriptions. Have made sure both fields number format, any ideas?
Posted by Stephen Hoadley on January 22, 2002 6:33 AM
use text to columns in data drop down menu and set column to general in both work sheets
Posted by lucky on January 22, 2002 9:12 AM
also check for any 'spaces' at the start or end of the data in the cell. Easy check, find and replace any spaces in column....
Had a similar prob.
Lucky
Posted by Chris D on January 22, 2002 1:26 PM
Posted by Steven Hargreaves on January 23, 2002 8:28 AM
Text to columns was the answer cheers for the help!
