Microsoft KB Archive/134259

= VLOOKUP Returns Incorrect Result =

Article ID: 134259

Article Last Modified on 8/15/2005

-

APPLIES TO


 * Microsoft Excel 97 Standard Edition
 * Microsoft Excel 95 Standard Edition

-



This article was previously published under Q134259



SYMPTOMS
In Microsoft Excel, the VLOOKUP worksheet function may return an incorrect result when the following conditions are true:


 * The lookup table and the VLOOKUP function are on different worksheets. -and-


 * The Transition Formula Evaluation option is enabled on the worksheet that contains the lookup table.



RESOLUTION
To resolve this problem, disable the Transition Formula Evaluation option. To do this, follow these steps:


 * 1) Activate the worksheet that contains the lookup table.
 * 2) On the Tools menu, click Options.
 * 3) Click the Transition tab.
 * 4) Click to clear the Transition Formula Evaluation check box, and then click OK.



STATUS
Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. This problem no longer occurs in Microsoft Excel 2000.

Additional query words: 8.00 97 XL

Keywords: KB134259

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.