v look up formula to generate a blank line

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
 
G

Gary''s Student

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))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top