Works: VLOOKUP or HLOOKUP Functions Return a Zero Value

This article was previously published under Q76408
This article has been archived. It is offered "as is" and will no longer be updated.
When you use the VLOOKUP or HLOOKUP function in the Microsoft Works 2.0 forWindows Spreadsheet module, the function returns a zero (0) or False ifthere is text in the result column/row of the lookup table. Works does nothave text functionality in the Spreadsheet module and can only work withnumerical 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.

Article ID: 76408 - Last Review: 10/07/2013 00:49:41 - Revision: 3.1

  • Microsoft Works 2.0 Standard Edition
  • Microsoft Works 2.0a
  • kbnosurvey kbarchive KB76408