Chapter 22. The OFFSET Function

Questions answered in this chapter:

  • 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?

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

  • I often download software product sales information listed by country. I need to track revenues from Iran as well as costs and units sold, but the data about Iran isn’t always in the same location in the worksheet. Can I create a formula that will always pick out Iran’s revenues, costs, and units sold?

  • Each drug developed by my company goes through three stages of development. I have a list of the cost by month for each drug, and I ...

Get Microsoft® Excel® 2010: 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.