{"id":435,"date":"2019-04-21T07:44:00","date_gmt":"2019-04-21T07:44:00","guid":{"rendered":"http:\/\/blog.eticsolutions.ro\/?p=435"},"modified":"2020-01-20T06:54:40","modified_gmt":"2020-01-20T06:54:40","slug":"exemplu-de-utilizare-a-functiei-vlookup","status":"publish","type":"post","link":"https:\/\/eticsolutions.ro\/blog\/cursuri-excel\/cursuri-excel-gratuite\/exemplu-de-utilizare-a-functiei-vlookup\/","title":{"rendered":"Exemplu de utilizare a functiei VLOOKUP"},"content":{"rendered":"<p>Se da o baza de date ce contine informatii primare referitoare la angajatii unei companii. Informatiile trebuie utilizate pentru completarea automata a unei Fise periodice de evaluare, in functie de Nume si prenume salariat. Grila de evaluare este disponibila in foaia de lucru <strong>grila evaluare.<\/strong><\/p>\n<p style=\"text-align: justify;\">Numele si prenumele salariatului pentru care trebuie completata Fisa de evaluare este ales dintr-o lista, construita cu ajutorul unei validari simple (Vezi si articolul <a href=\"http:\/\/eticsolutions.ro\/blog\/cursuri-excel\/cursuri-excel-gratuite\/cum-se-valideaza-in-excel-datele-dupa-o-lista-predefinita-2\/\">Cum se valideaza in Excel datele dupa o lista predefinita (2)<\/a>).<\/p>\n<p style=\"text-align: justify;\"><strong>Pentru completarea formularului, vom utiliza functia VLOOKUP, cu urmatoarea sintaxa:<\/strong><\/p>\n<p style=\"text-align: justify;\"><strong>=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])<\/strong><\/p>\n<p style=\"text-align: justify;\">Argumentele functiei VLOOKUP:<\/p>\n<ul style=\"text-align: justify;\">\n<li><strong>lookup_value<\/strong> este valoarea catre trebuie cautata in baza de date de angajati (din worksheet-ul BD angajati)\n<ul>\n<li>lookup_value poate fi referinta la o celula, o valoare (numerica, text &#8211; in cel din urma caz textul trebuie marcat intre ghilimele) sau rezultatul altei functii<\/li>\n<\/ul>\n<\/li>\n<li><strong>table_array<\/strong> este tabelul (baza de date) unde este cautata valoarea reprezentata de lookup_value\n<ul>\n<li>cautarea se face <strong>prin definitie<\/strong> in prima coloana a bazei de date identificate de table_array ca grup de celule<\/li>\n<li>de exemplu, daca table_array este intervalul de celule A2:B6 si lookup_value este 2, functia VLOOKUP va cauta valoarea 2 in intervalul de celule A2:A6<\/li>\n<\/ul>\n<\/li>\n<li><strong>col_index_num<\/strong> este indicativul coloanei de pe care functia VLOOKUP intoarce rezultatul si se identifica printr-un numar (1, 2, etc.)\n<ul>\n<li>valoarea lui col_index_num trebuie sa fie mai mica sau egala cu numarul de coloane al bazei de date identificate prin <strong>table_array<\/strong><\/li>\n<\/ul>\n<\/li>\n<li><strong>range_lookup<\/strong> este un argument optional si poate lua valoarea TRUE (1) sau FALSE (0), astfel:\n<ul>\n<li>TRUE &#8211; cauta cea mai apropiata valoare de <strong>lookup_value<\/strong> dar mai mica decat aceasta<\/li>\n<li>FALSE &#8211; cauta <strong>exact<\/strong> valoarea identificata prin <strong>lookup_value<\/strong><\/li>\n<li>in cazul in care argumentul <strong>range_lookup <\/strong>este omis, acesta este automat considerat ca fiind TRUE<\/li>\n<li>functia VLOOKUP cu argumentul TRUE intoarce rezultate corecte <strong>doar<\/strong> daca baza de date in care se cauta (<strong>table_array<\/strong>) este sortata (crescator\/descrescator, in functie de necesitati) dupa prima coloana (cea in care este cautata <strong>lookup_value<\/strong>)<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><strong>In cazul in care valoarea cautata nu este gasita in prima coloana din baza de date, functia VLOOKUP intoarce rezultatul #N\/A.<\/strong><\/p>\n<p style=\"text-align: justify;\"><span style=\"color: #800000;\"><strong>Remember! <\/strong><\/span><strong>Pentru versiunea localizata in limba romana, argumentele functiei sunt despartite de punct si virgula (;).<\/strong><\/p>\n<p style=\"text-align: justify;\"><span style=\"color: #800000;\"><strong>PASUL 1<\/strong><\/span><\/p>\n<p style=\"text-align: justify;\">In worksheet-ul <strong>Fisa evaluare<\/strong>, alegeti din lista numele si prenumele angajatului.<\/p>\n<p style=\"text-align: justify;\">Utilizati functia VLOOKUP pentru completarea celulei B7:<\/p>\n<p style=\"text-align: justify;\">=VLOOKUP(B$6,&#8217;BD angajati&#8217;!$A$1:$O$25,2,FALSE)<\/p>\n<p style=\"text-align: justify;\">care se citeste astfel:<\/p>\n<p style=\"text-align: justify;\">Se cauta valoarea din B6 pe prima coloana din tabelul A1:M25 din worksheet-ul BD angajati si, acolo unde este gasita (prima ocurenta!), intoarce valoarea de pe acelasi rand dar din a doua coloana a tabelului. Cautarea se face <strong>exact<\/strong> (argumentul range_lookup este FALSE).<\/p>\n<p style=\"text-align: justify;\"><strong><span style=\"color: #800000;\">Tips:<\/span><\/strong><\/p>\n<p style=\"text-align: justify;\">&#8211; cand trebuie sa introduceti <strong>table_array<\/strong> in functie, dati pur si simplu click pe worksheet-ul BD angajati si selectati tabelul; scrieti apoi separatorul de argument (,) si apoi completati in continuare functia<\/p>\n<p style=\"text-align: justify;\">&#8211; se observa ca referinta la tabel este &#8220;inghetata&#8221; (semnul dolar pus in fata indicativelor de rand, respectiv coloana), la fel si indicativul de rand al valorii de cautat &#8211; puteti copia astfel formula mai jos fara a modifica referinta la celule;&nbsp; pentru completarea celorlalte campuri din FISA DE EVALUARE, va trebui sa modificati apoi doar <strong>col_index_num<\/strong><\/p>\n<p style=\"text-align: justify;\"><span style=\"color: #800000;\"><strong>PASUL 2<\/strong><\/span><\/p>\n<p style=\"text-align: justify;\">Copiati formula si in celulele B8, B9, B10, B12 si B13 si modificati in fiecare din ele valoarea <strong>col_index_num<\/strong>.<\/p>\n<p style=\"text-align: justify;\"><strong><span style=\"color: #800000;\">PASUL 3<\/span><\/strong><\/p>\n<p style=\"text-align: justify;\">Pentru completarea celulei B14:<\/p>\n<ul style=\"text-align: justify;\">\n<li>analizati mai intai grila de evaluare (din worksheet-ul <strong>grila evaluare<\/strong>)\n<ul>\n<li>rezultat nesatisfacator &#8211; orice punctaj <strong>mai mic<\/strong> de 45<\/li>\n<li>rezultat satisfacator &#8211; punctaj&nbsp;<strong>mai mare sau egal<\/strong> cu 45 si&nbsp;<strong>mai mic de 70<\/strong><\/li>\n<li>rezultat bun &#8211; punctaj <strong>mai mare sau egal<\/strong> cu 70 si&nbsp;<strong>mai mic de 85<\/strong><\/li>\n<li>rezultat foarte bun &#8211; orice punctaj <strong>mai mare sau egal<\/strong> cu 85<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p style=\"text-align: justify;\">Utilizati functia VLOOKUP cu <strong>range_lookup<\/strong> = TRUE pentru a completa calificativul (celula B14 din worksheetul <strong>Fisa evaluare<\/strong>).<\/p>\n<p style=\"text-align: justify;\">=VLOOKUP(B13,&#8217;grila evaluare&#8217;!A3:B7,2,TRUE)<\/p>\n<p style=\"text-align: justify;\">care se citeste astfel:<\/p>\n<p style=\"text-align: justify;\">Cauta pe prima coloana din tabelul A3:B7 din worksheet-ul <strong>grila evaluare<\/strong> cea mai apropiata valoare de rezultatul inscris in B13, <strong>DAR<\/strong> <strong>mai mica decat<\/strong> B13, si intoarce valoarea de pe acelasi rand, dar de pe coloana 2 din tabelul respectiv<\/p>\n<p style=\"text-align: justify;\">Va invit sa refaceti exercitiul, utilizand fisierul de lucru de mai jos. Spor la treaba!<\/p>\n<h6><div class='afi-document'><div class='afi-document-icon'><a href='http:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2015\/04\/Fisier-de-lucru_Functia-Vlookup.xlsx'><img src='http:\/\/eticsolutions.ro\/blog\/wp-content\/plugins\/attachment-file-icons\/mime\/xls-icon.png'\/><\/a><\/div><div class='afi-document-link'><a href=\"http:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2015\/04\/Fisier-de-lucru_Functia-Vlookup.xlsx\">Fisier de lucru_Functia Vlookup<\/a><\/div><\/div><div class='afi-clear'><\/div><\/h6>\n","protected":false},"excerpt":{"rendered":"<p>Se da o baza de date ce contine informatii primare referitoare la angajatii unei companii. Informatiile trebuie utilizate pentru completarea automata a unei Fise periodice de evaluare, in functie de Nume si prenume salariat. Grila de evaluare este disponibila in foaia de lucru grila evaluare. Numele si prenumele salariatului pentru care trebuie completata Fisa de [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_themeisle_gutenberg_block_has_review":false,"footnotes":""},"categories":[16],"tags":[90,101],"class_list":["post-435","post","type-post","status-publish","format-standard","hentry","category-cursuri-excel-gratuite","tag-cursuri-excel-gratuite","tag-utilizare-functia-vlookup"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 4.9.9 - aioseo.com -->\n\t<meta name=\"description\" content=\"Se da o baza de date ce contine informatii primare referitoare la angajatii unei companii. Informatiile trebuie utilizate pentru completarea automata a unei Fise periodice de evaluare, in functie de Nume si prenume salariat. Grila de evaluare este disponibila in foaia de lucru grila evaluare. Numele si prenumele salariatului pentru care trebuie completata Fisa de\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<link rel=\"canonical\" href=\"https:\/\/eticsolutions.ro\/blog\/cursuri-excel\/cursuri-excel-gratuite\/exemplu-de-utilizare-a-functiei-vlookup\/\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 4.9.9\" \/>\n\t\t<meta property=\"og:locale\" content=\"en_US\" \/>\n\t\t<meta property=\"og:site_name\" content=\"-\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"Exemplu de utilizare a functiei VLOOKUP -\" \/>\n\t\t<meta property=\"og:description\" content=\"Se da o baza de date ce contine informatii primare referitoare la angajatii unei companii. Informatiile trebuie utilizate pentru completarea automata a unei Fise periodice de evaluare, in functie de Nume si prenume salariat. Grila de evaluare este disponibila in foaia de lucru grila evaluare. Numele si prenumele salariatului pentru care trebuie completata Fisa de\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/eticsolutions.ro\/blog\/cursuri-excel\/cursuri-excel-gratuite\/exemplu-de-utilizare-a-functiei-vlookup\/\" \/>\n\t\t<meta property=\"og:image\" content=\"https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2015\/03\/SIGLA-BUNA-150x150.jpg\" \/>\n\t\t<meta property=\"og:image:secure_url\" content=\"https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2015\/03\/SIGLA-BUNA-150x150.jpg\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2019-04-21T07:44:00+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2020-01-20T06:54:40+00:00\" \/>\n\t\t<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n\t\t<meta name=\"twitter:title\" content=\"Exemplu de utilizare a functiei VLOOKUP -\" \/>\n\t\t<meta name=\"twitter:description\" content=\"Se da o baza de date ce contine informatii primare referitoare la angajatii unei companii. Informatiile trebuie utilizate pentru completarea automata a unei Fise periodice de evaluare, in functie de Nume si prenume salariat. Grila de evaluare este disponibila in foaia de lucru grila evaluare. Numele si prenumele salariatului pentru care trebuie completata Fisa de\" \/>\n\t\t<meta name=\"twitter:image\" content=\"http:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2015\/03\/SIGLA-BUNA-150x150.jpg\" \/>\n\t\t<script type=\"application\/ld+json\" class=\"aioseo-schema\">\n\t\t\t{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"BlogPosting\",\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/cursuri-excel\\\/cursuri-excel-gratuite\\\/exemplu-de-utilizare-a-functiei-vlookup\\\/#blogposting\",\"name\":\"Exemplu de utilizare a functiei VLOOKUP -\",\"headline\":\"Exemplu de utilizare a functiei VLOOKUP\",\"author\":{\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/author\\\/#author\"},\"publisher\":{\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/#organization\"},\"image\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/wp-content\\\/uploads\\\/2015\\\/03\\\/SIGLA-BUNA-150x150.jpg\",\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/#articleImage\",\"width\":150,\"height\":150},\"datePublished\":\"2019-04-21T07:44:00+00:00\",\"dateModified\":\"2020-01-20T06:54:40+00:00\",\"inLanguage\":\"en-US\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/cursuri-excel\\\/cursuri-excel-gratuite\\\/exemplu-de-utilizare-a-functiei-vlookup\\\/#webpage\"},\"isPartOf\":{\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/cursuri-excel\\\/cursuri-excel-gratuite\\\/exemplu-de-utilizare-a-functiei-vlookup\\\/#webpage\"},\"articleSection\":\"Cursuri Excel gratuite, cursuri excel gratuite, utilizare functia VLOOKUP\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/cursuri-excel\\\/cursuri-excel-gratuite\\\/exemplu-de-utilizare-a-functiei-vlookup\\\/#breadcrumblist\",\"itemListElement\":[{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog#listItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/category\\\/cursuri-excel\\\/#listItem\",\"name\":\"Cursuri Excel\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/category\\\/cursuri-excel\\\/#listItem\",\"position\":2,\"name\":\"Cursuri Excel\",\"item\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/category\\\/cursuri-excel\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/category\\\/cursuri-excel\\\/cursuri-excel-gratuite\\\/#listItem\",\"name\":\"Cursuri Excel gratuite\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog#listItem\",\"name\":\"Home\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/category\\\/cursuri-excel\\\/cursuri-excel-gratuite\\\/#listItem\",\"position\":3,\"name\":\"Cursuri Excel gratuite\",\"item\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/category\\\/cursuri-excel\\\/cursuri-excel-gratuite\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/cursuri-excel\\\/cursuri-excel-gratuite\\\/exemplu-de-utilizare-a-functiei-vlookup\\\/#listItem\",\"name\":\"Exemplu de utilizare a functiei VLOOKUP\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/category\\\/cursuri-excel\\\/#listItem\",\"name\":\"Cursuri Excel\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/cursuri-excel\\\/cursuri-excel-gratuite\\\/exemplu-de-utilizare-a-functiei-vlookup\\\/#listItem\",\"position\":4,\"name\":\"Exemplu de utilizare a functiei VLOOKUP\",\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/category\\\/cursuri-excel\\\/cursuri-excel-gratuite\\\/#listItem\",\"name\":\"Cursuri Excel gratuite\"}}]},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/#organization\",\"url\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/wp-content\\\/uploads\\\/2015\\\/03\\\/SIGLA-BUNA-150x150.jpg\",\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/cursuri-excel\\\/cursuri-excel-gratuite\\\/exemplu-de-utilizare-a-functiei-vlookup\\\/#organizationLogo\",\"width\":150,\"height\":150},\"image\":{\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/cursuri-excel\\\/cursuri-excel-gratuite\\\/exemplu-de-utilizare-a-functiei-vlookup\\\/#organizationLogo\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/author\\\/#author\",\"url\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/author\\\/\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/cursuri-excel\\\/cursuri-excel-gratuite\\\/exemplu-de-utilizare-a-functiei-vlookup\\\/#webpage\",\"url\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/cursuri-excel\\\/cursuri-excel-gratuite\\\/exemplu-de-utilizare-a-functiei-vlookup\\\/\",\"name\":\"Exemplu de utilizare a functiei VLOOKUP -\",\"description\":\"Se da o baza de date ce contine informatii primare referitoare la angajatii unei companii. Informatiile trebuie utilizate pentru completarea automata a unei Fise periodice de evaluare, in functie de Nume si prenume salariat. Grila de evaluare este disponibila in foaia de lucru grila evaluare. Numele si prenumele salariatului pentru care trebuie completata Fisa de\",\"inLanguage\":\"en-US\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/#website\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/cursuri-excel\\\/cursuri-excel-gratuite\\\/exemplu-de-utilizare-a-functiei-vlookup\\\/#breadcrumblist\"},\"author\":{\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/author\\\/#author\"},\"creator\":{\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/author\\\/#author\"},\"datePublished\":\"2019-04-21T07:44:00+00:00\",\"dateModified\":\"2020-01-20T06:54:40+00:00\"},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/\",\"inLanguage\":\"en-US\",\"publisher\":{\"@id\":\"https:\\\/\\\/eticsolutions.ro\\\/blog\\\/#organization\"}}]}\n\t\t<\/script>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"Exemplu de utilizare a functiei VLOOKUP -","description":"Se da o baza de date ce contine informatii primare referitoare la angajatii unei companii. Informatiile trebuie utilizate pentru completarea automata a unei Fise periodice de evaluare, in functie de Nume si prenume salariat. Grila de evaluare este disponibila in foaia de lucru grila evaluare. Numele si prenumele salariatului pentru care trebuie completata Fisa de","canonical_url":"https:\/\/eticsolutions.ro\/blog\/cursuri-excel\/cursuri-excel-gratuite\/exemplu-de-utilizare-a-functiei-vlookup\/","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"BlogPosting","@id":"https:\/\/eticsolutions.ro\/blog\/cursuri-excel\/cursuri-excel-gratuite\/exemplu-de-utilizare-a-functiei-vlookup\/#blogposting","name":"Exemplu de utilizare a functiei VLOOKUP -","headline":"Exemplu de utilizare a functiei VLOOKUP","author":{"@id":"https:\/\/eticsolutions.ro\/blog\/author\/#author"},"publisher":{"@id":"https:\/\/eticsolutions.ro\/blog\/#organization"},"image":{"@type":"ImageObject","url":"https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2015\/03\/SIGLA-BUNA-150x150.jpg","@id":"https:\/\/eticsolutions.ro\/blog\/#articleImage","width":150,"height":150},"datePublished":"2019-04-21T07:44:00+00:00","dateModified":"2020-01-20T06:54:40+00:00","inLanguage":"en-US","mainEntityOfPage":{"@id":"https:\/\/eticsolutions.ro\/blog\/cursuri-excel\/cursuri-excel-gratuite\/exemplu-de-utilizare-a-functiei-vlookup\/#webpage"},"isPartOf":{"@id":"https:\/\/eticsolutions.ro\/blog\/cursuri-excel\/cursuri-excel-gratuite\/exemplu-de-utilizare-a-functiei-vlookup\/#webpage"},"articleSection":"Cursuri Excel gratuite, cursuri excel gratuite, utilizare functia VLOOKUP"},{"@type":"BreadcrumbList","@id":"https:\/\/eticsolutions.ro\/blog\/cursuri-excel\/cursuri-excel-gratuite\/exemplu-de-utilizare-a-functiei-vlookup\/#breadcrumblist","itemListElement":[{"@type":"ListItem","@id":"https:\/\/eticsolutions.ro\/blog#listItem","position":1,"name":"Home","item":"https:\/\/eticsolutions.ro\/blog","nextItem":{"@type":"ListItem","@id":"https:\/\/eticsolutions.ro\/blog\/category\/cursuri-excel\/#listItem","name":"Cursuri Excel"}},{"@type":"ListItem","@id":"https:\/\/eticsolutions.ro\/blog\/category\/cursuri-excel\/#listItem","position":2,"name":"Cursuri Excel","item":"https:\/\/eticsolutions.ro\/blog\/category\/cursuri-excel\/","nextItem":{"@type":"ListItem","@id":"https:\/\/eticsolutions.ro\/blog\/category\/cursuri-excel\/cursuri-excel-gratuite\/#listItem","name":"Cursuri Excel gratuite"},"previousItem":{"@type":"ListItem","@id":"https:\/\/eticsolutions.ro\/blog#listItem","name":"Home"}},{"@type":"ListItem","@id":"https:\/\/eticsolutions.ro\/blog\/category\/cursuri-excel\/cursuri-excel-gratuite\/#listItem","position":3,"name":"Cursuri Excel gratuite","item":"https:\/\/eticsolutions.ro\/blog\/category\/cursuri-excel\/cursuri-excel-gratuite\/","nextItem":{"@type":"ListItem","@id":"https:\/\/eticsolutions.ro\/blog\/cursuri-excel\/cursuri-excel-gratuite\/exemplu-de-utilizare-a-functiei-vlookup\/#listItem","name":"Exemplu de utilizare a functiei VLOOKUP"},"previousItem":{"@type":"ListItem","@id":"https:\/\/eticsolutions.ro\/blog\/category\/cursuri-excel\/#listItem","name":"Cursuri Excel"}},{"@type":"ListItem","@id":"https:\/\/eticsolutions.ro\/blog\/cursuri-excel\/cursuri-excel-gratuite\/exemplu-de-utilizare-a-functiei-vlookup\/#listItem","position":4,"name":"Exemplu de utilizare a functiei VLOOKUP","previousItem":{"@type":"ListItem","@id":"https:\/\/eticsolutions.ro\/blog\/category\/cursuri-excel\/cursuri-excel-gratuite\/#listItem","name":"Cursuri Excel gratuite"}}]},{"@type":"Organization","@id":"https:\/\/eticsolutions.ro\/blog\/#organization","url":"https:\/\/eticsolutions.ro\/blog\/","logo":{"@type":"ImageObject","url":"https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2015\/03\/SIGLA-BUNA-150x150.jpg","@id":"https:\/\/eticsolutions.ro\/blog\/cursuri-excel\/cursuri-excel-gratuite\/exemplu-de-utilizare-a-functiei-vlookup\/#organizationLogo","width":150,"height":150},"image":{"@id":"https:\/\/eticsolutions.ro\/blog\/cursuri-excel\/cursuri-excel-gratuite\/exemplu-de-utilizare-a-functiei-vlookup\/#organizationLogo"}},{"@type":"Person","@id":"https:\/\/eticsolutions.ro\/blog\/author\/#author","url":"https:\/\/eticsolutions.ro\/blog\/author\/"},{"@type":"WebPage","@id":"https:\/\/eticsolutions.ro\/blog\/cursuri-excel\/cursuri-excel-gratuite\/exemplu-de-utilizare-a-functiei-vlookup\/#webpage","url":"https:\/\/eticsolutions.ro\/blog\/cursuri-excel\/cursuri-excel-gratuite\/exemplu-de-utilizare-a-functiei-vlookup\/","name":"Exemplu de utilizare a functiei VLOOKUP -","description":"Se da o baza de date ce contine informatii primare referitoare la angajatii unei companii. Informatiile trebuie utilizate pentru completarea automata a unei Fise periodice de evaluare, in functie de Nume si prenume salariat. Grila de evaluare este disponibila in foaia de lucru grila evaluare. Numele si prenumele salariatului pentru care trebuie completata Fisa de","inLanguage":"en-US","isPartOf":{"@id":"https:\/\/eticsolutions.ro\/blog\/#website"},"breadcrumb":{"@id":"https:\/\/eticsolutions.ro\/blog\/cursuri-excel\/cursuri-excel-gratuite\/exemplu-de-utilizare-a-functiei-vlookup\/#breadcrumblist"},"author":{"@id":"https:\/\/eticsolutions.ro\/blog\/author\/#author"},"creator":{"@id":"https:\/\/eticsolutions.ro\/blog\/author\/#author"},"datePublished":"2019-04-21T07:44:00+00:00","dateModified":"2020-01-20T06:54:40+00:00"},{"@type":"WebSite","@id":"https:\/\/eticsolutions.ro\/blog\/#website","url":"https:\/\/eticsolutions.ro\/blog\/","inLanguage":"en-US","publisher":{"@id":"https:\/\/eticsolutions.ro\/blog\/#organization"}}]},"og:locale":"en_US","og:site_name":"-","og:type":"article","og:title":"Exemplu de utilizare a functiei VLOOKUP -","og:description":"Se da o baza de date ce contine informatii primare referitoare la angajatii unei companii. Informatiile trebuie utilizate pentru completarea automata a unei Fise periodice de evaluare, in functie de Nume si prenume salariat. Grila de evaluare este disponibila in foaia de lucru grila evaluare. Numele si prenumele salariatului pentru care trebuie completata Fisa de","og:url":"https:\/\/eticsolutions.ro\/blog\/cursuri-excel\/cursuri-excel-gratuite\/exemplu-de-utilizare-a-functiei-vlookup\/","og:image":"https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2015\/03\/SIGLA-BUNA-150x150.jpg","og:image:secure_url":"https:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2015\/03\/SIGLA-BUNA-150x150.jpg","article:published_time":"2019-04-21T07:44:00+00:00","article:modified_time":"2020-01-20T06:54:40+00:00","twitter:card":"summary_large_image","twitter:title":"Exemplu de utilizare a functiei VLOOKUP -","twitter:description":"Se da o baza de date ce contine informatii primare referitoare la angajatii unei companii. Informatiile trebuie utilizate pentru completarea automata a unei Fise periodice de evaluare, in functie de Nume si prenume salariat. Grila de evaluare este disponibila in foaia de lucru grila evaluare. Numele si prenumele salariatului pentru care trebuie completata Fisa de","twitter:image":"http:\/\/eticsolutions.ro\/blog\/wp-content\/uploads\/2015\/03\/SIGLA-BUNA-150x150.jpg"},"aioseo_meta_data":{"post_id":"435","title":null,"description":null,"keywords":null,"keyphrases":null,"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_custom_url":null,"og_image_custom_fields":null,"og_image_url":null,"og_image_width":null,"og_image_height":null,"og_video":null,"og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_image_url":null,"twitter_title":null,"twitter_description":null,"schema_type":"default","schema_type_options":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"","isEnabled":true},"graphs":[]},"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":null,"robots_max_videopreview":null,"robots_max_imagepreview":"large","priority":null,"frequency":null,"local_seo":null,"limit_modified_date":false,"ai":null,"breadcrumb_settings":null,"seo_analyzer_scan_date":null,"created":"2026-06-29 09:47:55","updated":"2026-06-29 09:47:55"},"aioseo_breadcrumb":"<div class=\"aioseo-breadcrumbs\"><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/eticsolutions.ro\/blog\" title=\"Home\">Home<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/eticsolutions.ro\/blog\/category\/cursuri-excel\/\" title=\"Cursuri Excel\">Cursuri Excel<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/eticsolutions.ro\/blog\/category\/cursuri-excel\/cursuri-excel-gratuite\/\" title=\"Cursuri Excel gratuite\">Cursuri Excel gratuite<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\tExemplu de utilizare a functiei VLOOKUP\n\t\t<\/span><\/div>","aioseo_breadcrumb_json":[{"label":"Home","link":"https:\/\/eticsolutions.ro\/blog"},{"label":"Cursuri Excel","link":"https:\/\/eticsolutions.ro\/blog\/category\/cursuri-excel\/"},{"label":"Cursuri Excel gratuite","link":"https:\/\/eticsolutions.ro\/blog\/category\/cursuri-excel\/cursuri-excel-gratuite\/"},{"label":"Exemplu de utilizare a functiei VLOOKUP","link":"https:\/\/eticsolutions.ro\/blog\/cursuri-excel\/cursuri-excel-gratuite\/exemplu-de-utilizare-a-functiei-vlookup\/"}],"_links":{"self":[{"href":"https:\/\/eticsolutions.ro\/blog\/wp-json\/wp\/v2\/posts\/435","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/eticsolutions.ro\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/eticsolutions.ro\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/eticsolutions.ro\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/eticsolutions.ro\/blog\/wp-json\/wp\/v2\/comments?post=435"}],"version-history":[{"count":14,"href":"https:\/\/eticsolutions.ro\/blog\/wp-json\/wp\/v2\/posts\/435\/revisions"}],"predecessor-version":[{"id":3349,"href":"https:\/\/eticsolutions.ro\/blog\/wp-json\/wp\/v2\/posts\/435\/revisions\/3349"}],"wp:attachment":[{"href":"https:\/\/eticsolutions.ro\/blog\/wp-json\/wp\/v2\/media?parent=435"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/eticsolutions.ro\/blog\/wp-json\/wp\/v2\/categories?post=435"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/eticsolutions.ro\/blog\/wp-json\/wp\/v2\/tags?post=435"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}