{"id":54,"date":"2016-09-04T00:00:00","date_gmt":"2016-09-03T22:00:00","guid":{"rendered":"https:\/\/centrum-vzdelavani.cz\/prakticke-pouziti-funkce-vyhledat-v-aplikaci-ms-excel\/"},"modified":"2021-08-25T00:29:39","modified_gmt":"2021-08-24T22:29:39","slug":"prakticke-pouziti-funkce-vyhledat-v-aplikaci-ms-excel","status":"publish","type":"post","link":"https:\/\/centrum-vzdelavani.cz\/prakticke-pouziti-funkce-vyhledat-v-aplikaci-ms-excel\/","title":{"rendered":"Praktick\u00e9 pou\u017eit\u00ed funkce VYHLEDAT v aplikaci MS Excel"},"content":{"rendered":"\n

Dnes tu m\u00e1me dal\u0161\u00ed \u010dl\u00e1nek ze seri\u00e1l\u016f \u010dl\u00e1nku t\u00fdkaj\u00edc\u00edch se pr\u00e1ce s kancel\u00e1\u0159sk\u00fdm bal\u00ed\u010dkem Microsoft Office.<\/strong> Tento \u010dl\u00e1nek na t\u00e9ma \u201ePraktick\u00e9 pou\u017eit\u00ed funkce VYHLEDAT v aplikaci MS Excel\u201c<\/strong> napsal n\u00e1\u0161 zku\u0161en\u00fd lektor IT kurz\u016f Mgr. Zden\u011bk Kom\u00ednek<\/strong>, se kter\u00fdm se m\u016f\u017eete setkat na \u0161kolen\u00ed Efektivn\u00ed digit\u00e1ln\u00ed kancel\u00e1\u0159 \u010di MS Excel \u2013 st\u0159edn\u011b pokro\u010dil\u00ed\/pokro\u010dil\u00ed. <\/strong>Funkci VYHLEDAT<\/strong> lze pou\u017e\u00edt ve dvou form\u00e1ch, ve vektorov\u00e9 a maticov\u00e9. P\u0159i vlo\u017een\u00ed funkce do bu\u0148ky je nutn\u00e9 jednu z forem zvolit. Krat\u0161\u00ed maticovou formu doporu\u010dujeme nahrazovat bu\u010f funkc\u00ed SVYHLEDAT<\/strong>, nebo VVYHLEDAT<\/strong>. Zaj\u00edmav\u011bj\u0161\u00ed u\u017eit\u00ed proto p\u0159in\u00e1\u0161\u00ed p\u0159edev\u0161\u00edm forma vektorov\u00e1, u kter\u00e9 jsou k dispozici t\u0159i argumenty: CO, HLEDAT<\/strong> a V\u00ddSLEDEK.<\/strong><\/p>\n\n\n\n

Funkce VYHLEDAT \u2013 P\u0159\u00edklad 1<\/h2>\n\n\n\n

Uka\u017eme si nejd\u0159\u00edve standardn\u00ed p\u0159\u00edklad pou\u017eit\u00ed vektorov\u00e9 formy funkce VYHLEDAT<\/strong>. Stejn\u00e9ho v\u00fdsledku lze v tomto p\u0159\u00edpad\u011b dos\u00e1hnout i pomoc\u00ed funkce SVYHLEDAT<\/strong>. V se\u0161it\u011b m\u00e1me tabulku s p\u0159ehledem v\u00fd\u0161ek slev v z\u00e1vislosti na po\u010dtu odebran\u00fdch kus\u016f v\u00fdrobk\u016f.<\/p>\n\n\n\n

Pot\u0159ebujeme vytvo\u0159it vzorec, kter\u00fd pomoc\u00ed t\u00e9to tabulky ur\u010d\u00ed podle zadan\u00e9ho po\u010dtu kus\u016f v\u00fd\u0161ku slevy, a kter\u00fd bychom pak mohli pou\u017e\u00edt pro n\u00e1sledn\u00fd v\u00fdpo\u010det celkov\u00e9 ceny. Situace v list\u011b by mohla vypadat nap\u0159\u00edklad takto.<\/p>\n\n\n\n

Do bu\u0148ky B12 jsme vlo\u017eili vzorec s funkc\u00ed VYHLEDAT<\/strong>, jeho\u017e z\u00e1pis m\u00e1 tvar.<\/p>\n\n\n\n

=VYHLEDAT(A12;A4:A9;B4:B9)<\/p>\n\n\n\n

Argumentem CO<\/strong> je obsah bu\u0148ky A12<\/strong>, co\u017e je po\u017eadovan\u00fd po\u010det kus\u016f. Argument HLEDAT<\/strong> pokr\u00fdv\u00e1 oblast bun\u011bk tabulky s po\u010dty kus\u016f (A4:A9). T\u0159et\u00ed argument V\u00ddSLEDEK<\/strong> obsahuje oblast tabulky se slevami (B4:B9). Funkce pracuje tak, \u017ee jestli\u017ee nenajde pro argument CO<\/strong> v oblasti HLEDAT<\/strong> p\u0159esnou shodu, pak pou\u017eije nejv\u011bt\u0161\u00ed z men\u0161\u00edch hodnot. Oblast hodnot HLEDAT<\/strong> p\u0159itom mus\u00ed b\u00fdt se\u0159azena vzestupn\u011b.<\/p>\n\n\n\n

Jenom pro zaj\u00edmavost uve\u010fme, jak by stejn\u00e1 situace byla \u0159e\u0161ena pomoc\u00ed funkce SVYHLEADAT<\/strong>. Pak by z\u00e1pis vzorce byl n\u00e1sleduj\u00edc\u00ed: =SVYHLEDAT(A12;A4:B9;2).<\/p>\n\n\n\n

Funkce VYHLEDAT \u2013 P\u0159\u00edklad 2<\/h2>\n\n\n\n

Druh\u00fd p\u0159\u00edklad popisuje situaci, kter\u00e1 by se \u0159e\u0161it funkc\u00ed SVYHLEDAT<\/strong> nedala. D\u016fvod je prost\u00fd. Seznam hodnot, ve kter\u00e9m budeme hledat, nen\u00ed v tabulce v prv\u00e9m sloupci zleva. V takov\u00fdch situac\u00edch se uplatn\u00ed v\u011bt\u0161\u00ed variabilita funkce VYHLEDAT<\/strong>. Ta je schopn\u00e1 hledat nejenom v libovoln\u00e9m sloupci, ale i libovoln\u00e9m \u0159\u00e1dku tabulky.
V na\u0161\u00ed uk\u00e1zce z\u016fstaneme u sloupc\u016f. Pokud by se ale jednalo o \u0159\u00e1dky, bylo by v\u0161e velmi podobn\u00e9.  Na jednom list\u011b budeme m\u00edt tabulku se seznamem zam\u011bstnanc\u016f, jak\u00e1 je vid\u011bt na obr\u00e1zku.<\/p>\n\n\n\n

Na jin\u00e9m list\u011b budeme z t\u00e9to tabulky pomoc\u00ed funkce VYHLEDAT<\/strong> ur\u010dovat jm\u00e9na zam\u011bstnanc\u016f podle zvolen\u00e9ho ID. Obr\u00e1zek ukazuje situaci.<\/p>\n\n\n\n

Jak je funkce sestaven\u00e1, jak\u00e9 m\u00e1 argumenty, je z\u0159ejm\u00e9 z n\u00e1sleduj\u00edc\u00edho obr\u00e1zku. P\u0159ipom\u00edn\u00e1me, \u017ee je p\u0159itom nutn\u00e9, aby oblast s hodnotami argumentu HLEDAT<\/strong> byla se\u0159azen\u00e1 vzestupn\u011b.<\/p>\n\n\n\n

Funkce VYHLEDAT \u2013 P\u0159\u00edklad 3<\/h2>\n\n\n\n

Funkci VYHLEDAT<\/strong> m\u016f\u017eeme tak\u00e9 pou\u017e\u00edt pro vyhled\u00e1n\u00ed ur\u010dit\u00fdch hodnot, kter\u00e9 p\u0159itom nejsou vlo\u017een\u00e9 nikam do bun\u011bk. Hodnoty toti\u017e m\u016f\u017eeme vypsat p\u0159\u00edmo do argument\u016f funkce. Nap\u0159\u00edklad pot\u0159ebujeme, aby p\u0159i zad\u00e1n\u00ed po\u0159adov\u00e9ho \u010d\u00edsla tisk\u00e1rny, se zobrazil cel\u00fd jej\u00ed n\u00e1zev. Situace by pak mohla vypadat jednodu\u0161e.<\/p>\n\n\n\n

P\u0159i zad\u00e1n\u00ed po\u0159adov\u00e9ho \u010d\u00edsla tisk\u00e1rny se v sousedn\u00ed bu\u0148ce pomoc\u00ed funkce VYHLEDAT<\/strong> zobraz\u00ed cel\u00fd n\u00e1zev tisk\u00e1rny. \u010c\u00edsla i n\u00e1zvy tisk\u00e1ren by p\u0159itom mohly b\u00fdt vepsan\u00e9 p\u0159\u00edmo do z\u00e1pisu funkce.<\/p>\n\n\n\n

=VYHLEDAT(A4;{1;2;3;4};{\u201eKyocera FS-6025MFP KX\u201c;\u201cCanon iR C3170 Class Driver\u201c;\u201cEpson ESC\/P V4 Class Driver\u201c;\u201cHP Color LaserJet 5550 PCL6 Class Driver\u201c})<\/p>\n\n\n\n

V argumentu HLEDAT<\/strong> jsou uveden\u00e1 \u010d\u00edsla tisk\u00e1ren: {1;2;3;4}. Mus\u00ed b\u00fdt p\u0159itom uzav\u0159en\u00e1 do slo\u017een\u00fdch z\u00e1vorek a odd\u011blen\u00e1 st\u0159edn\u00edky. Podobn\u011b v argumentu V\u00ddSLEDEK<\/strong> je seznam v\u0161ech n\u00e1zv\u016f: {\u201eKyocera FS-6025MFP KX\u201c;\u201cCanon iR C3170 Class Driver\u201c;\u201cEpson ESC\/P V4 Class Driver\u201c;\u201cHP Color LaserJet 5550 PCL6 Class Driver\u201c}. Proto\u017ee se jedn\u00e1 o textov\u00e9 \u0159et\u011bzce, jsou ohrani\u010den\u00e9 uvozovkami.<\/p>\n\n\n\n

Pokud V\u00e1s tato problematika zaj\u00edm\u00e1 v\u00edce, m\u016f\u017eete se p\u0159ihl\u00e1sit do kurzu MS Excel \u2013 st\u0159edn\u011b pokro\u010dil\u00ed\/pokro\u010dil\u00ed<\/strong> <\/a>nebo kurzu Efektivn\u00ed digit\u00e1ln\u00ed kancel\u00e1\u0159<\/strong>, kde je toto a obdobn\u00e1 t\u00e9mata prob\u00edr\u00e1na v\u00edce podrobn\u011b. Uk\u00e1\u017eeme V\u00e1m, jak zrychlit Va\u0161i pr\u00e1ci v Excelu pomoc\u00ed jednoduch\u00fdch efektivn\u00edch n\u00e1stroj\u016f, kter\u00e9 V\u00e1m u\u0161et\u0159\u00ed polovinu \u010dasu.<\/p>\n","protected":false},"excerpt":{"rendered":"

Dnes tu m\u00e1me dal\u0161\u00ed \u010dl\u00e1nek ze seri\u00e1l\u016f \u010dl\u00e1nku t\u00fdkaj\u00edc\u00edch se pr\u00e1ce s kancel\u00e1\u0159sk\u00fdm bal\u00ed\u010dkem Microsoft Office. Tento \u010dl\u00e1nek na t\u00e9ma \u201ePraktick\u00e9 pou\u017eit\u00ed funkce VYHLEDAT v aplikaci MS Excel\u201c napsal n\u00e1\u0161 zku\u0161en\u00fd lektor IT kurz\u016f Mgr. Zden\u011bk Kom\u00ednek, se kter\u00fdm se m\u016f\u017eete setkat na \u0161kolen\u00ed Efektivn\u00ed digit\u00e1ln\u00ed kancel\u00e1\u0159 \u010di MS Excel \u2013 st\u0159edn\u011b pokro\u010dil\u00ed\/pokro\u010dil\u00ed. Funkci VYHLEDAT lze pou\u017e\u00edt ve…<\/p>\n","protected":false},"author":1,"featured_media":1075,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[8],"tags":[23,21],"yoast_head":"\nPraktick\u00e9 pou\u017eit\u00ed funkce VYHLEDAT v aplikaci MS Excel » CENTRUM-VZD\u011aL\u00c1V\u00c1N\u00cd.CZ<\/title>\n<meta name=\"description\" content=\"Uk\u00e1\u017eeme si na n\u011bkolika p\u0159\u00edkladech praktick\u00e9 pou\u017eit\u00ed funkce VYHLEDAT v aplikaci MS Excel. Pokud V\u00e1s tato problematika zaj\u00edm\u00e1, tak se m\u016f\u017eete p\u0159ihl\u00e1sit do na\u0161eho kurzu.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/centrum-vzdelavani.cz\/prakticke-pouziti-funkce-vyhledat-v-aplikaci-ms-excel\/\" \/>\n<meta property=\"og:locale\" content=\"cs_CZ\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Praktick\u00e9 pou\u017eit\u00ed funkce VYHLEDAT v aplikaci MS Excel » CENTRUM-VZD\u011aL\u00c1V\u00c1N\u00cd.CZ\" \/>\n<meta property=\"og:description\" content=\"Uk\u00e1\u017eeme si na n\u011bkolika p\u0159\u00edkladech praktick\u00e9 pou\u017eit\u00ed funkce VYHLEDAT v aplikaci MS Excel. Pokud V\u00e1s tato problematika zaj\u00edm\u00e1, tak se m\u016f\u017eete p\u0159ihl\u00e1sit do na\u0161eho kurzu.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/centrum-vzdelavani.cz\/prakticke-pouziti-funkce-vyhledat-v-aplikaci-ms-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"CENTRUM-VZD\u011aL\u00c1V\u00c1N\u00cd.CZ\" \/>\n<meta property=\"article:published_time\" content=\"2016-09-03T22:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-08-24T22:29:39+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/centrum-vzdelavani.cz\/wp-content\/uploads\/2021\/08\/Excel-funkce-vyhledat-3.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"630\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Leopold Podmol\u00edk\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Napsal(a)\" \/>\n\t<meta name=\"twitter:data1\" content=\"Leopold Podmol\u00edk\" \/>\n\t<meta name=\"twitter:label2\" content=\"Odhadovan\u00e1 doba \u010dten\u00ed\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minuty\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/centrum-vzdelavani.cz\/prakticke-pouziti-funkce-vyhledat-v-aplikaci-ms-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/centrum-vzdelavani.cz\/prakticke-pouziti-funkce-vyhledat-v-aplikaci-ms-excel\/\"},\"author\":{\"name\":\"Leopold Podmol\u00edk\",\"@id\":\"https:\/\/centrum-vzdelavani.cz\/#\/schema\/person\/8c5fba9b887f2d368019e8e390f93469\"},\"headline\":\"Praktick\u00e9 pou\u017eit\u00ed funkce VYHLEDAT v aplikaci MS Excel\",\"datePublished\":\"2016-09-03T22:00:00+00:00\",\"dateModified\":\"2021-08-24T22:29:39+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/centrum-vzdelavani.cz\/prakticke-pouziti-funkce-vyhledat-v-aplikaci-ms-excel\/\"},\"wordCount\":844,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/centrum-vzdelavani.cz\/#organization\"},\"image\":{\"@id\":\"https:\/\/centrum-vzdelavani.cz\/prakticke-pouziti-funkce-vyhledat-v-aplikaci-ms-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/centrum-vzdelavani.cz\/wp-content\/uploads\/2021\/08\/Excel-funkce-vyhledat-3.jpg\",\"keywords\":[\"funkce VYHLEDAT\",\"MS Excel\"],\"articleSection\":[\"Rekvalifikace\"],\"inLanguage\":\"cs\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/centrum-vzdelavani.cz\/prakticke-pouziti-funkce-vyhledat-v-aplikaci-ms-excel\/\",\"url\":\"https:\/\/centrum-vzdelavani.cz\/prakticke-pouziti-funkce-vyhledat-v-aplikaci-ms-excel\/\",\"name\":\"Praktick\u00e9 pou\u017eit\u00ed funkce VYHLEDAT v aplikaci MS Excel » CENTRUM-VZD\u011aL\u00c1V\u00c1N\u00cd.CZ\",\"isPartOf\":{\"@id\":\"https:\/\/centrum-vzdelavani.cz\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/centrum-vzdelavani.cz\/prakticke-pouziti-funkce-vyhledat-v-aplikaci-ms-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/centrum-vzdelavani.cz\/prakticke-pouziti-funkce-vyhledat-v-aplikaci-ms-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/centrum-vzdelavani.cz\/wp-content\/uploads\/2021\/08\/Excel-funkce-vyhledat-3.jpg\",\"datePublished\":\"2016-09-03T22:00:00+00:00\",\"dateModified\":\"2021-08-24T22:29:39+00:00\",\"description\":\"Uk\u00e1\u017eeme si na n\u011bkolika p\u0159\u00edkladech praktick\u00e9 pou\u017eit\u00ed funkce VYHLEDAT v aplikaci MS Excel. Pokud V\u00e1s tato problematika zaj\u00edm\u00e1, tak se m\u016f\u017eete p\u0159ihl\u00e1sit do na\u0161eho kurzu.\",\"breadcrumb\":{\"@id\":\"https:\/\/centrum-vzdelavani.cz\/prakticke-pouziti-funkce-vyhledat-v-aplikaci-ms-excel\/#breadcrumb\"},\"inLanguage\":\"cs\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/centrum-vzdelavani.cz\/prakticke-pouziti-funkce-vyhledat-v-aplikaci-ms-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"cs\",\"@id\":\"https:\/\/centrum-vzdelavani.cz\/prakticke-pouziti-funkce-vyhledat-v-aplikaci-ms-excel\/#primaryimage\",\"url\":\"https:\/\/centrum-vzdelavani.cz\/wp-content\/uploads\/2021\/08\/Excel-funkce-vyhledat-3.jpg\",\"contentUrl\":\"https:\/\/centrum-vzdelavani.cz\/wp-content\/uploads\/2021\/08\/Excel-funkce-vyhledat-3.jpg\",\"width\":1200,\"height\":630,\"caption\":\"Excel-funkce-vyhledat\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/centrum-vzdelavani.cz\/prakticke-pouziti-funkce-vyhledat-v-aplikaci-ms-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Dom\u016f\",\"item\":\"https:\/\/centrum-vzdelavani.cz\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Praktick\u00e9 pou\u017eit\u00ed funkce VYHLEDAT v aplikaci MS Excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/centrum-vzdelavani.cz\/#website\",\"url\":\"https:\/\/centrum-vzdelavani.cz\/\",\"name\":\"CENTRUM-VZD\u011aL\u00c1V\u00c1N\u00cd.CZ\",\"description\":\"Va\u0161e m\u00edsto pro kurzy, \u0161kolen\u00ed a zkou\u0161ky\",\"publisher\":{\"@id\":\"https:\/\/centrum-vzdelavani.cz\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/centrum-vzdelavani.cz\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"cs\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/centrum-vzdelavani.cz\/#organization\",\"name\":\"Po\u010d\u00edta\u010dov\u00e1 slu\u017eba s.r.o.\",\"url\":\"https:\/\/centrum-vzdelavani.cz\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"cs\",\"@id\":\"https:\/\/centrum-vzdelavani.cz\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/centrum-vzdelavani.cz\/wp-content\/uploads\/2021\/08\/Centrum-Vzdelavani-logo-cerne.svg\",\"contentUrl\":\"https:\/\/centrum-vzdelavani.cz\/wp-content\/uploads\/2021\/08\/Centrum-Vzdelavani-logo-cerne.svg\",\"width\":\"1024\",\"height\":\"1024\",\"caption\":\"Po\u010d\u00edta\u010dov\u00e1 slu\u017eba s.r.o.\"},\"image\":{\"@id\":\"https:\/\/centrum-vzdelavani.cz\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/centrum-vzdelavani.cz\/#\/schema\/person\/8c5fba9b887f2d368019e8e390f93469\",\"name\":\"Leopold Podmol\u00edk\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"cs\",\"@id\":\"https:\/\/centrum-vzdelavani.cz\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/0abff6e4d481e2d6d49ccae2d95ff2ba?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/0abff6e4d481e2d6d49ccae2d95ff2ba?s=96&d=mm&r=g\",\"caption\":\"Leopold Podmol\u00edk\"},\"description\":\"Lektor, Tester ECDL a CTO Visionslabs\",\"sameAs\":[\"https:\/\/visionslabs.io\"],\"url\":\"https:\/\/centrum-vzdelavani.cz\/author\/vl-podmolik\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Praktick\u00e9 pou\u017eit\u00ed funkce VYHLEDAT v aplikaci MS Excel » CENTRUM-VZD\u011aL\u00c1V\u00c1N\u00cd.CZ","description":"Uk\u00e1\u017eeme si na n\u011bkolika p\u0159\u00edkladech praktick\u00e9 pou\u017eit\u00ed funkce VYHLEDAT v aplikaci MS Excel. Pokud V\u00e1s tato problematika zaj\u00edm\u00e1, tak se m\u016f\u017eete p\u0159ihl\u00e1sit do na\u0161eho kurzu.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/centrum-vzdelavani.cz\/prakticke-pouziti-funkce-vyhledat-v-aplikaci-ms-excel\/","og_locale":"cs_CZ","og_type":"article","og_title":"Praktick\u00e9 pou\u017eit\u00ed funkce VYHLEDAT v aplikaci MS Excel » CENTRUM-VZD\u011aL\u00c1V\u00c1N\u00cd.CZ","og_description":"Uk\u00e1\u017eeme si na n\u011bkolika p\u0159\u00edkladech praktick\u00e9 pou\u017eit\u00ed funkce VYHLEDAT v aplikaci MS Excel. Pokud V\u00e1s tato problematika zaj\u00edm\u00e1, tak se m\u016f\u017eete p\u0159ihl\u00e1sit do na\u0161eho kurzu.","og_url":"https:\/\/centrum-vzdelavani.cz\/prakticke-pouziti-funkce-vyhledat-v-aplikaci-ms-excel\/","og_site_name":"CENTRUM-VZD\u011aL\u00c1V\u00c1N\u00cd.CZ","article_published_time":"2016-09-03T22:00:00+00:00","article_modified_time":"2021-08-24T22:29:39+00:00","og_image":[{"width":1200,"height":630,"url":"https:\/\/centrum-vzdelavani.cz\/wp-content\/uploads\/2021\/08\/Excel-funkce-vyhledat-3.jpg","type":"image\/jpeg"}],"author":"Leopold Podmol\u00edk","twitter_card":"summary_large_image","twitter_misc":{"Napsal(a)":"Leopold Podmol\u00edk","Odhadovan\u00e1 doba \u010dten\u00ed":"3 minuty"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/centrum-vzdelavani.cz\/prakticke-pouziti-funkce-vyhledat-v-aplikaci-ms-excel\/#article","isPartOf":{"@id":"https:\/\/centrum-vzdelavani.cz\/prakticke-pouziti-funkce-vyhledat-v-aplikaci-ms-excel\/"},"author":{"name":"Leopold Podmol\u00edk","@id":"https:\/\/centrum-vzdelavani.cz\/#\/schema\/person\/8c5fba9b887f2d368019e8e390f93469"},"headline":"Praktick\u00e9 pou\u017eit\u00ed funkce VYHLEDAT v aplikaci MS Excel","datePublished":"2016-09-03T22:00:00+00:00","dateModified":"2021-08-24T22:29:39+00:00","mainEntityOfPage":{"@id":"https:\/\/centrum-vzdelavani.cz\/prakticke-pouziti-funkce-vyhledat-v-aplikaci-ms-excel\/"},"wordCount":844,"commentCount":0,"publisher":{"@id":"https:\/\/centrum-vzdelavani.cz\/#organization"},"image":{"@id":"https:\/\/centrum-vzdelavani.cz\/prakticke-pouziti-funkce-vyhledat-v-aplikaci-ms-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/centrum-vzdelavani.cz\/wp-content\/uploads\/2021\/08\/Excel-funkce-vyhledat-3.jpg","keywords":["funkce VYHLEDAT","MS Excel"],"articleSection":["Rekvalifikace"],"inLanguage":"cs"},{"@type":"WebPage","@id":"https:\/\/centrum-vzdelavani.cz\/prakticke-pouziti-funkce-vyhledat-v-aplikaci-ms-excel\/","url":"https:\/\/centrum-vzdelavani.cz\/prakticke-pouziti-funkce-vyhledat-v-aplikaci-ms-excel\/","name":"Praktick\u00e9 pou\u017eit\u00ed funkce VYHLEDAT v aplikaci MS Excel » CENTRUM-VZD\u011aL\u00c1V\u00c1N\u00cd.CZ","isPartOf":{"@id":"https:\/\/centrum-vzdelavani.cz\/#website"},"primaryImageOfPage":{"@id":"https:\/\/centrum-vzdelavani.cz\/prakticke-pouziti-funkce-vyhledat-v-aplikaci-ms-excel\/#primaryimage"},"image":{"@id":"https:\/\/centrum-vzdelavani.cz\/prakticke-pouziti-funkce-vyhledat-v-aplikaci-ms-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/centrum-vzdelavani.cz\/wp-content\/uploads\/2021\/08\/Excel-funkce-vyhledat-3.jpg","datePublished":"2016-09-03T22:00:00+00:00","dateModified":"2021-08-24T22:29:39+00:00","description":"Uk\u00e1\u017eeme si na n\u011bkolika p\u0159\u00edkladech praktick\u00e9 pou\u017eit\u00ed funkce VYHLEDAT v aplikaci MS Excel. Pokud V\u00e1s tato problematika zaj\u00edm\u00e1, tak se m\u016f\u017eete p\u0159ihl\u00e1sit do na\u0161eho kurzu.","breadcrumb":{"@id":"https:\/\/centrum-vzdelavani.cz\/prakticke-pouziti-funkce-vyhledat-v-aplikaci-ms-excel\/#breadcrumb"},"inLanguage":"cs","potentialAction":[{"@type":"ReadAction","target":["https:\/\/centrum-vzdelavani.cz\/prakticke-pouziti-funkce-vyhledat-v-aplikaci-ms-excel\/"]}]},{"@type":"ImageObject","inLanguage":"cs","@id":"https:\/\/centrum-vzdelavani.cz\/prakticke-pouziti-funkce-vyhledat-v-aplikaci-ms-excel\/#primaryimage","url":"https:\/\/centrum-vzdelavani.cz\/wp-content\/uploads\/2021\/08\/Excel-funkce-vyhledat-3.jpg","contentUrl":"https:\/\/centrum-vzdelavani.cz\/wp-content\/uploads\/2021\/08\/Excel-funkce-vyhledat-3.jpg","width":1200,"height":630,"caption":"Excel-funkce-vyhledat"},{"@type":"BreadcrumbList","@id":"https:\/\/centrum-vzdelavani.cz\/prakticke-pouziti-funkce-vyhledat-v-aplikaci-ms-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Dom\u016f","item":"https:\/\/centrum-vzdelavani.cz\/"},{"@type":"ListItem","position":2,"name":"Praktick\u00e9 pou\u017eit\u00ed funkce VYHLEDAT v aplikaci MS Excel"}]},{"@type":"WebSite","@id":"https:\/\/centrum-vzdelavani.cz\/#website","url":"https:\/\/centrum-vzdelavani.cz\/","name":"CENTRUM-VZD\u011aL\u00c1V\u00c1N\u00cd.CZ","description":"Va\u0161e m\u00edsto pro kurzy, \u0161kolen\u00ed a zkou\u0161ky","publisher":{"@id":"https:\/\/centrum-vzdelavani.cz\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/centrum-vzdelavani.cz\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"cs"},{"@type":"Organization","@id":"https:\/\/centrum-vzdelavani.cz\/#organization","name":"Po\u010d\u00edta\u010dov\u00e1 slu\u017eba s.r.o.","url":"https:\/\/centrum-vzdelavani.cz\/","logo":{"@type":"ImageObject","inLanguage":"cs","@id":"https:\/\/centrum-vzdelavani.cz\/#\/schema\/logo\/image\/","url":"https:\/\/centrum-vzdelavani.cz\/wp-content\/uploads\/2021\/08\/Centrum-Vzdelavani-logo-cerne.svg","contentUrl":"https:\/\/centrum-vzdelavani.cz\/wp-content\/uploads\/2021\/08\/Centrum-Vzdelavani-logo-cerne.svg","width":"1024","height":"1024","caption":"Po\u010d\u00edta\u010dov\u00e1 slu\u017eba s.r.o."},"image":{"@id":"https:\/\/centrum-vzdelavani.cz\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/centrum-vzdelavani.cz\/#\/schema\/person\/8c5fba9b887f2d368019e8e390f93469","name":"Leopold Podmol\u00edk","image":{"@type":"ImageObject","inLanguage":"cs","@id":"https:\/\/centrum-vzdelavani.cz\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/0abff6e4d481e2d6d49ccae2d95ff2ba?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/0abff6e4d481e2d6d49ccae2d95ff2ba?s=96&d=mm&r=g","caption":"Leopold Podmol\u00edk"},"description":"Lektor, Tester ECDL a CTO Visionslabs","sameAs":["https:\/\/visionslabs.io"],"url":"https:\/\/centrum-vzdelavani.cz\/author\/vl-podmolik\/"}]}},"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"https:\/\/centrum-vzdelavani.cz\/wp-content\/uploads\/2021\/08\/Excel-funkce-vyhledat-3.jpg","_links":{"self":[{"href":"https:\/\/centrum-vzdelavani.cz\/wp-json\/wp\/v2\/posts\/54"}],"collection":[{"href":"https:\/\/centrum-vzdelavani.cz\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/centrum-vzdelavani.cz\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/centrum-vzdelavani.cz\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/centrum-vzdelavani.cz\/wp-json\/wp\/v2\/comments?post=54"}],"version-history":[{"count":0,"href":"https:\/\/centrum-vzdelavani.cz\/wp-json\/wp\/v2\/posts\/54\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/centrum-vzdelavani.cz\/wp-json\/wp\/v2\/media\/1075"}],"wp:attachment":[{"href":"https:\/\/centrum-vzdelavani.cz\/wp-json\/wp\/v2\/media?parent=54"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/centrum-vzdelavani.cz\/wp-json\/wp\/v2\/categories?post=54"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/centrum-vzdelavani.cz\/wp-json\/wp\/v2\/tags?post=54"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}