Chapter 6
Lookup, Information, and Text Formulas
In This Chapter
Looking up data in a table and adding it to a list
Transposing vertical cell ranges to horizontal and vice versa
Getting information about a cell’s contents
Evaluating a cell’s type with the IS information functions
Using text functions to manipulate text entries
Creating formulas that combine text entries
This chapter covers three categories of Excel functions: the lookup and reference functions that return values and cell addresses from the spreadsheet, the information functions that return particular types of information about cells in the spreadsheet, and the text functions that enable you to manipulate strings of text in the spreadsheet.
In these three different categories of Excel functions, perhaps none are as handy as the lookup functions that enable you to have Excel look up certain data in a table and then ...
Get Excel 2016 All-in-One For Dummies now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.