MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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.

Posted by Chris D on January 22, 2002 1:26 PM

Careful using =iserror when all you want to eliminate is N/A..



Posted by Steven Hargreaves on January 23, 2002 8:28 AM

Text to columns was the answer cheers for the help!