Microsoft KB Archive/50648

Works: VLOOKUP or HLOOKUP Functions Return a Zero Value

PSS ID Number: Q50648 Article last modified on 10-16-1998

1.05 2.00 3.00

MS-DOS

=
========================================================= 1.05 2.00 3.00 MS-DOS kbother

= SUMMARY =

In versions 1.05 and 2.0 of Microsoft Works for MS-DOS, if you use the VLOOKUP or HLOOKUP function in the Spreadsheet module and there is text in the result column or row of the lookup table, a zero (0) or FALSE is returned as the answer.

Versions 1.05 and 2.0 of Works for MS-DOS can only work with numerical values in formulas. Works 3.0 can accept text in the lookup table and, in general, has text functionality in formulas.

KBCategory: kbother KBSubcategory: dworkskb

Additional reference words: 2.00 3.00

=
========================================================= Version : 1.05 2.00 3.00 Platform : MS-DOS ============================================================================= Copyright Microsoft Corporation 1998.