Hi guys,
Im after some assistance please. This is the first time this has happened. I have a mail merge which displays invoice numbers which are all numeric. I use a formula that vlookups them up only if they exist and will return "" if not, until today it was working fine but now i get random 0 as values.
Example, ill have invoice 1 and invoice 2. Lets say there are no invoice numbers for invoice 2 therefore my cells in excel are blank. When i click through and check the data in word after ive inserted the field say there are 10 entries for invoice 2, some have a 0 value? Say 3 have 0 and the rest are blank?
I dont understand why some are showing 0 and some arent when the formula is the same throughout and should be just blank?
Can anyone share any light?
Thanks
Im after some assistance please. This is the first time this has happened. I have a mail merge which displays invoice numbers which are all numeric. I use a formula that vlookups them up only if they exist and will return "" if not, until today it was working fine but now i get random 0 as values.
Example, ill have invoice 1 and invoice 2. Lets say there are no invoice numbers for invoice 2 therefore my cells in excel are blank. When i click through and check the data in word after ive inserted the field say there are 10 entries for invoice 2, some have a 0 value? Say 3 have 0 and the rest are blank?
I dont understand why some are showing 0 and some arent when the formula is the same throughout and should be just blank?
Can anyone share any light?
Thanks