ExcelTips: Powerful Lookup Functions
Summary: Want to access your data indirectly? The answer is to use Excel's lookup function. ExcelTips: Powerful Lookup Functions is a key resource in discovering how to use those functions.
Excel provides hundreds of worksheet functions that you can use to build formulas, modify data, and get just the information you need in a cell. Of all the worksheet functions available, few are more powerful, as a group, than the lookup functions. The functions in this group allow you to indirectly access information in a worksheet; they allow you to "look up" information based upon various parameters that you specify.
In total there are seven lookup functions provided in Excel: CHOOSE, MATCH, INDEX, OFFSET, VLOOKUP, HLOOKUP, and LOOKUP. While the number of functions may seem small, the power these functions provide you is anything but small. The lookup functions are some of the most misunderstood worksheet functions in Excel, but they are essential to understand if you want to master how your data is accessed in your formulas. Once you discover how to use these functions, you'll see numerous ways in which you can enhance your worksheets.
The pages of ExcelTips: Powerful Lookup Functions, fourth edition, include valuable tutorial information and dozens of tips that can help you better understand not only what lookup functions are, but how to use them in real-world scenarios to improve the calculations you must do in your own workbooks. All the information related to the lookup functions is included in one place. Just take a look at the comprehensive table of contents.
Many people consider Excel's lookup functions, by their nature, to be an advanced topic. Even so, the tips in this book are written so that even the most novice of users can understand how to use the functions. Indeed, there is plenty of information here for a broad range of readers.
ExcelTips: Powerful Lookup Functions is available as an immediate download that includes the e-book as both a Microsoft Word document and an Adobe Acrobat (PDF) document. These allow you to enjoy the following features:
- The ability to view, search, and print the book.
- Screen shots that illustrate what you see in Excel as you follow the step-by-step instructions.
- The ability to select and copy sections of text, such as macro code.
- Hyperlinks to internal content (in the book itself) and referenced resources on the Web.
Since the electronic book is provided in Adobe Acrobat (PDF) format, you need to either have Acrobat or the free Adobe Acrobat Reader. Many computer systems already have the reader installed. If you do not, you can get it free, directly from Adobe.
ExcelTips: Powerful Lookup Functions is immediately usable by all Excel users; the information it contains has been tested with Excel 2007, Excel 2010, Excel 2013, and Excel 2016. Whatever version you are using, ExcelTips: Powerful Lookup Functions provides a valuable resource for focused information that can't be matched by any other single source or computer book.
|ExcelTips: Powerful Lookup Functions||
ISBN 978-1-61359-364-6 (1.7 MB)