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?