VLOOKUP Problem

U

uplink600

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
 
R

Roger Govier

Hi

You could suppress the zero's by using Tools>Options>View and untick Zero
values
or try
=IF($B$6="","",IF(VLOOKUP($B$6,Customer_File,2,FALSE))="","",VLOOKUP($B$6,Customer_File,2,FALSE)))

Regards

Roger Govier
 
Top