Skip to main content

Lookups

Accessing rows​

If you have a table index, you can extract a given row by using the lookup function like this:

Accessing values​

If you have a table index, you can extract a value by using the lookup function and specifying the column name in which said value is located:

Cashflow positive for the month​

For Financial planning and analysis models you often need to:

  • Calculate growth based on previous months
  • Find the point in your model where you break even

You can achieve this using lookup, previous, and next.

Here's how to find in what month you turn cashflow positive.

Break even​

Sometimes however you need to keep count of profits, or headcount.

You can use the previous function and find the month when you break even.

If you want to calculate how much of a interest free loan or extra investment you need: