When you use the Lookup Wizard to copy formulas and lookup parameters to a new location in a workbook, you may receive the following error message:
Run-time error '1004'
Application-defined or object-defined error
↑ Back to the top
This behavior can occur only if the AutoFilter feature is turned on.
↑ Back to the top
To work around this issue, first turn off the AutoFilter, and then run the Lookup Wizard. To do this in Microsoft Excel 2002 and in Microsoft Office Excel 2003, point to Filter on the Data menu, and then click AutoFilter. To do this in Microsoft Office Excel 2007, click Filter on the Data tab.
When you have finished using the Lookup Wizard, you can turn the AutoFilter back on.
↑ Back to the top
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
↑ Back to the top