Get rid of #N/A when using a vlookup
 

In Column A i've got a drop down box of Customer Names and in column B i have
a vlookup to give me the sales rep who calls on those customers in column A.
When column A is not filled out, column B shows #N/A. Is there a way to
tell Excel to leave the cell blank until Column A is filled out?

Get rid of #N/A when using a vlookup
 

=IF(ISNA(YourFormula),"",YourFormula)

In Excel 2007:

=IFERROR(YourFormula,"")


--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"JC" wrote in message ...
| In Column A i've got a drop down box of Customer Names and in column B i have
| a vlookup to give me the sales rep who calls on those customers in column A.
| When column A is not filled out, column B shows #N/A. Is there a way to
| tell Excel to leave the cell blank until Column A is filled out?

Get rid of #N/A when using a vlookup
 

One way:

=IF(A1="","",VLOOKUP(A1,..............))

--
Biff
Microsoft Excel MVP


"JC" wrote in message
...
In Column A i've got a drop down box of Customer Names and in column B i
have
a vlookup to give me the sales rep who calls on those customers in column
A.
When column A is not filled out, column B shows #N/A. Is there a way to
tell Excel to leave the cell blank until Column A is filled out?