Select the product you need help with

Works: VLOOKUP or HLOOKUP Functions Return a Zero Value

Article ID: 76408 - View products that this article applies to.

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.

Properties

Article ID: 76408 - Last Review: November 16, 2006 - Revision: 3.1

APPLIES TO

Microsoft Works 2.0 Standard Edition
Microsoft Works 2.0a

KB76408

Retired KB Content Disclaimer

This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.