Chapter 22. The OFFSET function

Questions answered in this chapter:

Image How can I create a reference to a range of cells that is a specified number of rows and columns from a cell or another range of cells?

Image How can I perform a lookup operation based on the right-most column in a table range instead of the left-most column?

Image I often download software product sales information listed by country/region. I need to track revenues from Iran as well as costs ...

Get Microsoft Excel 2016 Data Analysis and Business Modeling now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.