I am using a lookup table which contains addressing and company information in cells across the page, all starting with a unique customer number.
On another page I am using the first field to input a customer number and then the lookup function returns the next few fields to insert customer information. The whole line then gets input into a mail merge with word to create invoices etc. Using the following:
I find that a blank gives no returns (as planned) but if there is data in some of the fields but one or two are blank (as in different numbers of lines in addresses) I get a zero returned from the lookup function. This messes up the mail merge, doesn't look too good having zeros in the address line.
Any ideas of how to get the resultant not to put a 0 in when it is a blank in the lookup table?
I suppose I could have tried to do this in a database but I am pretty lousy with databases (not so good with Excel either it now appears)