> For the complete documentation index, see [llms.txt](https://docs.cascade.io/cascade/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.cascade.io/cascade/functions-and-expressions/functions/table/lookup.md).

# LOOKUP

LOOKUP( `column`, `integer`)

Returns a reference to a row relative to the current row, determined by the input `integer`. If `integer` is 0, returns the current row.

{% hint style="info" %}
`OFFSET()` and `LOOKUP()` are aliases of one another.
{% endhint %}

### Arguments

| Argument  | Description                                                      |
| --------- | ---------------------------------------------------------------- |
| `column`  | Column to return                                                 |
| `integer` | Number of rows to offset. `integer` can be positive or negative. |

### Output

Values in `column`, offset by the given `integer`

### Example

Let's say we want to find yesterday's price such that we can compare today's price and yesterday's price directly. `LOOKUP({Price}, -1)` allows us to obtain the price from 1 row behind our current row. 

{% embed url="<https://datawrapper.dwcdn.net/3uu2G/1>" %}