Lookup functions are #data-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 #section 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.
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
The Practice tests included in this course are:No posts found.