Hi

I have a small problem with a sheet I have created. I use the followin
function to display a customer name and address.

=IF($B$6<>"",(VLOOKUP($B$6,Customer_File,2,FALSE)),"") in cell B8
=IF($B$6<>"",(VLOOKUP($B$6,Customer_File,3,FALSE)),"") in cell B9
=IF($B$6<>"",(VLOOKUP($B$6,Customer_File,4,FALSE)),"") in cell B10

etc etc

When an an account number is entered in B6 the customer name an
address details from Customer_File are displayed in the relevant cells
The problem is that some of the fields in the array are empty and so o
the main sheet a 0 is displayed instead of just en empty cell so I ge
something like

Account    P007898   
       
    Dexian Engineering Ltd   
    Albion Street   
    0   
    0   
    Lincoln   
    0   
    LN16 1GG   

Where the 0 is displayed I just want an empty cell. Please advise wha
might be wrong. All cells are formatted as text.

Thanks

V