{"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&nbsp;aplikaci MS Excel"},"content":{"rendered":"\n<p>Dnes tu m\u00e1me dal\u0161\u00ed \u010dl\u00e1nek ze seri\u00e1l\u016f \u010dl\u00e1nku t\u00fdkaj\u00edc\u00edch se pr\u00e1ce s&nbsp;kancel\u00e1\u0159sk\u00fdm bal\u00ed\u010dkem<strong> Microsoft Office.<\/strong> Tento \u010dl\u00e1nek na t\u00e9ma <strong>\u201ePraktick\u00e9 pou\u017eit\u00ed funkce VYHLEDAT v&nbsp;aplikaci MS Excel\u201c<\/strong> napsal n\u00e1\u0161 zku\u0161en\u00fd lektor IT kurz\u016f <strong>Mgr. Zden\u011bk Kom\u00ednek<\/strong>, se kter\u00fdm se m\u016f\u017eete setkat na \u0161kolen\u00ed <strong>Efektivn\u00ed digit\u00e1ln\u00ed kancel\u00e1\u0159 \u010di MS Excel \u2013 st\u0159edn\u011b pokro\u010dil\u00ed\/pokro\u010dil\u00ed.&nbsp;<\/strong>Funkci <strong>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&nbsp;forem zvolit. Krat\u0161\u00ed maticovou formu doporu\u010dujeme nahrazovat bu\u010f funkc\u00ed <strong>SVYHLEDAT<\/strong>, nebo <strong>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&nbsp;dispozici t\u0159i argumenty: <strong>CO, HLEDAT<\/strong> a <strong>V\u00ddSLEDEK.<\/strong><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Funkce VYHLEDAT \u2013 P\u0159\u00edklad 1<\/h2>\n\n\n\n<p>Uka\u017eme si nejd\u0159\u00edve standardn\u00ed p\u0159\u00edklad pou\u017eit\u00ed vektorov\u00e9 formy funkce <strong>VYHLEDAT<\/strong>. Stejn\u00e9ho v\u00fdsledku lze v&nbsp;tomto p\u0159\u00edpad\u011b dos\u00e1hnout i&nbsp;pomoc\u00ed funkce <strong>SVYHLEDAT<\/strong>. V&nbsp;se\u0161it\u011b m\u00e1me tabulku s&nbsp;p\u0159ehledem v\u00fd\u0161ek slev v&nbsp;z\u00e1vislosti na po\u010dtu odebran\u00fdch kus\u016f v\u00fdrobk\u016f.<\/p>\n\n\n\n<p>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&nbsp;list\u011b by mohla vypadat nap\u0159\u00edklad takto.<\/p>\n\n\n\n<p>Do bu\u0148ky B12 jsme vlo\u017eili vzorec s&nbsp;funkc\u00ed <strong>VYHLEDAT<\/strong>, jeho\u017e z\u00e1pis m\u00e1 tvar.<\/p>\n\n\n\n<p>=VYHLEDAT(A12;A4:A9;B4:B9)<\/p>\n\n\n\n<p>Argumentem <strong>CO<\/strong> je obsah bu\u0148ky <strong>A12<\/strong>, co\u017e je po\u017eadovan\u00fd po\u010det kus\u016f. Argument <strong>HLEDAT<\/strong> pokr\u00fdv\u00e1 oblast bun\u011bk tabulky s&nbsp;po\u010dty kus\u016f (A4:A9). T\u0159et\u00ed argument <strong>V\u00ddSLEDEK<\/strong> obsahuje oblast tabulky se slevami (B4:B9). Funkce pracuje tak, \u017ee jestli\u017ee nenajde pro argument <strong>CO<\/strong> v&nbsp;oblasti <strong>HLEDAT<\/strong> p\u0159esnou shodu, pak pou\u017eije nejv\u011bt\u0161\u00ed z&nbsp;men\u0161\u00edch hodnot. Oblast hodnot <strong>HLEDAT<\/strong> p\u0159itom mus\u00ed b\u00fdt se\u0159azena vzestupn\u011b.<\/p>\n\n\n\n<p>Jenom pro zaj\u00edmavost uve\u010fme, jak by stejn\u00e1 situace byla \u0159e\u0161ena pomoc\u00ed funkce <strong>SVYHLEADAT<\/strong>. Pak by z\u00e1pis vzorce byl n\u00e1sleduj\u00edc\u00ed: =SVYHLEDAT(A12;A4:B9;2).<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Funkce VYHLEDAT \u2013 P\u0159\u00edklad 2<\/h2>\n\n\n\n<p>Druh\u00fd p\u0159\u00edklad popisuje situaci, kter\u00e1 by se \u0159e\u0161it funkc\u00ed <strong>SVYHLEDAT<\/strong> nedala. D\u016fvod je prost\u00fd. Seznam hodnot, ve kter\u00e9m budeme hledat, nen\u00ed v&nbsp;tabulce v&nbsp;prv\u00e9m sloupci zleva. V&nbsp;takov\u00fdch situac\u00edch se uplatn\u00ed v\u011bt\u0161\u00ed variabilita funkce <strong>VYHLEDAT<\/strong>. Ta je schopn\u00e1 hledat nejenom v&nbsp;libovoln\u00e9m sloupci, ale i&nbsp;libovoln\u00e9m \u0159\u00e1dku tabulky.<br>V&nbsp;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.&nbsp; Na&nbsp;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<p>Na jin\u00e9m list\u011b budeme z&nbsp;t\u00e9to tabulky pomoc\u00ed funkce <strong>VYHLEDAT<\/strong> ur\u010dovat jm\u00e9na zam\u011bstnanc\u016f podle zvolen\u00e9ho ID. Obr\u00e1zek ukazuje situaci.<\/p>\n\n\n\n<p>Jak je funkce sestaven\u00e1, jak\u00e9 m\u00e1 argumenty, je z\u0159ejm\u00e9 z&nbsp;n\u00e1sleduj\u00edc\u00edho obr\u00e1zku. P\u0159ipom\u00edn\u00e1me, \u017ee je p\u0159itom nutn\u00e9, aby oblast s&nbsp;hodnotami argumentu <strong>HLEDAT<\/strong> byla se\u0159azen\u00e1 vzestupn\u011b.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Funkce VYHLEDAT \u2013 P\u0159\u00edklad 3<\/h2>\n\n\n\n<p>Funkci <strong>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&nbsp;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>P\u0159i zad\u00e1n\u00ed po\u0159adov\u00e9ho \u010d\u00edsla tisk\u00e1rny se v&nbsp;sousedn\u00ed bu\u0148ce pomoc\u00ed funkce <strong>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<p>=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<p>V&nbsp;argumentu <strong>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&nbsp;odd\u011blen\u00e1 st\u0159edn\u00edky. Podobn\u011b v&nbsp;argumentu <strong>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&nbsp;textov\u00e9 \u0159et\u011bzce, jsou ohrani\u010den\u00e9 uvozovkami.<\/p>\n\n\n\n<p>Pokud V\u00e1s tato problematika zaj\u00edm\u00e1 v\u00edce, m\u016f\u017eete se p\u0159ihl\u00e1sit do kurzu <a href=\"http:\/\/moje-rekvalifikace.cz\/rekvalifikacni-kurzy\/pocitace-a-it\/#obsluha-osobniho-pocitace-word-excel\"><strong>MS Excel \u2013 st\u0159edn\u011b pokro\u010dil\u00ed\/pokro\u010dil\u00ed<\/strong> <\/a>nebo kurzu <strong>Efektivn\u00ed digit\u00e1ln\u00ed kancel\u00e1\u0159<\/strong>, kde&nbsp;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&nbsp;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":"<p>Dnes tu m\u00e1me dal\u0161\u00ed \u010dl\u00e1nek ze seri\u00e1l\u016f \u010dl\u00e1nku t\u00fdkaj\u00edc\u00edch se pr\u00e1ce s&nbsp;kancel\u00e1\u0159sk\u00fdm bal\u00ed\u010dkem Microsoft Office. Tento \u010dl\u00e1nek na t\u00e9ma \u201ePraktick\u00e9 pou\u017eit\u00ed funkce VYHLEDAT v&nbsp;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.&nbsp;Funkci VYHLEDAT lze pou\u017e\u00edt ve&#8230;<\/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],"class_list":["post-54","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-rekvalifikace","tag-funkce-vyhledat","tag-ms-excel"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.6 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Praktick\u00e9 pou\u017eit\u00ed funkce VYHLEDAT v aplikaci MS Excel &#187; 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 &#187; 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\/8bec9d8e71a8ff355e83527772a98edb\"},\"headline\":\"Praktick\u00e9 pou\u017eit\u00ed funkce VYHLEDAT v&nbsp;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 &#187; 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&nbsp;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\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"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\/8bec9d8e71a8ff355e83527772a98edb\",\"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 &#187; 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 &#187; 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\/8bec9d8e71a8ff355e83527772a98edb"},"headline":"Praktick\u00e9 pou\u017eit\u00ed funkce VYHLEDAT v&nbsp;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 &#187; 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&nbsp;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":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"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\/8bec9d8e71a8ff355e83527772a98edb","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}]}}