Lookup functions are -mining minions. You use them to address tables of data, searching for a particular value to display or use in a formula. The Lookup and Reference menu on the Formulas tab includes 19 functions, but this focuses on the top contenders: LOOKUP, VLOOKUP, and HLOOKUP. The section also examines the TRANSPOSE function, which you use to flip vertically oriented data horizontal, and vice-versa.

 

Using the VLOOKUP and HLOOKUP functions

How to choose between the VLOOKUP and HLOOKUP functions depends upon how your table is organized. If your #data is ...
Read More

Using the LOOKUP function

You use the LOOKUP function primarily for one-dimensional lookup tasks—single rows or columns of #data. You can also use LOOKUP ...
Read More

Using the TRANSPOSE function

The TRANSPOSE function does a seemingly simple thing (until you try to do it yourself): it flips the horizontal/vertical orientation ...
Read More

This lesson is a part of Advanced formulas in Excel 2013 from 77-427 Excel 2013 Expert Part One Prep course. More lessons in this chapter are

Look up data by using functions

Lookup functions are #data-mining minions. You use them to address tables of data, searching for a particular value to display ...
Read More

Apply advanced date and time functions

Date and time arithmetic has its own rules and syntax. In Excel (and in most modern computers), date and time ...
Read More

The Practice tests included in this course are:

No posts found.