Presenting Different Scenarios with OFFSET Function

The OFFSET function lets you refer to a cell(s) that's a specific distance from another cell. Though not a lookup function, it can almost work like VLOOKUP. I'll cover an example to show how the OFFSET function works with a simple use case of picking different scenarios of price and quantity inputs to determine revenue outputs.