{"id":15373,"date":"2025-07-15T13:34:53","date_gmt":"2025-07-15T13:34:53","guid":{"rendered":"https:\/\/functiontranslator.com\/val\/"},"modified":"2021-02-25T16:25:53","modified_gmt":"2021-02-25T16:25:53","slug":"dget","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/dget\/","title":{"rendered":"VAL"},"content":{"rendered":"

Microsoft Excel ve Google Tablolar’da veri analizi yaparken \u00e7e\u015fitli fonksiyonlar kullan\u0131l\u0131r. Bu fonksiyonlardan biri de DGET<\/code> (Veri Al) fonksiyonudur. Bu fonksiyon, belirli kriterlere g\u00f6re bir veritaban\u0131ndan tek bir de\u011fer d\u00f6nd\u00fcrmek i\u00e7in kullan\u0131l\u0131r. A\u015fa\u011f\u0131da, bu fonksiyonun nas\u0131l kullan\u0131laca\u011f\u0131na dair detayl\u0131 bir a\u00e7\u0131klama, \u00f6rnekler ve uygulama senaryolar\u0131 yer almaktad\u0131r.<\/p>\n

DGET Fonksiyonunun Kullan\u0131m\u0131 ve S\u00f6z Dizimi<\/h2>\n

DGET<\/code> fonksiyonu, bir veritaban\u0131ndan belirlenen kriterlere uygun tek bir sat\u0131r\u0131n belirli bir s\u00fctunundaki de\u011feri d\u00f6nd\u00fcr\u00fcr. E\u011fer kriterlere uygun birden fazla sat\u0131r varsa veya hi\u00e7 sat\u0131r bulunmuyorsa, fonksiyon hata de\u011feri d\u00f6nd\u00fcr\u00fcr. Fonksiyonun genel s\u00f6z dizimi a\u015fa\u011f\u0131daki gibidir:<\/p>\n

  DGET(veritaban\u0131, alan, kriterler) <\/code> <\/pre>\n
    \n
  • veritaban\u0131<\/strong>: Analiz edilecek veri aral\u0131\u011f\u0131n\u0131 i\u00e7erir. Bu aral\u0131\u011f\u0131n ilk sat\u0131r\u0131 s\u00fctun ba\u015fl\u0131klar\u0131n\u0131 i\u00e7ermelidir.<\/li>\n
  • alan<\/strong>: Fonksiyonun de\u011ferini d\u00f6nd\u00fcrmesi gereken s\u00fctunun ad\u0131 veya s\u00fctun numaras\u0131d\u0131r.<\/li>\n
  • kriterler<\/strong>: Fonksiyonun hangi sat\u0131rlar\u0131 dikkate alaca\u011f\u0131n\u0131 belirleyen kriterleri i\u00e7eren h\u00fccre aral\u0131\u011f\u0131d\u0131r. Bu aral\u0131k genellikle ayr\u0131 bir yerde tan\u0131mlan\u0131r ve en az\u0131ndan bir s\u00fctun ba\u015fl\u0131\u011f\u0131 ile bir kriter i\u00e7ermelidir.<\/li>\n<\/ul>\n
    Uygulamal\u0131 \u00d6rnek G\u00f6revler<\/h2>\n
    \u0130\u015fte DGET<\/code> fonksiyonunun ger\u00e7ek hayat senaryolar\u0131nda nas\u0131l kullan\u0131labilece\u011fine dair iki \u00f6rnek:<\/p>\n
    \u00d6rnek G\u00f6rev 1: \u00dcr\u00fcn Stok Durumu Sorgulama<\/h2>\n
    Bir ma\u011faza y\u00f6neticisi olarak, \u00e7e\u015fitli \u00fcr\u00fcnlerin stok durumlar\u0131n\u0131 i\u00e7eren bir veritaban\u0131n\u0131z var. Belirli bir \u00fcr\u00fcn i\u00e7in g\u00fcncel stok miktar\u0131n\u0131 sorgulamak istiyorsunuz. \u00dcr\u00fcnlerin adlar\u0131na ve stok miktarlar\u0131na g\u00f6re bir veritaban\u0131 d\u00fczenlemi\u015fsiniz.<\/p>\n
      = DGET(A1:B20, \"Stok Miktar\u0131\", E1:E2) <\/code> <\/pre>\n
    Burada A1:B20<\/code> aral\u0131\u011f\u0131 \u00fcr\u00fcn adlar\u0131n\u0131 ve stok miktarlar\u0131n\u0131 i\u00e7eren veritaban\u0131n\u0131z. “Stok Miktar\u0131” sorgulanacak s\u00fctun ba\u015fl\u0131\u011f\u0131. E1:E2<\/code> aral\u0131\u011f\u0131 ise \u00fcr\u00fcn ad\u0131na g\u00f6re filtrelenecek kriterleri i\u00e7erir. E1’de “\u00dcr\u00fcn Ad\u0131”, E2’de ise sorgulamak istedi\u011finiz \u00fcr\u00fcn\u00fcn ad\u0131 yer al\u0131r.<\/p>\n
    \u00d6rnek G\u00f6rev 2: \u00d6\u011frenci Not Ortalamas\u0131 Hesaplama<\/h2>\n
    Bir okulun \u00f6\u011frenci not veritaban\u0131n\u0131 y\u00f6netiyorsunuz. Belirli bir \u00f6\u011frencinin final not ortalamas\u0131n\u0131 bulmak istiyorsunuz. Veritaban\u0131n\u0131z \u00f6\u011frenci isimleri ve notlar\u0131 i\u00e7erir.<\/p>\n
      = DGET(A1:C100, \"Final Notu\", F1:F2) <\/code> <\/pre>\n
    Bu \u00f6rnekte A1:C100<\/code> aral\u0131\u011f\u0131 \u00f6\u011frenci isimleri, ders adlar\u0131 ve notlar\u0131 i\u00e7erirken, “Final Notu” d\u00f6nd\u00fcr\u00fclecek not bilgisini temsil eder. F1:F2<\/code> aral\u0131\u011f\u0131nda, F1’de “\u00d6\u011frenci Ad\u0131”, F2’de ise ara\u015ft\u0131rmak istedi\u011finiz \u00f6\u011frencinin ad\u0131 bulunmaktad\u0131r.<\/p>\n
    Bu \u00f6rnekler, DGET<\/code> fonksiyonunun \u00e7e\u015fitli ihtiya\u00e7lar i\u00e7in ne kadar etkili kullan\u0131labilece\u011fini g\u00f6stermektedir. Fonksiyonun do\u011fru kullan\u0131lmas\u0131, veri analizi s\u00fcre\u00e7lerini \u00f6nemli \u00f6l\u00e7\u00fcde h\u0131zland\u0131rabilir ve kolayla\u015ft\u0131rabilir.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Veritaban\u0131ndan, belirtilen \u00f6l\u00e7\u00fctlerle e\u015fle\u015fen tek bir rapor \u00e7\u0131kar\u0131r<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[589],"tags":[],"class_list":["post-15373","post","type-post","status-publish","format-standard","hentry","category-veritabani"],"acf":[],"yoast_head":"\nExcel'de DGET (VAL) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar'da DGET (VAL) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/functiontranslator.com\/tr\/dget\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de DGET (VAL) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar'da DGET (VAL) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/tr\/dget\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:53+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-25T16:25:53+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Excel'de DGET (VAL) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta name=\"twitter:label1\" content=\"Yazan:\" \/>\n\t<meta name=\"twitter:data1\" content=\"glavadmin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tahmini okuma s\u00fcresi\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/dget\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/dget\/\",\"name\":\"Excel'de DGET (VAL) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:53+00:00\",\"dateModified\":\"2021-02-25T16:25:53+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da DGET (VAL) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/tr\/dget\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/dget\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/dget\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Excel i\u015flevleri\",\"item\":\"https:\/\/functiontranslator.com\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Veritaban\u0131\",\"item\":\"https:\/\/functiontranslator.com\/tr\/veritabani\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"VAL\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\",\"url\":\"https:\/\/functiontranslator.com\/no\/\",\"name\":\"Function Translator\",\"description\":\"Excel function translator\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/functiontranslator.com\/no\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"tr\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\",\"name\":\"glavadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"caption\":\"glavadmin\"},\"sameAs\":[\"https:\/\/functiontranslator.com\"],\"url\":\"https:\/\/functiontranslator.com\/tr\/author\/glavadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel'de DGET (VAL) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da DGET (VAL) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.","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:\/\/functiontranslator.com\/tr\/dget\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de DGET (VAL) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da DGET (VAL) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.","og_url":"https:\/\/functiontranslator.com\/tr\/dget\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:53+00:00","article_modified_time":"2021-02-25T16:25:53+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de DGET (VAL) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","twitter_misc":{"Yazan:":"glavadmin","Tahmini okuma s\u00fcresi":"2 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/tr\/dget\/","url":"https:\/\/functiontranslator.com\/tr\/dget\/","name":"Excel'de DGET (VAL) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:53+00:00","dateModified":"2021-02-25T16:25:53+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da DGET (VAL) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/tr\/dget\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/dget\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/dget\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Excel i\u015flevleri","item":"https:\/\/functiontranslator.com\/tr\/"},{"@type":"ListItem","position":2,"name":"Veritaban\u0131","item":"https:\/\/functiontranslator.com\/tr\/veritabani\/"},{"@type":"ListItem","position":3,"name":"VAL"}]},{"@type":"WebSite","@id":"https:\/\/functiontranslator.com\/no\/#website","url":"https:\/\/functiontranslator.com\/no\/","name":"Function Translator","description":"Excel function translator","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/functiontranslator.com\/no\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"tr"},{"@type":"Person","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389","name":"glavadmin","image":{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","caption":"glavadmin"},"sameAs":["https:\/\/functiontranslator.com"],"url":"https:\/\/functiontranslator.com\/tr\/author\/glavadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15373","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/comments?post=15373"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15373\/revisions"}],"predecessor-version":[{"id":26641,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15373\/revisions\/26641"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15373"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15373"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15373"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}