T
Tacklemom
Hi there,
What i am trying to do is I am using V lookup formula to generate a mailing
address for invoices. But what I want is if the 2nd line of the address is
left blank on the data source that it is left blank on the address line of
our invoices.
As well I am using Vlook up to join 2 cells in one line ( eg city, state)
and I would like to know how to insert a , and blank space between the 2
cells.
Thank you
What i am trying to do is I am using V lookup formula to generate a mailing
address for invoices. But what I want is if the 2nd line of the address is
left blank on the data source that it is left blank on the address line of
our invoices.
As well I am using Vlook up to join 2 cells in one line ( eg city, state)
and I would like to know how to insert a , and blank space between the 2
cells.
Thank you