{"id":15449,"date":"2025-07-15T13:34:53","date_gmt":"2025-07-15T13:34:53","guid":{"rendered":"https:\/\/functiontranslator.com\/yatayara\/"},"modified":"2021-02-25T16:28:19","modified_gmt":"2021-02-25T16:28:19","slug":"hlookup","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/hlookup\/","title":{"rendered":"YATAYARA"},"content":{"rendered":"

Microsoft Excel ve Google Sheets, veri analizi ve hesaplama i\u015flemleri i\u00e7in kullan\u0131lan g\u00fc\u00e7l\u00fc ara\u00e7lard\u0131r. Her iki programda da bulunan “HLOOKUP” (Yatay Ara) fonksiyonu, bir veri seti i\u00e7indeki bilgilere yatay olarak eri\u015filmesini sa\u011flar. Bu fonksiyon, tablolar aras\u0131nda belirli verileri aramak ve analiz etmek amac\u0131yla s\u0131kl\u0131kla kullan\u0131l\u0131r.<\/p>\n

Yatay Ara Fonksiyonunun Kullan\u0131m\u0131<\/h2>\n

“HLOOKUP” fonksiyonu, bir de\u011feri yatay d\u00fczlemde arayarak e\u015fle\u015fen de\u011ferleri d\u00f6nd\u00fcrmek i\u00e7in kullan\u0131l\u0131r. Fonksiyonun genel s\u00f6zdizimi a\u015fa\u011f\u0131daki gibidir:<\/p>\n

  HLOOKUP(aranacak_de\u011fer, tablo_dizisi, sat\u0131r_index_num, [yakla\u015f\u0131k_e\u015fle\u015fme]) <\/code> <\/pre>\n
    \n
  • aranacak_de\u011fer:<\/strong> Aramak istedi\u011finiz de\u011fer. Bu de\u011fer say\u0131 ya da metin olabilir.<\/li>\n
  • tablo_dizisi:<\/strong> Araman\u0131n yap\u0131laca\u011f\u0131 tablo aral\u0131\u011f\u0131.<\/li>\n
  • sat\u0131r_index_num:<\/strong> Aranacak de\u011ferin bulundu\u011fu sat\u0131r numaras\u0131. Bu numara, tablo dizisinin ilk sat\u0131r\u0131ndan itibaren hesaplan\u0131r.<\/li>\n
  • yakla\u015f\u0131k_e\u015fle\u015fme:<\/strong> Opsiyonel bir arg\u00fcman. TRUE (veya de\u011fer girilmezse) fonksiyon, yakla\u015f\u0131k e\u015fle\u015fme aramas\u0131 yapar; FALSE ise tam e\u015fle\u015fme aramas\u0131 yapar.<\/li>\n<\/ul>\n
    \u00d6rnek olarak, bir \u00fcr\u00fcn listesindeki fiyatlar\u0131 yatay bir arama ile bulmak i\u00e7in a\u015fa\u011f\u0131daki form\u00fcl\u00fc kullanabilirsiniz:<\/p>\n
      =HLOOKUP(\"\u00dcr\u00fcn123\", A1:D4, 2, FALSE) <\/code> <\/pre>\n\n\n\n\n
    A<\/th>\nB<\/th>\nC<\/th>\nD<\/th>\n<\/tr>\n
    \u00dcr\u00fcn121<\/td>\n\u00dcr\u00fcn122<\/td>\n\u00dcr\u00fcn123<\/td>\n\u00dcr\u00fcn124<\/td>\n<\/tr>\n
    500<\/td>\n600<\/td>\n700<\/td>\n800<\/td>\n<\/tr>\n<\/table>\n
    Bu \u00f6rnekte, “\u00dcr\u00fcn123” arand\u0131\u011f\u0131nda, ilgili fiyat bilgisi olan 700 de\u011feri d\u00f6nd\u00fcr\u00fcl\u00fcr.<\/p>\n
    Pratik Uygulamalar<\/h2>\n
    Yatay Ara fonksiyonu, \u00e7e\u015fitli pratik durumlarda kullan\u0131labilir. \u0130\u015fte bu fonksiyonun kullan\u0131ld\u0131\u011f\u0131 iki farkl\u0131 senaryo:<\/p>\n
    Senaryo 1: Sat\u0131\u015f Raporlar\u0131<\/h2>\n
    Bir \u015firket, \u00e7e\u015fitli \u00fcr\u00fcnlerin ayl\u0131k sat\u0131\u015f miktarlar\u0131n\u0131 i\u00e7eren bir tablo kullan\u0131yor ve en \u00e7ok satan \u00fcr\u00fcn\u00fcn miktar\u0131n\u0131 bulmak istiyorsunuz.<\/p>\n
      =HLOOKUP(\"May\u0131s\", B1:M1, 3, FALSE) <\/code> <\/pre>\n\n\n\n\n
    Ay<\/th>\nYan<\/td>\n\u015eub<\/td>\nMar<\/td>\nNis<\/td>\nMay\u0131s<\/td>\nHaz<\/td>\nTem<\/td>\nA\u011fu<\/td>\nEyl<\/td>\nEki<\/td>\nKas<\/td>\nAra<\/td>\n<\/tr>\n
    \u00dcr\u00fcn A<\/td>\n120<\/td>\n130<\/td>\n150<\/td>\n160<\/td>\n180<\/td>\n140<\/td>\n110<\/td>\n100<\/td>\n90<\/td>\n110<\/td>\n120<\/td>\n140<\/td>\n<\/tr>\n
    \u00dcr\u00fcn B<\/td>\n200<\/td>\n190<\/td>\n210<\/td>\n230<\/td>\n250<\/td>\n220<\/td>\n210<\/td>\n205<\/td>\n195<\/td>\n230<\/td>\n250<\/td>\n240<\/td>\n<\/tr>\n<\/table>\n
    Yukar\u0131daki \u00f6rnek form\u00fcl, May\u0131s ay\u0131 i\u00e7in \u00dcr\u00fcn B’nin sat\u0131\u015f miktar\u0131 olan 250 de\u011ferini d\u00f6nd\u00fcr\u00fcr.<\/p>\n
    Senaryo 2: \u00d6\u011frenci Bilgileri<\/h2>\n
    Bir okul, \u00f6\u011frenci notlar\u0131n\u0131 yatay bir \u015fekilde saklad\u0131\u011f\u0131 bir veri taban\u0131 kullan\u0131r ve belli bir \u00f6\u011frencinin final notunu bulmak istenir.<\/p>\n
      =HLOOKUP(\"Ahmet\", A1:F1, 3, TRUE) <\/code> <\/pre>\n\n\n\n\n
    \u00d6\u011frenci<\/th>\nAy\u015fe<\/td>\nMehmet<\/td>\nAhmet<\/td>\nFatma<\/td>\nAli<\/td>\n<\/tr>\n
    Vize<\/td>\n80<\/td>\n90<\/td>\n85<\/td>\n75<\/td>\n95<\/td>\n<\/tr>\n
    Final<\/td>\n85<\/td>\n92<\/td>\n88<\/td>\n82<\/td>\n90<\/td>\n<\/tr>\n<\/table>\n
    Bu \u00f6rnekte, “Ahmet” adl\u0131 \u00f6\u011frencinin final notu olan 88 de\u011feri d\u00f6nd\u00fcr\u00fcl\u00fcr.<\/p>\n
    Sonu\u00e7 olarak, HLOOKUP fonksiyonu, bilgi y\u00f6netimi ve veri sorgulama konular\u0131nda Excel ve Google Sheets kullan\u0131c\u0131lar\u0131na b\u00fcy\u00fck esneklik sa\u011flar.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Bir dizinin en \u00fcst sat\u0131r\u0131na bakar ve belirtilen h\u00fccrenin de\u011ferini 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-15449","post","type-post","status-publish","format-standard","hentry","category-arama-ve-basvuru"],"acf":[],"yoast_head":"\nExcel'de HLOOKUP (YATAYARA) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar'da HLOOKUP (YATAYARA) 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\/hlookup\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de HLOOKUP (YATAYARA) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar'da HLOOKUP (YATAYARA) 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\/hlookup\/\" \/>\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:28:19+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 HLOOKUP (YATAYARA) 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\/hlookup\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/hlookup\/\",\"name\":\"Excel'de HLOOKUP (YATAYARA) 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:28:19+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da HLOOKUP (YATAYARA) 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\/hlookup\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/hlookup\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/hlookup\/#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\":\"YATAYARA\"}]},{\"@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 HLOOKUP (YATAYARA) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da HLOOKUP (YATAYARA) 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\/hlookup\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de HLOOKUP (YATAYARA) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da HLOOKUP (YATAYARA) 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\/hlookup\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:53+00:00","article_modified_time":"2021-02-25T16:28:19+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de HLOOKUP (YATAYARA) 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\/hlookup\/","url":"https:\/\/functiontranslator.com\/tr\/hlookup\/","name":"Excel'de HLOOKUP (YATAYARA) 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:28:19+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da HLOOKUP (YATAYARA) 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\/hlookup\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/hlookup\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/hlookup\/#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":"YATAYARA"}]},{"@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\/15449","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=15449"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15449\/revisions"}],"predecessor-version":[{"id":26717,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15449\/revisions\/26717"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15449"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15449"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15449"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}