Funkcji wyszukiwania i adresu

[ ] indicates optional parameters

ADR.POŚR(adres_tekst, [a1])
ADRES(nr_wiersza, nr_kolumny, [typ_adresu], [a1], [tekst_arkusz])
HIPERŁĄCZE(łącze_lokalizacja, [przyjazna_nazwa])
ILE.WIERSZY(tablica)
INDEKS(odwołanie, [nr_wiersza], [nr_kolumny], [nr_obszaru])
LICZBA.KOLUMN(tablica)
NR.KOLUMNY([odwołanie])
OBSZARY(odwołanie)
PODAJ.POZYCJĘ(szukana_wartość, przeszukiwana_tab, [typ_porównania])
PRZESUNIĘCIE(odwołanie, wiersze, kolumny, [wysokość], [szerokość])
TRANSPONUJ(tablica)
WIERSZ([odwołanie])
WYBIERZ(nr_arg, wartość1, [wartość2, ...])
WYSZUKAJ(szukana_wartość, przeszukiwany_wektor, [wektor_wynikowy])
WYSZUKAJ.PIONOWO(szukana_wartość, tabela_tablica, nr_indeksu_kolumny, [przeszukiwany_zakres])
WYSZUKAJ.POZIOMO(szukana_wartość, tabela_tablica, nr_indeksu_wierszy, [przeszukiwany_zakres])


Funkcji wyszukiwania i adresu

ADR.POŚR(adres_tekst, [a1])

Returns a reference from the specified text.

adres_tekstA text expression that evaluates to the name of a cell or range of cells.
a1Specifies the style of the reference. The possible values are:
FAŁSZR1C1 style
PRAWDAA1 style
If this parameter is omitted it defaults to PRAWDA.


ADRES(nr_wiersza, nr_kolumny, [typ_adresu], [a1], [tekst_arkusz])

Returns a string containing the specified cell address.

nr_wierszaThe row number of the cell.
nr_kolumnyThe column number of the cell.
typ_adresuA number representing whether the row or column are to be absolute or relative. The possible values are:
1Both absolute
2Absolute row, relative column
3Relative row, absolute column
4Both relative
If this parameter is omitted it defaults to 1.
a1Specifies the style of the reference. The possible values are:
FAŁSZR1C1 style
PRAWDAA1 style
If this parameter is omitted it defaults to PRAWDA.
tekst_arkuszOptional sheet name with which to prefix the reference.


HIPERŁĄCZE(łącze_lokalizacja, [przyjazna_nazwa])

Jumps to a cell or range when this cell is selected.

łącze_lokalizacjaA text expression that evaluates to the form "filename" or "[filename]reference".
przyjazna_nazwaThe text to be displayed in the cell. If this parameter is omitted it defaults to the link location text.


ILE.WIERSZY(tablica)

Returns the number of rows in the reference.

tablicaThe reference whose rows you want to count.


INDEKS(odwołanie, [nr_wiersza], [nr_kolumny], [nr_obszaru])

Returns a subset of an array or reference.

odwołanieThe array or reference of which you want the subset.
nr_wierszaThe number of the row to return. If this parameter is omitted all rows will be returned.
nr_kolumnyThe number of the column to return. If this parameter is omitted all columns will be returned.
nr_obszaruThe number of the area to return when the reference contains more than one area. If this parameter is omitted it defaults to 1.


LICZBA.KOLUMN(tablica)

Returns the number of columns in the reference.

tablicaThe reference whose columns you want to count.


NR.KOLUMNY([odwołanie])

Returns the column number of the reference.

odwołanieThe reference whose column number you want. If this parameter is omitted it defaults to the cell containing the function.


OBSZARY(odwołanie)

Returns the number of areas contained in the reference.

odwołanieThe reference whose areas you want to count.


PODAJ.POZYCJĘ(szukana_wartość, przeszukiwana_tab, [typ_porównania])

Returns a number representing the position of a value in a table.

szukana_wartośćThe value to be found in the table.
przeszukiwana_tabA reference containing the table cells.
typ_porównaniaWhether to find an approximate or exact match. The possible values are:
1If an exact match is not found, use the closest value less than the lookup value (the table values should be in ascending order)
0An exact match is required
-1If an exact match is not found, use the closest value greater than the lookup value (the table values should be in descending order)
If this parameter is omitted it defaults to 1.


PRZESUNIĘCIE(odwołanie, wiersze, kolumny, [wysokość], [szerokość])

Returns a new reference based on the specified reference.

odwołanieThe reference to be used as a starting point.
wierszeThe number of rows to move the reference up (negative) or down (positive).
kolumnyThe number of columns to move the reference left (negative) or right (positive).
wysokośćThe height of the new reference. If this parameter is omitted it defaults to the height of the old reference.
szerokośćThe width of the new reference. If this parameter is omitted it defaults to the width of the old reference.


TRANSPONUJ(tablica)

Returns the transposition of the specified array or reference.

tablicaThe array or reference whose values you want to transpose.


WIERSZ([odwołanie])

Returns the row number of the reference.

odwołanieThe reference whose row number you want. If this parameter is omitted it defaults to the cell containing the function.


WYBIERZ(nr_arg, wartość1, [wartość2, ...])

Returns one of several values depending on the index.

nr_argThe index of the value to be returned, should be in the range 1 to 29.
wartość1, ...Up to 29 values, one of which will be chosen to be the result.


WYSZUKAJ(szukana_wartość, przeszukiwany_wektor, [wektor_wynikowy])

Returns a value from a horizontal or vertical table, found by searching for the lookup value in the top row (for a horizontal table) or left column (for a vertical or square table) of the table and then returning a value from the corresponding position in the result range (if specified) or from the bottom row (for a horizontal table) or right column (for a vertical or square table) of the table.

szukana_wartośćThe value to be found in the table.
przeszukiwany_wektorA reference containing the table cells.
wektor_wynikowyThe range of cells from which to return a result. If this parameter is not specified the result will be returned from the opposite row or column of the table range.


WYSZUKAJ.PIONOWO(szukana_wartość, tabela_tablica, nr_indeksu_kolumny, [przeszukiwany_zakres])

Returns a value from a vertical table, found by searching for the lookup value in the left column of the table and then returning a value from the same or a different column in the table.

szukana_wartośćThe value to be found in the table.
tabela_tablicaA reference containing the table cells.
nr_indeksu_kolumnyThe offset of the value to be returned, where 1 is the left column of the table.
przeszukiwany_zakresWhether to find an approximate or exact match. The possible values are:
FAŁSZAn exact match is required
PRAWDAIf an exact match is not found, use the closest value less than the lookup value
If this parameter is omitted it defaults to PRAWDA.


WYSZUKAJ.POZIOMO(szukana_wartość, tabela_tablica, nr_indeksu_wierszy, [przeszukiwany_zakres])

Returns a value from a horizontal table, found by searching for the lookup value in the top row of the table and then returning a value from the same or a different row in the table.

szukana_wartośćThe value to be found in the table.
tabela_tablicaA reference containing the table cells.
nr_indeksu_wierszyThe offset of the value to be returned, where 1 is the top row of the table.
przeszukiwany_zakresWhether to find an approximate or exact match. The possible values are:
FAŁSZAn exact match is required
PRAWDAIf an exact match is not found, use the closest value less than the lookup value
If this parameter is omitted it defaults to PRAWDA.