IFERROR problem

I have a work book with 8 sheets of information. One of the sheets has a work order form that uses information from the other sheets, ie. the first cell is customer name which I get from a drop down list that I created. The other fields such as address, contact information, and phone number is filled in using IFERROR(VLOOKUP. The problem is that if there is no information to pull I want the cell to be blank, instead I am getting a 0 in the cell. I have read several threads and the formula I am using looks correct which is;
=IFERROR(VLOOKUP(C13,Sheet1!A2:P376,9,FALSE),"") the customer name is in cell C13 and the rest of the info is pulled from Sheet1. Any help or suggestions would be greatly appreciated. I am using Excel 2007.

If you link to another cell in Excel, e.g.:

=A1

and that cell is empty, then Excel will return a zero. To overcome this you have to do this:

=IF(A1="","",A1)

i.e. if it is empty then return an empty string, otherwise return the value. Applying this to your problem, you need to do this:

=IFERROR(if(VLOOKUP(C13,Sheet1!A2:P376,9,FALSE)="","",VLOOKUP(C13,Sheet1!A2:P376,9,FALSE)),"")

It's not specifically an IFERROR problem, just a problem with how Excel returns values from an empty cell.

Hope this helps.

Pete