> For the complete documentation index, see [llms.txt](https://cookbook.geuer-pollmann.de/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://cookbook.geuer-pollmann.de/productivity/excel.md).

# Excel

![](/files/WAWhWOJH0jkjl2IprAXy)

The only Excel tutorial you need in your life:

{% embed url="<https://www.youtube.com/watch?v=0nbkaYsR94c>" %}

![Using the INDEX() and the MATCH() functions](/files/rk0hQjO7MxXpT5PxTirJ)

```
=INDEX(Bonuses[Bonus]; MATCH([@Type]; Bonuses[Type]; 0))
```