Test for the blank:

Instead of:
=VLOOKUP(12,F1:G4,2)
use something like:
=IF(VLOOKUP(12,F1:G4,2)="","",VLOOKUP(12,F1:G4,2))

--
Gary''s Student - gsnu200856


"Tacklemom" wrote:

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


--
Donna