{"text_format":"1","workbook":"xlsx","n_sheets":23,"sheets":["Alg","Sisukord","Index_1","Index_2","abi","Index_3","Korterid","MATCH","MATCH_D","Ind_Mats_1","Fukts","SumIF","LOOKUP","Sõnad","VLOOKUP","Üldpõhimõtted","Värvid","Ind_Mats_Tab","Vahemik","Komisjoon","Ind_Mats_Tab_1","Arvutid","Sheet2"],"not_rendered":{"charts":1,"images":11,"macros":1,"external_links":1,"defined_names":98,"comments":7,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Alg","index":0,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Otsimis- ja viitamisfunktsioonid"]

{"sheet":"Sisukord","index":1,"n_rows":17,"n_cols":2,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Funktsioon INDEX - üldpõhimõtted"]
[null,"Funktsioon INDEX - näited 1"]
[null,"Funktsioon INDEX - näited 2"]
[null,"Andmed korterite kohta"]
[null,"Otsimise üldpõhimõtted"]
[null,"Funktsioon LOOKUP"]
[null,"Funktsioon VLOOKUP"]
[null,"Funktsioon MATCH"]
[null,"Funktsiooni MATCH tööpõhimõte. Demo"]
[null,"Funktsioonide INDEX ja MATCH kooskasutamine. Paralleelsed vektorid"]
[null,"Funktsioonide ekstreemumite ja nende asukohtade leidmine"]
[null,"Funktsioonide INDEX ja MATCH kooskasutamine. Tabel"]
[null,"Vahemiku otsimine"]
[null,"Harjutus \"Komisjonitasu\""]
[null,"Otsimine kahes suunas. INDEX & MATCH ja VLOOKUP. "]

{"sheet":"Index_1","index":2,"n_rows":20,"n_cols":10,"rows_kept":20,"cut":false,"hidden":false,"merged":[[4,1,4,6],[5,1,5,6],[8,1,8,8]]}
[null,null,null,null,"veeb",null,null,"klipp index"]
[null,"Funktsioon INDEX"]
[]
[null,null,null,null,null,null,null,null,"V(k); V[k]"]
[null,"INDEX (vektor; indeks)",null,null,null,null,null,"Vk = INDEX(V; k)"]
[null,"INDEX (tabel; riviindeks; tulbaindeks)",null,null,null,null,null,"Ti, j = INDEX(T; i; j)"]
[null,null,null,null,null,null,null,null,"T(i, j); T[i] [j]"]
[null,null,null,null,null,{"$error":"#NAME?"}]
[]
[]
[null,null,"Vektor V",null,null,null,null,null,"k","Vk"]
[null,null,13,-27,65,89,-24,null,3,{"$f":"INDEX(V, k)","v":65}]
[null,"k",1,2,3,4,5,null,null,"=INDEX(V; k)"]
[]
[null,null,"Maatriks A  (4*3)",null,null,"i"]
[null,null,13,4,5,1]
[null,null,7,21,-5,2,"i","j","Ai, j"]
[null,null,-9,33,5,3,{"$f":"4-abi+1","v":1},1,{"$f":"INDEX(A, i, j)","v":13}]
[null,null,8,17,12,4,4,null,"=INDEX(A; i; j)"]
[null,"j",1,2,3]

{"sheet":"Index_2","index":3,"n_rows":25,"n_cols":7,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,"veeb",null,"klipp index"]
[null,"Funktsiooni INDEX kasutamine"]
[]
[null,"Leida kuu numbrile vastav kuu nimi"]
[null,"lehel abi on vektor kuude nimedega"]
[]
[null,"nr","kuu nimi"]
[]
[]
[]
[null,"Leida kuupäevale vastav kuu nimi ja nädalapäeva nimi"]
[]
[null,"kuupäev","kuu nimi","päeva nimi"]
[null,{"$f":"TODAY()","v":"2016-09-05"}]
[]
[]
[]
[null,"Palgaarvestus",null,"Tariif leida lehel abi olevast vektorist"]
[]
[null,"Nimi","kat","tunde","tariif","Palk"]
[null,"U. Saar",3,132]
[null,"H. Kask",4,143]
[null,"E. Tamm",6,137]
[null,"U. Paju",10,135]
[null,"K. Lepp",5,68]

{"sheet":"abi","index":4,"n_rows":15,"n_cols":7,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"päevad",null,"kuud",null,"kateg","tariifid"]
[null,"esmaspäev",null,"jaanuar",null,1,3.8]
[null,"teisipäev",null,"veebruar",null,2,6.8]
[null,"kolmapäev",null,"märts",null,3,9.6]
[null,"neljapäev",null,"aprill",null,4,10.8]
[null,"reede",null,"mai",null,5,12.6]
[null,"laupäev",null,"juuni",null,6,14.2]
[null,"pühapäev",null,"juuli",null,7,17]
[null,null,null,"august",null,8,18.8]
[null,null,null,"september",null,9,21.8]
[null,null,null,"oktoober",null,10,25.6]
[null,null,null,"november"]
[null,null,null,"detsember"]

{"sheet":"Index_3","index":5,"n_rows":15,"n_cols":6,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,"klipp index"]
[null,"Funktsiooni INDEX kasutamine"]
[]
[null,"Leida korteri numbri järgi tabelist Korterid",null,"Korterid"]
[null,"omaniku nimi, inimeste arv ja korteri pindala"]
[]
[null,"Kaks varianti:"]
[null,"1) eraldi nimi igal tulbal,"]
[null,"2) üks nimi tervel tabelil"]
[]
[null,"krt",1]
[null,"omanik"]
[null,"inimesi"]
[null,"pind"]
[null,null,"Variant 1","Variant 2"]

{"sheet":"Korterid","index":6,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Korterid"]
[null,1,2,3,4]
[1,"Number","Omanik","Pindala","Inimesi"]
[2,1,"A. Kask",65.3,3]
[3,2,"P. Lepp",74.5,2]
[4,3,"K. Mänd",65.3,5]
[5,4,"L. Tamm",42.6,2]
[6,5,"H. Kuusk",74.5,1]
[7,6,"O. Palm",63.7,2]
[8,7,"V. Tamm",45.6,3]
[9,8,"S. Mets",82.4,5]
[10]

{"sheet":"MATCH","index":7,"n_rows":28,"n_cols":11,"rows_kept":28,"cut":false,"hidden":false,"merged":[[1,10,1,11]]}
[null,null,null,null,"veeb"]
[null,"Funktsioon MATCH",null,null,"Iseseisvalt harva. Sageli koos funktsiooniga INDEX.",null,null,null,null,null,"klipp otsimine"]
[]
[null,"MATCH (otsitav; vektor; otsimisviis)"]
[null,"Leiab otsitava väärtuse järjenumbri antud vektoris"]
[null,"otsimisviis - ei ole kohustuslik. Võib olla 0 või 1. Kui puudub võetakse 1."]
[null,"0 - kindla väärtuse otsimine - järjestus vektoris suvaline"]
[null,"kui otsitavaga võrdset väärtust ei ole, tagastab veateate #N/A"]
[null,"1 - vahemiku otsimine - väärtused vektoris peavad olema kasvamise järjekorras"]
[null,"kui otsitavaga võrdset väärtust ei ole, tagastab lähima väikseima otsitavale"]
[]
[null,null,null,null,null,null,"koht","nimi","punkte"]
[null,"Leida võistleja koht ja punktide arv",null,null,null,null,1,"Kask",360]
[null,"kõrvalolevast tabelist",null,null,null,null,2,"Saar",322]
[null,"võistleja","koht","punkte",null,null,3,"Paju",301]
[null,"Paju",{"$f":"MATCH(võistleja, nimi, 0)","v":3},null,null,null,4,"Tamm",280]
[null,null,null,null,null,null,5,"Kuusk",270]
[null,null,null,null,null,null,6,"Mänd",265]
[]
[null,"Leida kuu nimetuse järgi selle järjenumber"]
[null,"kuu nimetus","kuu number"]
[]
[]
[]
[null,"Leida korteri omaniku järgi korteri number,"]
[null,"korteri pindala ja inimeste arv (tabel lehel Korterid)"]
[]
[null,"Omanik","Korter","Pindala","Inimesi"]

{"sheet":"MATCH_D","index":8,"n_rows":17,"n_cols":6,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Funktsiooni MATCH tööpõhimõte"]
[null,"Kindla väärtuse otsimine"]
[null,"Tagastab otsitava järjenumbri antud vektoris"]
[null,"või teate selle puudumise kohta"]
[]
[]
[null,"k","Liigid"]
[null,1,"saar"]
[null,2,"kask"]
[null,3,"paju",null,"liik","nr"]
[null,4,"kuusk",null,"tamm",7]
[null,5,"jalakas"]
[null,6,"vaher"]
[null,7,"tamm"]
[null,8,"mänd"]
[null,9,"haab"]

{"sheet":"Ind_Mats_1","index":9,"n_rows":30,"n_cols":11,"rows_kept":30,"cut":false,"hidden":false,"merged":[[27,7,27,8],[28,7,28,8]]}
[null,null,null,null,"veeb",null,"klipp otsimine"]
[null,"INDEX & MATCH"]
[null,"Otsimine paralleelsetes vektorites"]
[]
[null,"INDEX(vek_2; MATCH(otsitav; vek_1; OV))"]
[null,"OV - otsimisviis - 0  või 1"]
[null,"MATCH leiab otsitava väärtusele vastava järjenumbri vek_1-s"]
[null,"INDEX tagastab leitud numbriga väärtuse vek_2-st"]
[null,"vrdl."]
[null,"LOOKUP(otsitav; vek_1; vek_2)"]
[null,"NB! Ei võimalda määrata otsimisviisi"]
[null,"vektor_1 peab olema sorditud väärtuste kasvamise järjekorras"]
[]
[null,"Leida korteri omaniku järgi pindala ja inimeste arv"]
[null,"korterid",null,null,null,null,null,"Koodid","Nimetused","Pakendis","Hinnad"]
[null,"Omanik","pind","inimesi",null,null,null,214002,"Dor Blue juust 50% 100 g",5,1.1000000000000001]
[null,"H. Kuusk",null,null,null,null,null,214003,"ARLA juust Kvibille Grädd.140g",10,1.48]
[null,null,null,null,null,null,null,214006,"Juust ROSENBORG sinihallitus 125g",8,2]
[null,null,null,null,null,null,null,214073,"FETAKI juust 500 g",24,2.19]
[null,null,null,null,null,null,null,214071,"Juust Camembert 125 g",24,2.48]
[null,"Leida värvi kogus ja maksumus korterite lagede värvimiseks",null,null,null,null,null,214157,"Juust Atleet viil vaakumis (ca 150 g)",1,7.02]
[null,"korter","värv","kogus","maksumus",null,null,214158,"Juust Eesti viil vaakumis (ca 150 g)",1,7.02]
[null,1,"VL_11",null,null,null,null,214004,"ARLA juust Kvibille Grädd.3kg",1,27.49]
[null,2,"VL_06"]
[null,3,"VL_13"]
[null,4,"VL_02",null,null,null,null,"Leida nimetuse alusel kauba kood ja hind"]
[null,5,"VL_11"]
[null,6,"VL_11",null,null,null,null,"nimetus",null,"kood","hind"]
[null,7,"VL_02",null,null,null,null,"Juust Atleet viil vaakumis (ca 150 g)"]
[null,8,"VL_11"]

{"sheet":"Fukts","index":10,"n_rows":30,"n_cols":12,"rows_kept":30,"cut":false,"hidden":false,"merged":[[0,12,0,13]]}
[]
[null,"Funktsioonide ekstreemumite ja nende asukohtade leidmine"]
[null,"Koostada valemid, mis leivad fumktsiooni Y maksimumi"]
[null,"ja funktsioni Z miinimumi ja nende asukohad"]
[null,"algus","samm","lõpp",null,"Ymax","koht","Zmin","koht",null,"baas","lisa"]
[null,{"$f":"baas + lisa","v":-13},1,{"$f":"algus + 20*samm","v":7},null,null,null,null,null,null,-50,37]
[]
[]
[null,"x","Y","Z"]
[null,{"$f":"algus","v":-13},{"$f":"3 * SIN(x + 2) * COS(x / 2)","v":2.9297341846998819},{"$f":"IF(x < 0, 5 * COS(2 * x - 3)*SIN(3*x+3),   3 * SIN(x + 1)*COS(x/2))","v":-3.7095381955222315}]
[null,{"$f":"B10+samm","v":-12},1.5670587179594901,1.4605652982528563]
[null,-11,-0.87616774175259482,4.8966986200543952]
[null,-10,-0.84193056732976213,2.5479433725296423]
[null,-9,0.41547004587670799,-2.4800588314849641]
[null,-8,-0.54791447390446779,-4.1360264682625765]
[null,-7,-2.6939731488413168,-1.0332207882793638]
[null,-6,-2.2476863752900278,2.4700790602321545]
[null,-5,0.33917218044928332,2.4345568372641733]
[null,-4,1.1352037429618924,-9.1195597548648973E-3]
[null,-3,-0.1785699082496302,-1.2729195802431239]
[null,-2,0,-0.53195346104639607]
[null,-1,2.2153807878123861,0]
[null,0,2.7278922804770449,2.5244129544236893]
[null,1,0.37153337462150493,2.3939506960620163]
[null,2,-1.2267063999049068,0.22874239727663015]
[null,3,-0.20349485940270645,-0.16060227219965309]
[null,4,0.34883362697318027,1.1971599101679844]
[null,5,-1.5790218571903594,0.67155582740080566]
[null,6,-2.9383717218207628,-1.951235409295947]
[null,7,-1.157793334382389,-2.7794734385302884]

{"sheet":"SumIF","index":11,"n_rows":41,"n_cols":15,"rows_kept":41,"cut":false,"hidden":false,"merged":[[0,5,0,6]]}
[null,null,null,null,"veeb","Klipp SumIF",null,null,null,"Harjutustabel"]
[]
[null,"Funktsioonid COUNTIF ja SUMIF ",null,null,null,null,null,null,null,"Arvutite müükide arvestus",null,null,null,"AM_SIF"]
[]
[null,null,null,null,null,null,null,null,null,"A_Kuupäev","A_Linn","A_Arvuti","A_Arv","A_Hind","A_Maksumus"]
[null,null,null,null,null,null,null,null,null,"2015-01-02","Tallinn","Frodo",2,{"$f":"VLOOKUP(A_Arvuti, Arvutid, 6, 0)","v":1330},{"$f":"A_Hind*A_Arv","v":2660}]
[null,null,null,null,null,null,null,null,null,"2015-01-02","Valga","Balrog",1,419,419]
[null,null,null,null,null,null,null,null,null,"2015-01-03","Tallinn","Aragorn",2,499,998]
[null,null,null,null,null,null,null,null,null,"2015-01-03","Tallinn","Balrog",3,419,1257]
[null,null,null,null,null,null,null,null,null,"2015-01-03","Võru","Gandalf",2,849,1698]
[null,null,null,null,null,null,null,null,null,"2015-01-04","Tallinn","Eldar",3,465,1395]
[null,null,null,null,null,null,null,null,null,"2015-01-04","Tartu","Balrog",5,419,2095]
[null,null,null,null,null,null,null,null,null,"2015-01-07","Pärnu","Eldar",3,465,1395]
[null,null,null,null,null,null,null,null,null,"2015-01-07","Tallinn","Faram",1,599,599]
[null,null,null,null,null,null,null,null,null,"2015-01-07","Valga","Balrog",6,419,2514]
[null,null,null,null,null,null,null,null,null,"2015-01-07","Valga","Frodo",1,1330,1330]
[null,null,null,null,null,null,null,null,null,"2015-01-09","Tallinn","Grimbold",6,1149,6894]
[null,null,null,null,null,null,null,null,null,"2015-01-10","Pärnu","Elend",1,1299,1299]
[null,null,null,null,null,null,null,null,null,"2015-01-10","Pärnu","Rohan",4,589,2356]
[null,null,null,null,null,null,null,null,null,"2015-01-10","Tartu","Sauron",2,339,678]
[null,null,null,null,null,null,null,null,null,"2015-01-11","Tallinn","Frodo",1,1330,1330]
[null,"Arvud","arv",null,null,null,null,null,null,"2015-01-11","Tartu","Balrog",2,419,838]
[null,23,21,null,"Mitu korda esineb loetelus arv 13",null,null,null,null,"2015-01-11","Valga","Aragorn",1,499,499]
[null,-45,null,null,"Mitu korda esineb loetelus lahtris arv olev arv",null,null,null,null,"2015-01-14","Pärnu","Gandalf",3,849,2547]
[null,13,null,null,"Positiivsete arvude summa",null,null,null,null,"2015-01-14","Tartu","Frodo",4,1330,5320]
[null,18,null,null,"Positiivsete arvude arv",null,null,null,null,"2015-01-14","Valga","Kalvar",2,699,1398]
[null,21,null,null,"Positiivsete arvude aritmeetiline keskmine",null,null,null,null,"2015-01-16","Tallinn","Arven",5,369,1845]
[null,13,null,null,"Mitu korda esineb loetelus arv 21",null,null,null,null,"2015-01-17","Tallinn","Balrog",7,419,2933]
[null,-16,null,null,"Negatiivsete arvude summa",null,null,null,null,"2015-01-17","Tartu","Aragorn",3,499,1497]
[null,21,null,null,"Negatiivsete arvude arv",null,null,null,null,"2015-01-18","Pärnu","Eldar",1,465,465]
[null,13,null,null,"Negatiivsete arvude aritmeetiline keskmine",null,null,null,null,"2015-01-18","Tallinn","Aragorn",1,499,499]
[null,null,null,null,null,null,null,null,null,"2015-01-19","Tallinn","Frodo",3,1330,3990]
[null,null,null,null,null,null,null,null,null,"2015-01-19","Tartu","Kalvar",1,699,699]
[null,null,null,null,null,null,null,null,null,"2015-01-19","Võru","Elend",5,1299,6495]
[null,null,null,null,null,null,null,null,null,"2015-01-20","Tallinn","Elend",2,1299,2598]
[null,null,null,null,null,null,null,null,null,"2015-01-20","Võru","Sauron",3,339,1017]
[null,null,null,null,null,null,null,null,null,"2015-01-21","Pärnu","Arven",1,369,369]
[null,null,null,null,null,null,null,null,null,"2015-01-25","Võru","Sauron",1,339,339]
[null,null,null,null,null,null,null,null,null,"2015-01-26","Pärnu","Gandalf",2,849,1698]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M6:M40)","v":90},null,63963]

{"sheet":"LOOKUP","index":12,"n_rows":16,"n_cols":5,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,"veeb"]
[null,"Funktsioon LOOKUP"]
[]
[null,"LOOKUP(otsitav; vek_1; vek_2)"]
[null,"Otsib otsitavale vastavat väärtust vektorist vek_1 ning "]
[null,"tagasrtab sama numbriga väärtuse vektorist vek_2"]
[null,"kui otsitavaga võrdset väärtust ei ole, loetakse vastavaks otsitavale lähim väikseim väärtus"]
[null,"Väärtused vektoris vek_1 peavad olema kasvamise järjekorras!"]
[null,"NB! Ei võimalda määrata otsimisviisi. Sobib peamiselt vahemiku otsimiseks!"]
[]
[null,"\"Sõnaraamat\""]
[null,"Leida eestikeelsele sõnale ingliskeelne vaste"]
[null,"Sõnad om lehel \"Sõnad\" tulpades \"eesti\" ja \"inglise\""]
[]
[null,"eesti","inglise"]
[null,"kass",{"$f":"LOOKUP(est, eesti, inglise)","v":"cat"}]

{"sheet":"Sõnad","index":13,"n_rows":33,"n_cols":3,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"eesti","inglise"]
[null,"ahv","monkey"]
[null,"elevant","elephant"]
[null,"gepard","cheetah"]
[null,"hiir ","mouse"]
[null,"hirv","deer"]
[null,"hobune","horse"]
[null,"hunt","wolf"]
[null,"jänes","hare"]
[null,"kalkun","turkey"]
[null,"kana","hen"]
[null,"karu","bear"]
[null,"kass","cat"]
[null,"kobras","beaver"]
[null,"koer","dog"]
[null,"kukk","cock"]
[null,"küülik","rabbit"]
[null,"lammas","sheep"]
[null,"lehm","cow"]
[null,"lõvi","lion"]
[null,"mäger","badger"]
[null,"põder","elk"]
[null,"põrsas","piglet"]
[null,"rebane","fox"]
[null,"rott","rat"]
[null,"siga","pig"]
[null,"siil","hedgehong"]
[null,"tall","lamb"]
[null,"tiiger","tiger"]
[null,"varss","foal"]
[null,"vasikas","calf"]

{"sheet":"VLOOKUP","index":14,"n_rows":21,"n_cols":9,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,"veeb"]
[null,"Funktsioon VLOOKUP"]
[]
[null,"VLOOKUP (otsitav; tabel; t_tulp; otsimisviis)",null,null,null,"Koodid","Nimetus","Pakendis","Hind"]
[null,"Otsimine vertikaalses tabelis",null,null,null,214002,"Dor Blue juust 50% 100 g",5,1.1000000000000001]
[null,"Otsib väärtust tabeli esimesest tulbast ",null,null,null,214003,"ARLA juust Kvibille Grädd.140g",10,1.48]
[null,"t_tulp - tabeli tulba number, kust võetakse tagastatav väärtus",null,null,null,214006,"Juust ROSENBORG sinihallitus 125g",8,2]
[null,"otsimisviis - ei ole kohustuslik, vaikimisi - 1 või True",null,null,null,214073,"FETAKI juust 500 g",24,2.19]
[null,"0 või False - kindla väärtuse otsimine",null,null,null,214071,"Juust Camembert 125 g",24,2.48]
[null,"1 või True  - vahemiku otsimine",null,null,null,214157,"Juust Atleet viil vaakumis (ca 150 g)",1,7.02]
[null,null,null,null,null,214158,"Juust Eesti viil vaakumis (ca 150 g)",1,7.02]
[null,"Leida koodi järgi kauba hind ja nimetus tabelist Kaubad",null,null,null,214004,"ARLA juust Kvibille Grädd.3kg",1,27.49]
[null,"kood","hind","Nimetus"]
[]
[]
[null,"Funktsioon HLOOKUP"]
[null,"HLOOKUP (otsitav; tabel; t_rivi; otsimisviis)"]
[null,"Otsimine horisontaalses tabelis"]
[null,"Otsib väärtust tabeli esimesest rivist"]
[null,"t_rivi - tabeli rivi number, kust võetakse tagastatav väärtus"]
[null,"otsimisviis - sama nagu VLOOKUP'is"]

{"sheet":"Üldpõhimõtted","index":15,"n_rows":49,"n_cols":15,"rows_kept":49,"cut":false,"hidden":false,"merged":[[19,10,19,12],[34,1,35,1],[34,2,34,4]]}
[null,null,null,null,null,"veeb"]
[]
[null,null,null,null,null,null,null,null,null,null,"VLOOKUP(otsitav; tabel; v_nr [; tunnus])"]
[null,null,null,null,null,null,null,null,null,"Hinnakiri"]
[null,null,null,null,null,null,null,null,null,"liigid","hinnad",null,"liik","hind"]
[null,null,null,null,null,null,null,null,null,"tamm",230,null,"mänd",{"$f":"VLOOKUP(liik, Hinnakiri[], 2, 0)","v":150}," =VLOOKUP(liik; Hinnakiri; 2; 0)"]
[null,null,null,null,null,null,null,null,null,"vaher",220,null,null,{"$f":"VLOOKUP(liik, Hinnakiri[], 2)","v":150}," =VLOOKUP(liik; Hinnakiri; 2)"]
[null,null,null,null,null,null,null,null,null,"saar",210]
[null,null,null,null,null,null,null,null,null,"kuusk",160]
[null,null,null,null,null,null,null,null,null,"mänd",150]
[null,null,null,null,null,null,null,null,null,"kask",120]
[null,null,null,null,null,null,null,null,null,"lepp",110]
[null,null,null,null,null,null,null,null,null,"haab",76]
[null,null,null,null,null,null,null,null,null,"paju",76]
[]
[null,null,null,null,null,null,null,null,null,"Otsimistabelite näiteid"]
[null,null,null,null,null,null,null,null,null,"Koodi järgi võib otsida nimetust, hinda ja ühikute arvu pakendis"]
[null,null,null,null,null,null,null,null,null,"Nimetuse järgi võib otsida koodi, hinda ja ühikute arvu pakendis"]
[null,null,null,null,null,null,null,null,null,"kood","kaup",null,null,"hind"]
[null,"Puidu hind sõltub läbimõõdust.",null,null,"Vahemiku otsimine",null,null,null,null,214004,{"$f":"VLOOKUP(J20, Kaubad_1, 2, 0)","v":"ARLA Juust Kvibille Grädd.3kg"},null,null,{"$f":"VLOOKUP(kood1, Kaubad_1, 6, 0)","v":22.91}]
[]
[null,"vahemik","hind",null,"piirid","hinnad",null,null,null,"kood","kaup",null,null,"pakendis","hind"]
[null,"< 10",44,null,0,44,null,null,null,214003,"ARLA Juust Kvibille Grädd.140g",null,null,10,1.24]
[null,"10 – 14",48,null,10,48,null,null,null,214004,"ARLA Juust Kvibille Grädd.3kg",null,null,1,22.91]
[null,"15 - 19",52,null,15,52,null,null,null,214002,"Dor Blue juust 50% 100 g",null,null,5,0.92]
[null,"20 – 24",55,null,20,55,null,null,null,214073,"FETAKI juust 500 g",null,null,24,1.82]
[null,"25 – 29",58,null,25,58,null,null,null,214157,"Juust Atleet viil vaakumis (ca 150 g)",null,null,1,5.85]
[null,">= 30",56,null,30,56,null,null,null,214071,"Juust Camembert 125 g",null,null,24,2.0699999999999998]
[null,null,null,null,null,null,null,null,null,214158,"Juust Eesti viil vaakumis (ca 150 g)",null,null,1,5.85]
[null,null,null,null,"läbimõõt","hind"]
[null,null,null,null,18,{"$f":"VLOOKUP(d, P_hind[], 2)","v":52}]
[]
[null,null,null,null,null,null,null,null,null,"Hinnakiri. Puidu hind sõltub liigist ja läbimõõdust"]
[null,"Hinnakiri. Puidu hind sõltub liigist ja läbimõõdust"]
[null,"Liik","Sort",null,null,null,null,null,null,"<10","10-14","15-19","20-24","25-29",">=30"]
[null,null,1,2,3]
[null,"haab",50,{"$f":"0.9*C37","v":45},{"$f":"0.8*C37","v":40},null,null,null,"Liigid",0,10,15,20,25,30]
[null,"kask",70,{"$f":"0.9*C38","v":63},{"$f":"0.8*C38","v":56},null,null,null,"haab",12,17,19,24,25,25]
[null,"kuusk",80,72,64,null,null,null,"kask",15,23,27,32,33,33]
[null,"küte",47,42.300000000000004,37.6,null,null,null,"kuusk",29,32,35,37,39,38]
[null,"lepp",65,58.5,52,null,null,null,"mänd",32,35,38,41,43,42]
[null,"mänd",75,67.5,60,null,null,null,"saar",34,36,41,44,45,45]
[null,"saar",85,76.5,68,null,null,null,"tamm",40,45,50,57,60,73]
[null,"tamm",110,99,88,null,null,null,"vaher",36,40,43,45,47,53]
[null,"vaher",95,85.5,76]
[]
[null,null,null,null,null,null,null,null,null,"liik","läbimõõt","hind"]
[null,"Liik","sort","hind",null,null,null,null,null,"kuusk",23,{"$f":"VLOOKUP(liik_1, P_hind1, MATCH(läbimõõt, mõõdud)+1, 0)","v":37}]
[null,"lepp",2,{"$f":"VLOOKUP(liik_2, P_hind2, sort+1, 0)","v":58.5}]

{"sheet":"Värvid","index":16,"n_rows":15,"n_cols":5,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Värvide hinnakiri"]
[]
[null,"v_mark","v_kulu","v_hind","v_tootja"]
[null,"VL_13",0.52,3.6,"Sadolin"]
[null,"VL_30",0.47,3.92,"Kessu"]
[null,"VL_01",0.52,3.98,"JukuColor"]
[null,"VL_25",0.42,4.08,"Kessu"]
[null,"VL_06",0.45,4.13,"JukuColor"]
[null,"VL_11",0.48,4.1399999999999997,"JukuColor"]
[null,"VL_02",0.48,4.4000000000000004,"Sadolin"]
[null,"VL_21",0.39,5.17,"Sadolin"]
[null,"VL_09",0.55000000000000004,5.24,"JukuColor"]
[null,"VL_05",0.65,5.29,"JukuColor"]
[null,"VL_32",0.55000000000000004,8.23,"Kessu"]

{"sheet":"Ind_Mats_Tab","index":17,"n_rows":27,"n_cols":11,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"veeb"]
[null,"INDEX & MATCH"]
[null,"Otsimine vertikaalses tabelis "]
[]
[]
[null,"INDEX(tabel; MATCH(otsitav; v_tulp; OV); t_tulp)"]
[null,"MATCH leiab otsitava väärtusele vastava järjenumbri (jnr) tulbas v_tulp"]
[null,"v_tulp - võtmete tulp tabelis (tavaliselt 1. tulp)"]
[null,"INDEX tagastab väärtuse lahtrist tabel(jnr, t_tulp) "]
[null,"t_tulp - tulba number, kust võetakse tagastatav väärtus"]
[]
[null,"Võrdluseks funktsioon VLOOKUP"]
[]
[null,"VLOOKUP(otsitav; tabel; t_tulp; OV)"]
[]
[null,"Leida värvi hind ja kulu, kasutades funktsioone"]
[null,"INDEX ja MATCH otsimiseks tabelis"]
[]
[null,null,"Värv","Hind","Kulu",null,null,"Koodid","Nimetused","Pakendis","Hinnad"]
[null,null,"VL_30",null,null,null,null,214002,"Dor Blue juust 50% 100 g",5,1.1000000000000001]
[null,null,null,null,null,null,null,214003,"ARLA juust Kvibille Grädd.140g",10,1.5]
[null,"Näide",null,null,null,null,null,214006,"Juust ROSENBORG sinihallitus 125g",8,2]
[null,"Leida tabelist Juustud nimetuse järgi kauba kood ja hind",null,null,null,null,null,214073,"FETAKI juust 500 g",24,2.2000000000000002]
[null,"Nimetus","kood","hind",null,null,null,214071,"Juust Camembert 125 g",24,2.5]
[null,"Juust Camembert 125 g",null,null,null,null,null,214157,"Juust Atleet viil vaakumis (ca 150 g)",1,7]
[null,null,null,null,null,null,null,214158,"Juust Eesti viil vaakumis (ca 150 g)",1,7]
[null,null,null,null,null,null,null,214004,"ARLA juust Kvibille Grädd.3kg",1,27.5]

{"sheet":"Vahemik","index":18,"n_rows":32,"n_cols":7,"rows_kept":32,"cut":false,"hidden":false,"merged":[[11,5,11,6]]}
[]
[null,"Vahemiku otsimine"]
[null,"Funktsioonide LOOKUP ning INDEX ja MATCH kasutamine vahemiku otsimiseks"]
[null,"Kauba hind sõltub ostetavast kogusest"]
[null,"kogus - K","hind"]
[null,"1 <= K < 5",60]
[null,"5 <= K < 15",58]
[null,"15 <= K < 25",56]
[null,"25 <= K < 35",54]
[null,"35 <= K < 45",52]
[null,"45 <= K  < 50",50]
[null,"K  >= 50",48,null,null,"Otsimistabel"]
[]
[null,"kogus - K","hind","piirid",null,"piirid","hinnad"]
[null,"1 <= K < 5",60,1,null,1,60]
[null,"5 <= K < 15",58,5,null,5,58]
[null,"15 <= K < 25",56,15,null,15,56]
[null,"25 <= K < 35",54,25,null,25,54]
[null,"35 <= K < 45",52,35,null,35,52]
[null,"45 <= K  < 50",50,45,null,45,50]
[null,"K  >= 50",48,50,null,50,48]
[]
[null,null,null,"LOOKUP","INDEX/MATCH","IF"]
[null,null,"kogus","hind","hind","hind"]
[null,null,25,null,null,{"$f":"IF(kogus<$F$16, $G$15, IF(kogus<$F$17, $G$16, IF(kogus<$F$18, $G$17, IF(kogus<$F$19, $G$18, IF(kogus<$F$20, $G$19, IF(kogus<$F$21, $G$20, $G$21))))))","v":54}]
[null,null,3,null,null,60]
[null,null,13,null,null,58]
[null,null,37,null,null,52]
[null,null,60,null,null,48]
[null,null,26,null,null,54]
[]
[" =IF(kogus<$F$16; $G$15; IF(kogus<$F$17; $G$16; IF(kogus<$F$18; $G$17; IF(kogus<$F$19; $G$18; IF(kogus<$F$20; $G$19; IF(kogus<$F$21; $G$20; $G$21))))))"]

{"sheet":"Komisjoon","index":19,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Komisjoni tasu leidmine"]
[]
[null,"Nimi","Läbimüük","Protsent","Tasu"]
[null,"Kaasik",3240]
[null,"Kuusik",690]
[null,"Tammik",6320]
[null,"Lepik",2700]
[null,"Männik",1830]

{"sheet":"Ind_Mats_Tab_1","index":20,"n_rows":29,"n_cols":8,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Otsimine kahes suunas. INDEX & MATCH ja VLOOKUP. "]
[]
[null,"INDEX(tabel; MATCH(otsitav1; v_tulp; OV1); MATCH(otsitav2; v_rivi; OV2);)"]
[null,"Esimene MATCH leiab otsitava1 väärtusele vastava rivinumbri - m"]
[null,"Teinene MATCH leiab otsitava2 väärtusele vastava tulbanumbri - n"]
[null,"v_tulp - võtmete tulp tabelis, v_rivi - võtmete rivi tabelis "]
[null,"INDEX tagastab väärtuse lahtrist tabel(m, n) "]
[]
[null,"Sama funktsiooniga VLOOKUP"]
[null,"VLOOKUP(otsitav1; tabel; MATCH(otsitav2; v_rivi; OV2); OV1)"]
[]
[null,"Näide. Leida puidu hind sõltuvalt liigist ja läbimõõdust"]
[]
[null,"liik","d","hind I & M","hind VL"]
[null,"mänd",9,{"$f":"INDEX(P_hinnad, MATCH(liik, P_liigid, 0)+1, MATCH(d, P_diam, 1)+1)","v":51},{"$f":"VLOOKUP(liik, P_hinnad, MATCH(d, P_diam, 1)+1, 0)","v":51}]
[]
[]
[null,null," 5 - 10","10-14","15-19","20-24","25-29",">=30"]
[]
[null,"Liigid",5,10,15,20,25,30]
[null,"haab",34,38,42,46,50,53]
[null,"kask",47,53,58,64,71,74]
[null,"kuusk",54,60,67,73,81,85]
[null,"lepp",44,49,54,60,66,69]
[null,"mänd",51,56,63,69,76,79]
[null,"saar",57,64,71,78,86,90]
[null,"tamm",74,83,92,101,111,117]
[null,"vaher",64,71,79,87,96,101]

{"sheet":"Arvutid","index":21,"n_rows":20,"n_cols":8,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,null,"Arvutid"]
[]
[null,null,"Mark","Protsessori\ntüüp","Takt-\nsagedus","Põhimälu\nmaht","Kõvaketta\nmaht","Hind"]
[null,null,"Aragorn","AMD Athlon64",3,512,160,499]
[null,null,"Arven","Intel Core 2",2.6,256,200,369]
[null,null,"Balrog","Intel Celeron",2.8,256,80,419]
[null,null,"Eldar","Intel Xeon",3,512,160,465]
[null,null,"Elend","Intel Celeron",4,2048,400,1299]
[null,null,"Faram","AMD Athlon64",3,512,210,599]
[null,null,"Frodo","AMD Athlon64",3,4072,500,1330]
[null,null,"Gandalf","Intel Xeon",3.2,512,160,849]
[null,null,"Grimbold","Intel Core 2",3.8,1024,320,1149]
[null,null,"Kalvar","Intel Xeon",3,512,160,699]
[null,null,"Marvin","Intel Celeron",3,512,160,599]
[null,null,"Rohan","AMD Athlon64",3.5,512,160,589]
[null,null,"Sauron","Intel Xeon",2.5,256,180,339]

{"sheet":"Sheet2","index":22,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}