Hi everyone,

I have exported two sheets of data one from ARCGIS dbf and one from
SPSS toand excel sheet.

I am trying to use vlookup to match the data from both sheets and
replace any missing values with zeros. The result is all are regarded
as missing unless I have manually retyped the id field (for the
vlookup) in both sheets - then a result is returned. I think it has
something to do with formatting but can't work out what the problem is
and as there are over 12,000 ids I don't want to many reenter them.

Any suggestions on how to get the formatting the same for both sheets??
thanks!


--
Sabretooth
------------------------------------------------------------------------
Sabretooth's Profile: http://helpfeeds.com/member.php?userid=1253
View this thread: http://helpfeeds.com/showthread.php?t=202654