View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Furniture1st
 
Posts: n/a
Default 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