Using Excel as a database
Hold on to your seats, this is going to be a bumpy ride...
I have Excel 2003 set up as a database where certain values are derived
from vlookups. This works fine and returns the correct values in the
spreadsheet. I then use the Excel spreadsheet as a database for a mail
merge in Word 2003. The problem is, of the 4 values that are produced
from the vlookup, one of them is returning a "0" value in the mail
merge, even though that's not what is appearing in the spreadsheet.
I've checked the spreadsheet to be sure all cells are fomatted
correctly - I can't find what is causing this! Can anyone help me? It
will take hours of work to recreate this spreadsheet and I would prefer
to fix the issue rather than start from scratch!
--
Furniture1st
|