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/region. I need to track revenues from Iran as well as costs ...