O'Reilly logo

Excel 2013 All-in-One For Dummies by Greg Harvey

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 6: Lookup, Information, and Text Formulas

In This Chapter

arrow.png Looking up data in a table and adding it to a list

arrow.png Transposing vertical cell ranges to horizontal and vice versa

arrow.png Getting information about a cell’s contents

arrow.png Evaluating a cell’s type with the IS information functions

arrow.png Using text functions to manipulate text entries

arrow.png 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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required