Microsoft KB Archive/76408

= Works: VLOOKUP or HLOOKUP Functions Return a Zero Value =

Article ID: 76408

Article Last Modified on 11/16/2006

-

APPLIES TO


 * Microsoft Works 2.0 Standard Edition
 * Microsoft Works 2.0a

-



This article was previously published under Q76408



SUMMARY
When you use the VLOOKUP or HLOOKUP function in the Microsoft Works 2.0 for Windows Spreadsheet module, the function returns a zero (0) or False if there is text in the result column/row of the lookup table. Works does not have text functionality in the Spreadsheet module and can only work with numerical values in its formulas or the results of its formulas.

NOTE: Works 3.0 for Windows and Works 4.0, 4.5, and 4.5a for Windows 95 support text functionality in formulas.

Additional query words: 2.00

Keywords: KB76408

-

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

© Microsoft Corporation. All rights reserved.