{"id":15484,"date":"2025-07-15T13:34:52","date_gmt":"2025-07-15T13:34:52","guid":{"rendered":"https:\/\/functiontranslator.com\/dolayli\/"},"modified":"2021-02-25T16:29:36","modified_gmt":"2021-02-25T16:29:36","slug":"indirect","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/indirect\/","title":{"rendered":"DOLAYLI"},"content":{"rendered":"

Excel ve Google E-Tablolar’da veri analizi ve i\u015flem yaparken kullan\u0131lan fonksiyonlardan biri DOLAYLI<\/strong> (INDIRECT) fonksiyonudur. Bu fonksiyon, metin format\u0131ndaki bir referans\u0131 ger\u00e7ek bir h\u00fccre referans\u0131na d\u00f6n\u00fc\u015ft\u00fcr\u00fcr. Bu yaz\u0131da, bu fonksiyonun nas\u0131l kullan\u0131laca\u011f\u0131n\u0131 ayr\u0131nt\u0131l\u0131 bir \u015fekilde ve pratik \u00f6rneklerle ele alaca\u011f\u0131z.<\/p>\n

Dolayl\u0131 Fonksiyonu Nedir?<\/h2>\n

DOLAYLI fonksiyonu, bir metin string’ini al\u0131r ve bu metni Excel ya da Google E-Tablolar’da h\u00fccre referans\u0131na \u00e7evirir. Bu sayede, dinamik h\u00fccre referanslar\u0131 olu\u015fturulabilir ve form\u00fcllerde esneklik sa\u011flan\u0131r.<\/p>\n

S\u00f6zdizimi:<\/strong><\/p>\n

DOLAYLI(ref_text, [a1])<\/code><\/pre>\n
    \n
  • ref_text:<\/strong> H\u00fccre referans\u0131n\u0131 veya aral\u0131\u011f\u0131n\u0131 i\u00e7eren metin.<\/li>\n
  • [a1]:<\/strong> \u0130ste\u011fe ba\u011fl\u0131 arg\u00fcman; TRUE veya FALSE de\u011feri alabilir. TRUE oldu\u011funda, metin string’i A1 notasyonu \u015feklinde alg\u0131lan\u0131r. FALSE, R1C1 notasyonunu ifade eder.<\/li>\n<\/ul>\n
    Dolayl\u0131 Fonksiyonunun Kullan\u0131lma Alanlar\u0131 ve \u00d6rnek Senaryolar<\/h2>\n
    \u0130\u015fte DOLAYLI fonksiyonunun kullan\u0131m\u0131na ili\u015fkin iki pratik \u00f6rnek:<\/p>\n
    \u00d6rnek: Dinamik H\u00fccre Referanslar\u0131<\/h2>\n
    Bir \u00f6\u011frencinin notlar\u0131n\u0131 tuttu\u011funuz bir tabloda farkl\u0131 dersler i\u00e7in ayr\u0131 h\u00fccreleri referans almak isteyebilirsiniz. \u00d6\u011frencinin ald\u0131\u011f\u0131 derse g\u00f6re notunun bulundu\u011fu h\u00fccreyi dinamik olarak se\u00e7mek i\u00e7in DOLAYLI fonksiyonunu kullanabilirsiniz.<\/p>\n
      =DOLAYLI(\"B\" & A2) <\/code> <\/pre>\n
    Bu \u00f6rnekte, A2 h\u00fccresinde ders numaras\u0131 bulunmaktad\u0131r (\u00f6rne\u011fin, 2). “B” & A2 ifadesi “B2” metin string’ini olu\u015fturur ve DOLAYLI fonksiyonu bu metni B2 h\u00fccresine referans olarak d\u00f6n\u00fc\u015ft\u00fcr\u00fcr. Burada B2 h\u00fccresi, \u00f6\u011frencinin ilgili derse ait notunu g\u00f6sterir.<\/p>\n
    \u00d6rnek: \u00c7al\u0131\u015fma Sayfalar\u0131 Aras\u0131 Referanslar<\/h2>\n
    Bir i\u015fletmenin ayl\u0131k gelirlerini farkl\u0131 \u00e7al\u0131\u015fma sayfalar\u0131nda tuttu\u011funuz bir dosyada, \u00f6zet bir \u00e7al\u0131\u015fma sayfas\u0131nda t\u00fcm aylar\u0131n gelirlerini toplamak istedi\u011finizi varsayal\u0131m.<\/p>\n
      =SUM(DOLAYLI(\"'Jan'\" & \"!B2:B10\"), DOLAYLI(\"'Feb'\" & \"!B2:B10\"), ... ) <\/code> <\/pre>\n
    Bu form\u00fcl, “Jan”, “Feb” gibi farkl\u0131 \u00e7al\u0131\u015fma sayfalar\u0131ndaki B2:B10 aral\u0131\u011f\u0131n\u0131 referans alarak bu h\u00fccrelerin de\u011ferlerini toplar. DOLAYLI fonksiyonu sayesinde, metin string’ini \u00e7al\u0131\u015fma sayfas\u0131 referanslar\u0131na d\u00f6n\u00fc\u015ft\u00fcren dinamik bir toplama i\u015flemi yap\u0131l\u0131r.<\/p>\n
    Bu \u00f6rneklerde g\u00f6r\u00fcld\u00fc\u011f\u00fc gibi, DOLAYLI fonksiyonu, \u00f6zellikle de\u011fi\u015fken veri setlerine ve birden fazla \u00e7al\u0131\u015fma sayfas\u0131na sahip b\u00fcy\u00fck dosyalarda b\u00fcy\u00fck kolayl\u0131klar sa\u011flar. Bu y\u00f6ntemlerle veri y\u00f6netimi ve analizi daha esnek ve etkili hale getirilebilir.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Metin de\u011feriyle belirtilen bir ba\u015fvuru verir<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[579],"tags":[],"class_list":["post-15484","post","type-post","status-publish","format-standard","hentry","category-arama-ve-basvuru"],"acf":[],"yoast_head":"\nExcel'de INDIRECT (DOLAYLI) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar'da INDIRECT (DOLAYLI) 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\/indirect\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de INDIRECT (DOLAYLI) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar'da INDIRECT (DOLAYLI) 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\/indirect\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:52+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-25T16:29:36+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 INDIRECT (DOLAYLI) 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\/indirect\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/indirect\/\",\"name\":\"Excel'de INDIRECT (DOLAYLI) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:52+00:00\",\"dateModified\":\"2021-02-25T16:29:36+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da INDIRECT (DOLAYLI) 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\/indirect\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/indirect\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/indirect\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Excel i\u015flevleri\",\"item\":\"https:\/\/functiontranslator.com\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Arama ve ba\u015fvuru\",\"item\":\"https:\/\/functiontranslator.com\/tr\/arama-ve-basvuru\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"DOLAYLI\"}]},{\"@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 INDIRECT (DOLAYLI) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da INDIRECT (DOLAYLI) 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\/indirect\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de INDIRECT (DOLAYLI) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da INDIRECT (DOLAYLI) 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\/indirect\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:52+00:00","article_modified_time":"2021-02-25T16:29:36+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de INDIRECT (DOLAYLI) 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\/indirect\/","url":"https:\/\/functiontranslator.com\/tr\/indirect\/","name":"Excel'de INDIRECT (DOLAYLI) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:52+00:00","dateModified":"2021-02-25T16:29:36+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da INDIRECT (DOLAYLI) 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\/indirect\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/indirect\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/indirect\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Excel i\u015flevleri","item":"https:\/\/functiontranslator.com\/tr\/"},{"@type":"ListItem","position":2,"name":"Arama ve ba\u015fvuru","item":"https:\/\/functiontranslator.com\/tr\/arama-ve-basvuru\/"},{"@type":"ListItem","position":3,"name":"DOLAYLI"}]},{"@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\/15484","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=15484"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15484\/revisions"}],"predecessor-version":[{"id":26752,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15484\/revisions\/26752"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15484"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15484"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15484"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}