Susan:
Are you importing both the Acct and the Dept? Are there only 3 columns: Vendor, Acct and Dept? I tested that way and it worked (on a very small sample size).