Lookup Reference functions

LOOKUP (worksheet function) 82 Lookup Reference functions 81 lookup in table, with linear interpolation 171 Loop, Do While... (VBA) 268 loop, exiting from (VBA) 269 Loop, For Each...Next (VBA) 268 Loop, For...Next (VBA) 268 looping (VBA) 267 LOWER (worksheet function) 79... 

Appendix A lists selected worksheet functions in the Database, Date Time, Information, Logical, Lookup Reference, Math Trig, Statistical, Lookup Reference, and Text categories. Appendix B provides an alphabetical list of these worksheet functions along with the required syntax, some comments on the required and optional arguments, one or more examples and a list of related functions. 

Excel 2000 provides more than 300 worksheet functions, in 11 categories Engineering, Financial, Date Time, Information, Math Trig, Statistical, Lookup Reference, Database, Text, Logical, External. This book uses functions from seven of those categories. This appendix lists selected worksheet functions by category. In Appendix B, the functions are listed alphabetically, with comments, examples and related functions. 

A spreadsheet program is often referred to as an electronic accountant s pad. However, a closer look at an electronic spreadsheet reveals that it is much more than just a neat representation of rows and colunms. Its fadlity for table lookup, its ikbility to do quick what-if calculations and to handle if-dien-else logic functions, and its capability to provide graphic displays and define keyboard macros makes it a handy tool for performing both simple and complex engi neering calculations [1-8]. 

---