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.