Microsoft KB Archive/30433

Mac Works: Using Text Values in LOOKUP, HLOOKUP, & VLOOKUP

PSS ID Number: Q30433 Article last modified on 10-22-1998

1.0 1.1 2.0 3.0

MACINTOSH

=
========================================================= 1.00 1.10 2.00 3.00 MACINTOSH kbother string

= SUMMARY =

Microsoft Works will not accept text values for any arguments in the LOOKUP, HLOOKUP and VLOOKUP functions. Additionally, these functions will return only numbers from the Compare range. Text values will return a “0” (zero).

Works does not support string characters in the LOOKUP, HLOOKUP, and VLOOKUP functions.

This feature is under review and will be considered for inclusion in a future release.

= MORE INFORMATION =

Reference(s):

“User’s Guide,” version 3.0, pages 406-410 “Using Microsoft Works” version 2.0, page 290 “Using Microsoft Works” version 1.0, page 242

KBCategory: kbother KBSubcategory: macworkskb

= Additional reference words: 1.00 1.10 2.00 mwksss =

Version : 1.0 1.1 2.0 3.0 Platform : MACINTOSH ============================================================================= Copyright Microsoft Corporation 1998.