| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
v look up formula to generate a blank line
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
v look up formula to generate a blank line
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Moving formula results to blank line | Excel Worksheet Functions | |||
| Have a formula yield a true blank that disconnects graph line | Charts and Charting in Excel | |||
| generate a random number and use if function to generate new data | Excel Worksheet Functions | |||
| How do you add a blank line automatically after the Subtotal line | Excel Worksheet Functions | |||
| how do I generate a blank cell when I paste link; comes up - or 0 | Excel Discussion (Misc queries) | |||
Linear Mode
