XL: VLOOKUP() Returns Incorrect Result of Zero

ID: Q134259

The information in this article applies to:

• Microsoft Excel for Windows 95, version 7.0
• Microsoft Excel 97 for Windows

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.

Additional query words: 7.00 8.00 97

Keywords          : xlformula 
Version           : WINDOWS:7.0,97
Platform          : WINDOWS

Last Reviewed: January 8, 1999