{"id":15255,"date":"2025-07-15T13:34:52","date_gmt":"2025-07-15T13:34:52","guid":{"rendered":"https:\/\/functiontranslator.com\/adres\/"},"modified":"2021-02-25T16:21:56","modified_gmt":"2021-02-25T16:21:56","slug":"address","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/address\/","title":{"rendered":"ADRES"},"content":{"rendered":"

Microsoft Excel ve Google Sheets, kapsaml\u0131 fonksiyon k\u00fct\u00fcphaneleri sayesinde bilgisayar destekli hesaplama ve veri analizinde \u00f6nc\u00fc ara\u00e7lard\u0131r. Bu metinde, hem Excel hem de Google Sheets’te kullan\u0131lan “ADRES” fonksiyonunun detayl\u0131 kullan\u0131m\u0131n\u0131 ele alaca\u011f\u0131z.<\/p>\n

ADRES Fonksiyonunun Tan\u0131m\u0131 ve S\u00f6zdizimi<\/h2>\n

ADRES fonksiyonu, belirli bir sat\u0131r ve s\u00fctun numaras\u0131na kar\u015f\u0131l\u0131k gelen h\u00fccre referans\u0131n\u0131n metin format\u0131nda adresini d\u00f6nd\u00fcr\u00fcr. Bu fonksiyon, genellikle di\u011fer i\u015flevlerle birlikte kullan\u0131larak h\u00fccre referanslar\u0131n\u0131 dinamik bir \u015fekilde olu\u015fturmak i\u00e7in de\u011ferlidir.<\/p>\n

 Syntax: ADRES(sat\u0131r_numaras\u0131, s\u00fctun_numaras\u0131, [ba\u015fvuru_t\u00fcr\u00fc], [mutlak_etkin], [sayfa_ad\u0131])<\/code> <\/pre>\n
    \n
  • sat\u0131r_numaras\u0131:<\/strong> Adresin belirtilece\u011fi sat\u0131r numaras\u0131.<\/li>\n
  • s\u00fctun_numaras\u0131:<\/strong> Adresin belirtilece\u011fi s\u00fctun numaras\u0131.<\/li>\n
  • ba\u015fvuru_t\u00fcr\u00fc (iste\u011fe ba\u011fl\u0131):<\/strong> H\u00fccre ba\u015fvurusunun tipini belirler (1, 2, 3 veya 4). Varsay\u0131lan de\u011fer A1 stilinde mutlak ba\u015fvurudur (1).<\/li>\n
  • mutlak_etkin (iste\u011fe ba\u011fl\u0131):<\/strong> TRUE ya da FALSE de\u011feri al\u0131r. Sayfa ad\u0131 eklenmi\u015fse, bu, sayfa ad\u0131n\u0131n ba\u015fvuruda nas\u0131l g\u00f6sterilece\u011fini etkiler.<\/li>\n
  • sayfa_ad\u0131 (iste\u011fe ba\u011fl\u0131):<\/strong> H\u00fccre ba\u015fvurusunun yap\u0131laca\u011f\u0131 \u00e7al\u0131\u015fma sayfas\u0131n\u0131n ad\u0131.<\/li>\n<\/ul>\n
    Uygulama \u00d6rnekleri<\/h2>\n
    \u00d6rnek 1: Dinamik H\u00fccre Ba\u011flant\u0131s\u0131 Olu\u015fturma<\/h2>\n
    Diyelim ki, ba\u015fka bir h\u00fccredeki sat\u0131r ve s\u00fctun numaralar\u0131na dayanarak bir h\u00fccre adresi dinamik olarak olu\u015fturmak istiyorsunuz.<\/p>\n
      =ADRES(A1, B1) <\/code> <\/pre>\n
    Burada A1 h\u00fccresi sat\u0131r numaras\u0131n\u0131, B1 h\u00fccresi ise s\u00fctun numaras\u0131n\u0131 temsil eder. \u00d6rne\u011fin, A1’de 5 ve B1’de 3 de\u011ferleri varsa, sonu\u00e7 ‘C5’ olarak d\u00f6necektir.<\/p>\n
    \u00d6rnek 2: Veri Taban\u0131nda H\u00fccre Arama<\/h2>\n
    Veri tablosunda belli bir veriyi bulmak i\u00e7in sat\u0131r ve s\u00fctun numaralar\u0131n\u0131 kullanarak h\u00fccre adresini dinamik olarak olu\u015fturabilirsiniz.<\/p>\n
      =INDIRECT(ADRES(4, 3)) <\/code> <\/pre>\n
    Bu form\u00fcl, \u00e7al\u0131\u015fma kitab\u0131ndaki 4. sat\u0131r ve 3. s\u00fctundaki h\u00fccrenin de\u011ferine ula\u015fman\u0131z\u0131 sa\u011flar. INDIRECT fonksiyonu, ADRES fonksiyonundan elde edilen metin tabanl\u0131 h\u00fccre referans\u0131n\u0131 \u00e7al\u0131\u015ft\u0131r\u0131labilir bir referansa d\u00f6n\u00fc\u015ft\u00fcr\u00fcr.<\/p>\n
    \u00d6zetle, Excel ve Google Sheets’teki ADRES fonksiyonu, veri y\u00f6netimi ve dinamik h\u00fccre etkile\u015fimi gibi alanlarda \u00f6nemli kolayl\u0131klar sa\u011flar ve b\u00fcy\u00fck veri tablolar\u0131nda esnek \u00e7al\u0131\u015fma imk\u00e2n\u0131 sunar. Daha g\u00fc\u00e7l\u00fc ve esnek \u00e7\u00f6z\u00fcmler \u00fcretmek i\u00e7in bu fonksiyon di\u011fer fonksiyonlarla kombin edilebilir.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Bir ba\u015fvuruyu, \u00e7al\u0131\u015fma sayfas\u0131ndaki tek bir h\u00fccreye metin olarak 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-15255","post","type-post","status-publish","format-standard","hentry","category-arama-ve-basvuru"],"acf":[],"yoast_head":"\nExcel'de ADDRESS (ADRES) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar'da ADDRESS (ADRES) 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\/address\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de ADDRESS (ADRES) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar'da ADDRESS (ADRES) 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\/address\/\" \/>\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:21:56+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 ADDRESS (ADRES) 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\/address\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/address\/\",\"name\":\"Excel'de ADDRESS (ADRES) 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:21:56+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da ADDRESS (ADRES) 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\/address\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/address\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/address\/#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\":\"ADRES\"}]},{\"@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 ADDRESS (ADRES) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da ADDRESS (ADRES) 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\/address\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de ADDRESS (ADRES) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da ADDRESS (ADRES) 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\/address\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:52+00:00","article_modified_time":"2021-02-25T16:21:56+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de ADDRESS (ADRES) 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\/address\/","url":"https:\/\/functiontranslator.com\/tr\/address\/","name":"Excel'de ADDRESS (ADRES) 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:21:56+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da ADDRESS (ADRES) 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\/address\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/address\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/address\/#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":"ADRES"}]},{"@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\/15255","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=15255"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15255\/revisions"}],"predecessor-version":[{"id":26523,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15255\/revisions\/26523"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15255"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15255"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15255"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}