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.