LoslegenKostenlos loslegen

Local addresses

The "A1" address system has coordinates that exist over the whole worksheet. If you have a block of data specified somewhere within that worksheet, it can be useful to be able to specify the addresses relative to that block.

This can be done with INDEX(), which takes 3 arguments. The first argument is a rectangular range of data, for example A2:E8. The second and third arguments are numbers specifying an offset down then right from the top left of that data range. Unlike OFFSET(), the numbering starts at 1, so INDEX(A2:E8, 4, 2) refers to cell B5.

Diese Übung ist Teil des Kurses

Intermediate Google Sheets

Kurs anzeigen

Anleitung zur Übung

Use the block of data for North East India + North Myanmar, from A11 to G19 as the reference.

  • In cell I1, use INDEX() to get the number of Blues in Sikkim.
  • In cell I2, get the number of White-yellows in Mizoram Hills.

Interaktive Übung

In dieser interaktiven Übung kannst du die Theorie in die Praxis umsetzen.

Übung starten