# 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>" %}