O'Reilly logo

Microsoft® Excel® 2010: Data Analysis and Business Modeling by Wayne L. Winston

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

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