{"id":2112,"date":"2023-10-15T12:42:55","date_gmt":"2023-10-15T12:42:55","guid":{"rendered":"https:\/\/exceladvisor.org\/tr\/excel-arama-fonksiyonlari\/"},"modified":"2023-12-10T06:00:11","modified_gmt":"2023-12-10T06:00:11","slug":"excel-arama-fonksiyonlari","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/tr\/excel-arama-fonksiyonlari\/","title":{"rendered":"Excel&#39;de arama i\u015flevleri nas\u0131l kullan\u0131l\u0131r?"},"content":{"rendered":"<div class=\"excel-icerikten-once\" id=\"excel-3337787828\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div> <p><strong><em><a href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel_lookup_functions_sample_files.zip\">\u00f6rnek dosyalar<\/a><\/em><\/strong><\/p><h2 class=\"wp-block-heading\"> 1. ADRES i\u015flevi<\/h2><p> <strong>ADDRESS i\u015flevi, s\u00fctun ve sat\u0131r adresine dayal\u0131 olarak ge\u00e7erli bir h\u00fccre ba\u015fvurusu d\u00f6nd\u00fcr\u00fcr.<\/strong> Basit bir ifadeyle, bir h\u00fccrenin adresini sat\u0131r numaras\u0131n\u0131 ve s\u00fctun numaras\u0131n\u0131 kullanarak olu\u015fturabilirsiniz.<\/p><h3 class=\"wp-block-heading\"> <strong>S\u00f6zdizimi<\/strong><\/h3><p> <em>ADRES(sat\u0131r_say\u0131s\u0131,s\u00fctun_say\u0131s\u0131,mutlak_say\u0131s\u0131,A1,sayfa_metni)<\/em><\/p><h3 class=\"wp-block-heading\"> <strong>Arg\u00fcmanlar<\/strong><\/h3><ul><li> <strong>sat\u0131r_say\u0131s\u0131:<\/strong> sat\u0131r numaras\u0131n\u0131 belirten bir say\u0131.<\/li><li> <strong>s\u00fctun_say\u0131s\u0131:<\/strong> s\u00fctun numaras\u0131n\u0131 belirten bir say\u0131.<\/li><li> <strong>[abs_num]:<\/strong> Referans t\u00fcr\u00fc.<\/li><li> <strong>[A1]:<\/strong> referans stili.<\/li><li> <strong>[sayfa_metni]:<\/strong> Sayfa ad\u0131 olarak bir metin de\u011feri.<\/li><\/ul><h3 class=\"wp-block-heading\"> <strong>Yorumlar<\/strong><\/h3><ul><li> Varsay\u0131lan olarak ADDRESS i\u015flevi sonu\u00e7ta mutlak bir ba\u015fvuru d\u00f6nd\u00fcr\u00fcr.<\/li><\/ul><h3 class=\"wp-block-heading\"> \u00d6rnek<\/h3><p> A\u015fa\u011f\u0131daki \u00f6rnekte her t\u00fcrl\u00fc sonucu elde etmek i\u00e7in farkl\u0131 arg\u00fcmanlar kulland\u0131k. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-36829\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-dadresse-excel-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-adresi-i\u015flevi-\u00f6rnek-1\" width=\"744\" height=\"452\"><\/figure><\/div><p> <a href=\"https:\/\/exceladvisor.org\/tr\/r1c1\/\"><strong>Referans stili R1C1<\/strong><\/a> <strong>ile<\/strong> <strong>:<\/strong><\/p><ul><li> G\u00f6receli referans.<\/li><li> G\u00f6reli sat\u0131r referans\u0131 ve mutlak s\u00fctun referans\u0131.<\/li><li> Mutlak sat\u0131r ve g\u00f6receli s\u00fctun referans\u0131.<\/li><li> Mutlak referans.<\/li><\/ul><p> <strong>Referans stili A1 ile:<\/strong><\/p><ul><li> G\u00f6receli referans.<\/li><li> G\u00f6reli sat\u0131r referans\u0131 ve mutlak s\u00fctun referans\u0131.<\/li><li> Mutlak sat\u0131r ve g\u00f6receli s\u00fctun referans\u0131.<\/li><li> Mutlak referans.<\/li><\/ul><h2 class=\"wp-block-heading\"> 2. B\u00d6LGELER i\u015flevi<\/h2><p> <strong>ALANLAR i\u015flevi, belirtti\u011finiz ba\u015fvurudaki aral\u0131k say\u0131s\u0131n\u0131 temsil eden bir say\u0131 d\u00f6nd\u00fcr\u00fcr.<\/strong> Basit bir ifadeyle, asl\u0131nda i\u015flevde ba\u015fvuruda bulundu\u011funuz farkl\u0131 \u00e7al\u0131\u015fma sayfas\u0131 alanlar\u0131n\u0131 sayar.<\/p><h3 class=\"wp-block-heading\"> <strong>s\u00f6zdizimi<\/strong><\/h3><p> ALANLAR (referans)<\/p><h3 class=\"wp-block-heading\"> <strong>Arg\u00fcmanlar<\/strong><\/h3><ul><li> <strong>ba\u015fvuru:<\/strong> bir h\u00fccreye veya h\u00fccre aral\u0131\u011f\u0131na yap\u0131lan ba\u015fvuru.<\/li><\/ul><h3 class=\"wp-block-heading\"> <strong>Yorumlar<\/strong><\/h3><ul><li> Ba\u015fvuru bir h\u00fccre, bir h\u00fccre aral\u0131\u011f\u0131 veya adland\u0131r\u0131lm\u0131\u015f bir aral\u0131k olabilir.<\/li><li> Birden fazla h\u00fccre referans\u0131na ba\u015fvurmak istiyorsan\u0131z, bu referanslar\u0131n t\u00fcm\u00fcn\u00fc birden fazla parantez i\u00e7ine alman\u0131z ve her bir referans\u0131 di\u011ferlerinden ay\u0131rmak i\u00e7in virg\u00fcl kullanman\u0131z gerekir.<\/li><\/ul><h3 class=\"wp-block-heading\"> \u00d6rnek<\/h3><p> A\u015fa\u011f\u0131daki \u00f6rnekte, adland\u0131r\u0131lm\u0131\u015f bir aral\u0131ktaki say\u0131sal referans\u0131 almak i\u00e7in b\u00f6lgeler i\u015flevini kulland\u0131k. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-36857\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/zones-excel-exemple-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"Excel-B\u00f6lgeleri-\u00d6rnek-1\" width=\"572\" height=\"365\"><\/figure><\/div><p> G\u00f6rd\u00fc\u011f\u00fcn\u00fcz gibi aral\u0131kta \u00fc\u00e7 s\u00fctun var ve sonu\u00e7ta 3 d\u00f6nd\u00fcrd\u00fc. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-36858\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-de-zone-excel-2-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-B\u00f6lge-i\u015flevi-\u00f6rnek-2 (1)\" width=\"580\" height=\"380\"><\/figure><\/div><h2 class=\"wp-block-heading\"> 3. Fonksiyonu SE\u00c7\u0130N<\/h2><p> <strong>SELECT i\u015flevi, belirtilen konum numaras\u0131na g\u00f6re de\u011ferler listesinden bir de\u011fer d\u00f6nd\u00fcr\u00fcr.<\/strong> Basit bir ifadeyle, bir listede konumuna g\u00f6re bir de\u011fer arar ve onu sonu\u00e7 olarak d\u00f6nd\u00fcr\u00fcr.<\/p><h3 class=\"wp-block-heading\"> <strong>S\u00f6zdizimi<\/strong><\/h3><p> <em>SELECT(say\u0131_dizin, de\u011fer1, de\u011fer2,\u2026)<\/em><\/p><h3 class=\"wp-block-heading\"> <strong>Arg\u00fcmanlar<\/strong><\/h3><ul><li> <strong>indeks_num:<\/strong> de\u011ferin listedeki konumunu belirtmek i\u00e7in kullan\u0131lan say\u0131.<\/li><li> <strong>de\u011fer1:<\/strong> Aralar\u0131ndan se\u00e7im yapabilece\u011finiz bir h\u00fccre aral\u0131\u011f\u0131 veya giri\u015f de\u011feri.<\/li><li> <strong>[de\u011fer2]:<\/strong> Aralar\u0131ndan se\u00e7im yapabilece\u011finiz bir h\u00fccre aral\u0131\u011f\u0131 veya giri\u015f de\u011feri.<\/li><\/ul><h3 class=\"wp-block-heading\"> <strong>Yorumlar<\/strong><\/h3><ul><li> Bir h\u00fccreye referans verebilir veya de\u011ferleri do\u011frudan fonksiyona da ekleyebilirsiniz.<\/li><\/ul><h3 class=\"wp-block-heading\"> \u00d6rnek<\/h3><p> A\u015fa\u011f\u0131daki \u00f6rnekte, d\u00f6rt farkl\u0131 \u015feyi (toplam, ortalama, maksimum ve kar\u0131\u015f\u0131m) hesaplamak i\u00e7in a\u00e7\u0131l\u0131r listeli CHOOSE i\u015flevini kulland\u0131k. D\u00f6rt \u015feyi hesaplamak i\u00e7in a\u015fa\u011f\u0131daki form\u00fcl\u00fc kulland\u0131k:<\/p><p> =SE\u00c7(D\u00dc\u015eEYARA(K2,Q1:R4,2,YANLI\u015e),TOPLA(O2:O9),ORTALAMA(O2:O9),MAK(O2:O9),MIN(O2:O9)) <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-36875\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-choisir-la-fonction-exemple-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-i\u015flev-se\u00e7im-\u00f6rne\u011fi-1\" width=\"764\" height=\"448\"><\/figure><\/div><p> Kar\u015f\u0131l\u0131k gelen h\u00fccrede istedi\u011fimiz d\u00f6rt hesaplaman\u0131n ad\u0131n\u0131 ve her biri i\u00e7in bir seri numaras\u0131n\u0131 i\u00e7eren bu k\u00fc\u00e7\u00fck tablomuz var.<\/p><p> Bundan sonra d\u00f6rt hesaplaman\u0131n tamam\u0131 i\u00e7in bir a\u00e7\u0131l\u0131r listemiz var. Art\u0131k bu k\u00fc\u00e7\u00fck tablodan se\u00e7im i\u015flevindeki dizin numaras\u0131n\u0131 almak i\u00e7in, a\u00e7\u0131l\u0131r listeden se\u00e7ilen de\u011fere g\u00f6re seri numaras\u0131n\u0131 d\u00f6nd\u00fcrecek bir arama form\u00fcl\u00fcm\u00fcz var.<\/p><p> Ve de\u011ferler yerine 4 farkl\u0131 hesaplama i\u00e7in 4 form\u00fcl kulland\u0131k.<\/p><h2 class=\"wp-block-heading\"> 4. S\u00dcTUN i\u015flevi<\/h2><p> <strong>COLUMN i\u015flevi, verilen h\u00fccre ba\u015fvurusu i\u00e7in s\u00fctun numaras\u0131n\u0131 d\u00f6nd\u00fcr\u00fcr.<\/strong> Bildi\u011finiz gibi her h\u00fccre referans\u0131 bir s\u00fctun numaras\u0131 ve bir sat\u0131r numaras\u0131ndan olu\u015fur. B\u00f6ylece s\u00fctun numaras\u0131n\u0131 al\u0131r ve sonu\u00e7ta d\u00f6nd\u00fcr\u00fcr.<\/p><h3 class=\"wp-block-heading\"> <strong>S\u00f6zdizimi<\/strong><\/h3><p> S\u00dcTUN([ba\u015fvuru])<\/p><h3 class=\"wp-block-heading\"> <strong>Arg\u00fcmanlar<\/strong><\/h3><ul><li> <strong>ba\u015fvuru:<\/strong> s\u00fctun numaras\u0131n\u0131 almak istedi\u011finiz h\u00fccre ba\u015fvurusu.<\/li><\/ul><h3 class=\"wp-block-heading\"> <strong>Yorumlar<\/strong><\/h3><ul><li> Birden fazla referansa referans veremezsiniz.<\/li><li> Bir diziden bahsediyorsan\u0131z, s\u00fctun i\u015flevi ayn\u0131 zamanda dizideki s\u00fctun numaralar\u0131n\u0131 da d\u00f6nd\u00fcr\u00fcr.<\/li><li> Birden fazla h\u00fccreden olu\u015fan bir aral\u0131ktan bahsediyorsan\u0131z, en soldaki h\u00fccrenin s\u00fctun numaras\u0131n\u0131 d\u00f6nd\u00fcr\u00fcr. \u00d6rne\u011fin, A1:C10 aral\u0131\u011f\u0131na ba\u015fvurursan\u0131z, A1 h\u00fccresinin s\u00fctun numaras\u0131n\u0131 d\u00f6nd\u00fcr\u00fcr.<\/li><li> Referans belirtmeyi atlarsan\u0131z ge\u00e7erli h\u00fccrenin s\u00fctun numaras\u0131n\u0131 d\u00f6nd\u00fcr\u00fcr.<\/li><\/ul><h3 class=\"wp-block-heading\"> \u00d6rnek<\/h3><p> A\u015fa\u011f\u0131daki \u00f6rnekte A1 h\u00fccresinin s\u00fctun numaras\u0131n\u0131 almak i\u00e7in COLUMN komutunu kulland\u0131k. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-36878\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-de-colonne-excel-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-s\u00fctun-i\u015flevi-\u00f6rnek-1\" width=\"516\" height=\"307\"><\/figure><\/div><p> Daha \u00f6nce de belirtti\u011fim gibi h\u00fccre referans\u0131n\u0131 g\u00f6rmezden gelirseniz mevcut h\u00fccrenin s\u00fctun numaras\u0131 d\u00f6nd\u00fcr\u00fcl\u00fcr. A\u015fa\u011f\u0131daki \u00f6rnekte seri numaralar\u0131n\u0131 i\u00e7eren bir ba\u015fl\u0131k olu\u015fturmak i\u00e7in COLUMN&#8217;i kulland\u0131k. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-36879\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-de-colonne-excel-2.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-s\u00fctun-fonksiyonu-\u00f6rnek-2\" width=\"548\" height=\"312\"><\/figure><\/div><h2 class=\"wp-block-heading\"> 5. S\u00dcTUNLAR i\u015flevi<\/h2><p> <strong>COLUMNS i\u015flevi, verilen ba\u015fvuruda ba\u015fvurulan s\u00fctunlar\u0131n say\u0131s\u0131n\u0131 d\u00f6nd\u00fcr\u00fcr.<\/strong> Basit bir ifadeyle, sa\u011flanan aral\u0131ktaki s\u00fctun say\u0131s\u0131n\u0131 sayar ve bu say\u0131y\u0131 d\u00f6nd\u00fcr\u00fcr.<\/p><h3 class=\"wp-block-heading\"> <strong>S\u00f6zdizimi<\/strong><\/h3><p> S\u00dcTUNLAR(tablo)<\/p><h3 class=\"wp-block-heading\"> <strong>Arg\u00fcmanlar<\/strong><\/h3><ul><li> <strong>tablo:<\/strong> S\u00fctun say\u0131s\u0131n\u0131 almak istedi\u011finiz bir tablo veya h\u00fccre aral\u0131\u011f\u0131.<\/li><\/ul><h3 class=\"wp-block-heading\"> <strong>Yorumlar<\/strong><\/h3><ul><li> Ayr\u0131ca adland\u0131r\u0131lm\u0131\u015f bir aral\u0131k da kullanabilirsiniz.<\/li><li> COLUMNS i\u015flevi h\u00fccrelerdeki de\u011ferlerle ilgilenmez, yaln\u0131zca bir ba\u015fvurudaki s\u00fctun say\u0131s\u0131n\u0131 d\u00f6nd\u00fcr\u00fcr.<\/li><\/ul><h3 class=\"wp-block-heading\"> \u00d6rnek<\/h3><p> A\u015fa\u011f\u0131daki \u00f6rnekte A1:F1 aral\u0131\u011f\u0131ndaki s\u00fctunlar\u0131n say\u0131s\u0131n\u0131 almak i\u00e7in COLUMN&#8217;i kulland\u0131k. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-36881\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Exemple-de-fonction-de-colonnes-Excel-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-s\u00fctunlar\u0131-i\u015flevi-\u00f6rnek-1\" width=\"529\" height=\"396\"><\/figure><\/div><h2 class=\"wp-block-heading\"> 6.FORM\u00dcLMET\u0130N i\u015flevi<\/h2><p> <strong>FORMULATEXT i\u015flevi ba\u015fvurulan h\u00fccrenin form\u00fcl\u00fcn\u00fc d\u00f6nd\u00fcr\u00fcr.<\/strong> Ba\u015fvurulan h\u00fccrede form\u00fcl, de\u011fer veya bo\u015fluk yoksa #YOK sonucunu d\u00f6nd\u00fcr\u00fcr.<\/p><h3 class=\"wp-block-heading\"> <strong>S\u00f6zdizimi<\/strong><\/h3><p> MET\u0130NFORM\u00dcL\u00dc (referans)<\/p><h3 class=\"wp-block-heading\"> <strong>Arg\u00fcmanlar<\/strong><\/h3><ul><li> <strong>ba\u015fvuru:<\/strong> Form\u00fcl\u00fc metin olarak almak istedi\u011finiz h\u00fccre ba\u015fvurusu.<\/li><\/ul><h3 class=\"wp-block-heading\"> <strong>Yorumlar<\/strong><\/h3><ul><li> Ba\u015fka bir \u00e7al\u0131\u015fma kitab\u0131na ba\u015fvuruyorsan\u0131z bu \u00e7al\u0131\u015fma kitab\u0131n\u0131n a\u00e7\u0131k olmas\u0131 gerekir, aksi takdirde form\u00fcl g\u00f6r\u00fcnt\u00fclenmez.<\/li><li> Birden fazla h\u00fccreden olu\u015fan bir aral\u0131ktan bahsediyorsan\u0131z, verilen aral\u0131\u011f\u0131n sol \u00fcst h\u00fccresinin form\u00fcl\u00fcn\u00fc d\u00f6nd\u00fcr\u00fcr.<\/li><li> Ba\u015fvuru olarak kulland\u0131\u011f\u0131n\u0131z h\u00fccre herhangi bir form\u00fcl i\u00e7ermiyorsa, 8192&#8217;den fazla karakter i\u00e7eren bir form\u00fcle sahipse, bir h\u00fccre korunuyorsa veya harici bir \u00e7al\u0131\u015fma kitab\u0131 a\u00e7\u0131k de\u011filse, &#8220;#YOK&#8221; hata de\u011ferini d\u00f6nd\u00fcr\u00fcr.<\/li><li> D\u00f6ng\u00fcsel bir ba\u015fvuruda iki h\u00fccreye ba\u015fvurursan\u0131z her ikisinin sonu\u00e7lar\u0131 d\u00f6nd\u00fcr\u00fcl\u00fcr.<\/li><\/ul><h3 class=\"wp-block-heading\"> \u00d6rnek<\/h3><p> A\u015fa\u011f\u0131daki \u00f6rnekte form\u00fcl metnini farkl\u0131 referans t\u00fcrleriyle kulland\u0131k. Form\u00fcl\u00fc olmayan bir h\u00fccreye ba\u015fvurdu\u011funuzda &#8220;#N\/A&#8221; hata de\u011feri d\u00f6nd\u00fcr\u00fcl\u00fcr. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-36924\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-de-texte-de-formule-excel-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-form\u00fclmetni-fonksiyon-\u00f6rnek-1\" width=\"439\" height=\"290\"><\/figure><\/div><h2 class=\"wp-block-heading\"> 7. ARAMA i\u015flevi<\/h2><p> <strong>YATAYARA i\u015flevi bir tablonun \u00fcst sat\u0131r\u0131nda bir de\u011fer arar ve dizin numaras\u0131n\u0131 kullanarak e\u015fle\u015fen de\u011ferin ayn\u0131 s\u00fctunundaki de\u011feri d\u00f6nd\u00fcr\u00fcr.<\/strong> Basit bir ifadeyle yatay olarak arama yapar.<\/p><h3 class=\"wp-block-heading\"> <strong>S\u00f6zdizimi<\/strong><\/h3><p> YATAYARA(aranan_de\u011fer, tablo_dizisi, sat\u0131r_indeks_say\u0131s\u0131, [aral\u0131k_arama])<\/p><h3 class=\"wp-block-heading\"> <strong>Arg\u00fcmanlar<\/strong><\/h3><ul><li> <strong>aranan_de\u011fer:<\/strong> Aramak istedi\u011finiz de\u011fer.<\/li><li> <strong>table_array:<\/strong> De\u011ferini bulmak istedi\u011finiz veri tablosu veya dizisi.<\/li><li> <strong>row_index_num:<\/strong> De\u011feri almak istedi\u011finiz \u00fcst sat\u0131r\u0131n a\u015fa\u011f\u0131s\u0131ndaki sat\u0131r say\u0131s\u0131n\u0131 temsil eden say\u0131sal bir de\u011fer. \u00d6rne\u011fin, 2 belirtirseniz ve arama de\u011feriniz veri tablosunda A10&#8217;daysa, B10 h\u00fccresindeki de\u011feri d\u00f6nd\u00fcr\u00fcr.<\/li><li> <strong>[aral\u0131k_bak]:<\/strong> Arama t\u00fcr\u00fcn\u00fc belirtmek i\u00e7in mant\u0131ksal bir de\u011fer. Tam e\u015fle\u015fme aramas\u0131 yapmak istiyorsan\u0131z FALSE&#8217;\u0131, tam e\u015fle\u015fme olmayan arama yapmak istiyorsan\u0131z TRUE&#8217;yu (varsay\u0131lan) kullan\u0131n.<\/li><\/ul><h3 class=\"wp-block-heading\"> <strong>Yorumlar<\/strong><\/h3><ul><li> Joker karakterler kullanabilirsiniz.<\/li><li> Tam e\u015fle\u015ftirme ve bulan\u0131k e\u015fle\u015ftirme yapabilirsiniz.<\/li><li> Bulan\u0131k e\u015fle\u015ftirme yaparken verileri soldan sa\u011fa do\u011fru artan \u015fekilde s\u0131ralad\u0131\u011f\u0131n\u0131zdan emin olun; veriler artan s\u0131rada de\u011filse hatal\u0131 sonu\u00e7 verir.<\/li><li> Range_lookup do\u011fruysa veya atlanm\u0131\u015fsa, tam olmayan bir e\u015fle\u015fme ger\u00e7ekle\u015ftirir ancak arama de\u011feri arama aral\u0131\u011f\u0131nda mevcutsa tam bir e\u015fle\u015fme d\u00f6nd\u00fcr\u00fcr.<\/li><li> Range_lookup do\u011fruysa veya atlanm\u0131\u015fsa ve arama de\u011feri arama aral\u0131\u011f\u0131nda de\u011filse, arama de\u011ferinden k\u00fc\u00e7\u00fck olan en yak\u0131n de\u011feri d\u00f6nd\u00fcr\u00fcr.<\/li><li> Range_lookup false ise veri aral\u0131\u011f\u0131n\u0131 s\u0131ralamaya gerek yoktur.<\/li><\/ul><h3 class=\"wp-block-heading\"> \u00d6rnek<\/h3><p> A\u015fa\u011f\u0131daki \u00f6rnekte, dinamik bir form\u00fcl olu\u015fturmak i\u00e7in KA\u00c7INCI ile YATAYARA i\u015flevini kulland\u0131k ve ard\u0131ndan h\u00fccrenin arama de\u011ferini de\u011fi\u015ftirmek i\u00e7in bir a\u00e7\u0131l\u0131r liste kulland\u0131k. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-36930\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-excel-hlookup-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-hlookup-fonksiyonu-\u00f6rnek-1\" width=\"407\" height=\"375\"><\/figure><\/div><p> Arama de\u011feri olarak C7 h\u00fccresindeki alan ad\u0131 kullan\u0131l\u0131r. Aral\u0131k B1: Tablo dizisi olarak F5 ve sat\u0131r_index_num i\u00e7in sat\u0131r numaras\u0131n\u0131 almak i\u00e7in e\u015fle\u015ftirme fonksiyonunu kulland\u0131k. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-36931\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Excel-fonction-hlookup-exemple-2.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-hlookup-fonksiyonu-\u00f6rnek-2\" width=\"460\" height=\"353\"><\/figure><\/div><p> C9 h\u00fccresindeki de\u011feri de\u011fi\u015ftirdi\u011finizde tablonun sat\u0131r numaras\u0131 d\u00f6nd\u00fcr\u00fcl\u00fcr. Form\u00fcl\u00fcn\u00fcz\u00fc tekrar tekrar de\u011fi\u015ftirmenize gerek yok. A\u00e7\u0131l\u0131r men\u00fcyle de\u011ferleri de\u011fi\u015ftirmeniz yeterlidir; bunun i\u00e7in bir de\u011fer elde edersiniz.<\/p><h2 class=\"wp-block-heading\"> 8. K\u00d6PR\u00dc i\u015flevi<\/h2><p> <strong>HYPERLINK i\u015flevi, kendisine bir k\u00f6pr\u00fc eklenmi\u015f olan bir dize d\u00f6nd\u00fcr\u00fcr.<\/strong> Basit bir ifadeyle, Excel&#8217;deki K\u00d6PR\u00dc se\u00e7ene\u011fi gibi K\u00d6PR\u00dc i\u015flevi de bir k\u00f6pr\u00fc olu\u015fturman\u0131za yard\u0131mc\u0131 olur.<\/p><h3 class=\"wp-block-heading\"> <strong>S\u00f6zdizimi<\/strong><\/h3><p> HYPERLINK(ba\u011flant\u0131_konumu;[dost_ad])<\/p><h3 class=\"wp-block-heading\"> <strong>Arg\u00fcmanlar<\/strong><\/h3><ul><li> <strong>Link_Location:<\/strong> HYPERLINK eklemek istedi\u011finiz konum. Ayr\u0131ca iki terime ayr\u0131labilir.<ol><li> <strong>ba\u011flant\u0131:<\/strong> Bu, ayn\u0131 \u00e7al\u0131\u015fma sayfas\u0131ndaki veya ba\u015fka herhangi bir \u00e7al\u0131\u015fma sayfas\u0131ndaki veya \u00e7al\u0131\u015fma kitab\u0131ndaki bir h\u00fccrenin veya bir h\u00fccre aral\u0131\u011f\u0131n\u0131n adresi olabilir. Ayr\u0131ca bir Word belgesindeki yer imini de ba\u011flayabiliriz.<\/li><li> <strong>konum:<\/strong> Bu, bir sabit s\u00fcr\u00fcc\u00fcye, UNC yolunu kullanan bir sunucuya veya \u0130nternet veya intranetten herhangi bir URL&#8217;ye ba\u011flant\u0131 olabilir. (\u00c7evrimi\u00e7i Excel&#8217;de, K\u00d6PR\u00dc i\u015flevi i\u00e7in yaln\u0131zca web adresini kullanabilirsiniz). \u0130\u015fleve bir ba\u011flant\u0131 eklemek i\u00e7in, bunu t\u0131rnak i\u015faretleriyle metin olarak ekleyerek veya ba\u011flant\u0131y\u0131 i\u00e7eren h\u00fccreye metin olarak ba\u015fvuruda bulunabilirsiniz. Bir web adresinden \u00f6nce \u201cHTTPS:\/\/\u201d kulland\u0131\u011f\u0131n\u0131zdan emin olun.<\/li><\/ol><\/li><li> <strong>[friend_name]:<\/strong> Bu, bu \u00f6zelli\u011fin iste\u011fe ba\u011fl\u0131 bir par\u00e7as\u0131d\u0131r. Ba\u011flant\u0131 ba\u011flant\u0131s\u0131n\u0131n y\u00fcz\u00fc olarak g\u00f6rev yapar.<ol><li> \u0130stedi\u011finiz t\u00fcrde metni, say\u0131y\u0131 veya her ikisini birden kullanabilirsiniz.<\/li><li> Ayr\u0131ca dost_ad\u0131 i\u00e7eren bir h\u00fccreye de at\u0131fta bulunuyorsunuz.<\/li><li> Bunu g\u00f6rmezden gelirseniz, i\u015flev g\u00f6r\u00fcnt\u00fclemek i\u00e7in ba\u011flant\u0131 adresini kullanacakt\u0131r.<\/li><li> Dost_ad\u0131 bir hata d\u00f6nd\u00fcr\u00fcrse, i\u015flev bir hata g\u00f6r\u00fcnt\u00fcleyecektir.<\/li><\/ol><\/li><\/ul><h3 class=\"wp-block-heading\"> <strong>Yorumlar<\/strong><\/h3><ul><li> <strong>Bir web adresine kaydedilen bir dosyay\u0131 ba\u011flay\u0131n:<\/strong> Bir web adresine kaydedilen bir dosyay\u0131 kullanabilirsiniz. Bu, dosyay\u0131 verimli bir \u015fekilde payla\u015fmam\u0131za yard\u0131mc\u0131 olur.<\/li><li> <strong>Sabit s\u00fcr\u00fcc\u00fcye kay\u0131tl\u0131 bir dosyay\u0131 ba\u011flay\u0131n:<\/strong> Bu i\u015flevi \u00e7evrimd\u0131\u015f\u0131 \u00e7al\u0131\u015f\u0131rken de kullanabilirsiniz. Sabit s\u00fcr\u00fcc\u00fcn\u00fczde depolanan bir dosyay\u0131 ba\u011flayabilir ve tek bir Excel sayfan\u0131z arac\u0131l\u0131\u011f\u0131yla bu dosyaya eri\u015febilirsiniz; a\u00e7mak i\u00e7in her klas\u00f6re gitmenize gerek yoktur.<\/li><li> <strong>Word Belge Dosyas\u0131n\u0131 Ba\u011fla:<\/strong> Bu ayn\u0131 zamanda HYPERLINK \u00f6zelli\u011finin harika bir \u00f6zelli\u011fidir. Bir yer imi kullanarak bir Word belge dosyas\u0131n\u0131 veya bir Word belge dosyas\u0131ndaki belirli bir konumu ba\u011flayabilirsiniz.<\/li><li> <strong>Kolay bir ad kullanmadan bir dosyay\u0131 ba\u011flay\u0131n:<\/strong> Dosyaya veya konuma ger\u00e7ek ba\u011flant\u0131y\u0131 kullan\u0131c\u0131ya g\u00f6r\u00fcnt\u00fclemek istiyorsan\u0131z. Bu durumda, HYPERLINK i\u015flevindeki kolay ad bildirimini g\u00f6z ard\u0131 etmeniz yeterlidir.<\/li><\/ul><h2 class=\"wp-block-heading\"> 9. DOLAYLI i\u015flev<\/h2><p> <strong>INDIRECT i\u015flevi, bir h\u00fccre ba\u015fvurusunu temsil eden bir metin dizesinden ge\u00e7erli bir ba\u015fvuru d\u00f6nd\u00fcr\u00fcr.<\/strong> Basit bir ifadeyle, h\u00fccre adresini metin de\u011feri olarak kullanarak bir h\u00fccre aral\u0131\u011f\u0131na ba\u015fvurabilirsiniz.<\/p><h3 class=\"wp-block-heading\"> <strong>S\u00f6zdizimi<\/strong><\/h3><p> DOLAYLI(ref_metin; [a1])<\/p><h3 class=\"wp-block-heading\"> <strong>Arg\u00fcmanlar<\/strong><\/h3><ul><li> <strong>ref_text:<\/strong> bir h\u00fccrenin adresini, bir h\u00fccre aral\u0131\u011f\u0131n\u0131n adresini, adland\u0131r\u0131lm\u0131\u015f bir aral\u0131\u011f\u0131 veya bir tablo ad\u0131n\u0131 temsil eden metin. \u00d6rne\u011fin, A1, B10:B20 veya MyRange.<\/li><li> <strong>[a1]:<\/strong> Ba\u015fvuru_metni&#8217;nde belirtti\u011finiz h\u00fccre ba\u015fvuru t\u00fcr\u00fcn\u00fc temsil eden bir say\u0131 veya Boolean de\u011feri. <strong>\u00d6rne\u011fin,<\/strong> A1 referans stilini kullanmak istiyorsan\u0131z TRUE veya 1&#8217;i, R1C1 referans stilini kullanmak istiyorsan\u0131z R1C referans stili i\u00e7in FALSE veya 0&#8217;\u0131 kullan\u0131n. H\u00fccre referans t\u00fcr\u00fcn\u00fc belirtmezseniz varsay\u0131lan olarak A1 stilini kullanacakt\u0131r.<\/li><\/ul><h3 class=\"wp-block-heading\"> <strong>Yorumlar<\/strong><\/h3><ul><li> Ba\u015fka bir \u00e7al\u0131\u015fma kitab\u0131na ba\u015fvurdu\u011funuzda bu \u00e7al\u0131\u015fma kitab\u0131n\u0131n a\u00e7\u0131lmas\u0131 gerekir.<\/li><li> Ba\u015fvuruda bulundu\u011funuz aral\u0131\u011fa bir sat\u0131r veya s\u00fctun eklerseniz, INDIRECT bu ba\u015fvuruyu g\u00fcncellemez.<\/li><li> Metni do\u011frudan fonksiyona eklemek istiyorsan\u0131z, metni \u00e7ift t\u0131rnak i\u00e7ine alman\u0131z gerekir veya referans olarak kullanmak istedi\u011finiz metni i\u00e7eren bir h\u00fccreye de referans verebilirsiniz.<\/li><\/ul><h3 class=\"wp-block-heading\"> \u00d6rnek<\/h3><h4 class=\"wp-block-heading\"> <strong>1. Ba\u015fka bir \u00e7al\u0131\u015fma sayfas\u0131na referans<\/strong><\/h4><p> Ayr\u0131ca INDIRECT kullanarak ba\u015fka bir \u00e7al\u0131\u015fma sayfas\u0131na da ba\u015fvurabilirsiniz ve \u00e7al\u0131\u015fma sayfas\u0131n\u0131n ad\u0131n\u0131 buraya eklemeniz gerekir. A\u015fa\u011f\u0131daki \u00f6rnekte, ba\u015fka bir \u00e7al\u0131\u015fma sayfas\u0131na ba\u015fvuruda bulunmak ve sayfa ad\u0131n\u0131 A2 h\u00fccresinde ve h\u00fccre ba\u015fvurusunu B2 h\u00fccresinde bulundurmak i\u00e7in dolayl\u0131 i\u015flevi kulland\u0131k. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-37064\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-fonction-indirecte-exemple-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-dolayl\u0131-i\u015flev-\u00f6rnek-1\" width=\"499\" height=\"238\"><\/figure><\/div><p> C2 h\u00fccresinde metni birle\u015ftirmek i\u00e7in a\u015fa\u011f\u0131daki form\u00fcl\u00fc kulland\u0131k.<\/p><p> =DOLAYLI(\u201c&#8217;\u201d&amp;A2&amp;\u201d&#8217;!\u201d&amp;B2)<\/p><p> Bu kombinasyon, INDIRECT i\u015flevi taraf\u0131ndan sayfa1&#8217;deki A1 h\u00fccresine at\u0131fta bulunmak i\u00e7in kullan\u0131lan metni olu\u015fturur ve en iyi yan\u0131, \u00e7al\u0131\u015fma sayfas\u0131n\u0131n ad\u0131n\u0131 veya h\u00fccre adresini de\u011fi\u015ftirdi\u011finizde referans\u0131n otomatik olarak de\u011fi\u015fmesidir.<\/p><p> &#8220;Sayfa1&#8243;deki A1 h\u00fccresi &#8220;Evet&#8221; de\u011ferine sahiptir ve bu nedenle dolayl\u0131 olarak &#8220;Evet&#8221; de\u011ferini d\u00f6nd\u00fcr\u00fcr.<\/p><h4 class=\"wp-block-heading\"> <strong>2. Ba\u015fka bir \u00e7al\u0131\u015fma kitab\u0131na referans<\/strong><\/h4><p> Ba\u015fka bir \u00e7al\u0131\u015fma sayfas\u0131na yapt\u0131\u011f\u0131m\u0131z gibi, ba\u015fka bir \u00e7al\u0131\u015fma kitab\u0131na da ba\u015fvurabilirsiniz. Tek yapman\u0131z gereken, metninize referans olarak kulland\u0131\u011f\u0131n\u0131z bir \u00e7al\u0131\u015fma kitab\u0131 ad\u0131n\u0131 eklemektir. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-37065\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-indirecte-excel-2.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-dolayl\u0131-i\u015flev-\u00f6rnek-2\" width=\"574\" height=\"350\"><\/figure><\/div><p> Yukar\u0131daki \u00f6rnekte \u201cKitap1\u201d \u00e7al\u0131\u015fma kitab\u0131n\u0131n A1 h\u00fccresinin de\u011ferini elde etmek i\u00e7in a\u015fa\u011f\u0131daki form\u00fcl\u00fc kulland\u0131k.<\/p><p> =DOLAYLI(\u201c[\u201c&amp;A2&amp;\u201d]\u201d&amp;B2&amp;\u201d!\u201d&amp;C2)<\/p><p> \u201cA2\u201d h\u00fccresinde \u00e7al\u0131\u015fma kitab\u0131 ad\u0131m\u0131z, \u201cB2\u201d h\u00fccresinde \u00e7al\u0131\u015fma sayfas\u0131 ad\u0131 ve \u201cC2\u201d h\u00fccresinde h\u00fccre ad\u0131m\u0131z oldu\u011fundan. Dolayl\u0131 bir i\u015flevde girdi metni olarak kullanmak i\u00e7in bunlar\u0131 birle\u015ftiriyoruz.<\/p><p class=\"qt-tip\"> <strong>Not:<\/strong> Bir h\u00fccre referans\u0131n\u0131 metin olarak birle\u015ftirirken do\u011fru referans yap\u0131s\u0131n\u0131 izledi\u011finizden emin olun.<\/p><h4 class=\"wp-block-heading\"> <strong>3. Adland\u0131r\u0131lm\u0131\u015f Aral\u0131klar\u0131 Kullanma<\/strong><\/h4><p> Evet, dolayl\u0131 i\u015flevi kullanarak adland\u0131r\u0131lm\u0131\u015f bir aral\u0131\u011fa da ba\u015fvurabilirsiniz. Basit. Adland\u0131r\u0131lm\u0131\u015f bir aral\u0131k olu\u015fturdu\u011funuzda, bu adland\u0131r\u0131lm\u0131\u015f aral\u0131\u011f\u0131 DOLAYLI olarak metin olarak girmelisiniz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-37066\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-fonction-indirecte-exemple-3.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-dolayl\u0131-i\u015flev-\u00f6rnek-3\" width=\"583\" height=\"257\"><\/figure><\/div><p> Yukar\u0131daki \u00f6rnekte, E1 h\u00fccresinde adland\u0131r\u0131lm\u0131\u015f aral\u0131klar\u0131n listesini i\u00e7eren bir a\u00e7\u0131l\u0131r listemiz var ve E2 h\u00fccresinde bu ad\u0131 kulland\u0131k. B2:B5 aral\u0131\u011f\u0131 \u201cMiktar\u201d, C2:C5 aral\u0131\u011f\u0131 ise \u201cTutar\u201d olarak adland\u0131r\u0131lmaktad\u0131r.<\/p><p> A\u00e7\u0131l\u0131r listeden bir miktar se\u00e7ti\u011finizde, dolayl\u0131 i\u015flev an\u0131nda adland\u0131r\u0131lm\u0131\u015f aral\u0131\u011fa ba\u015fvurur. A\u00e7\u0131l\u0131r men\u00fcden tutar\u0131 se\u00e7ti\u011finizde, C2:C5 h\u00fccre aral\u0131\u011f\u0131n\u0131n toplam\u0131na sahip olacaks\u0131n\u0131z.<\/p><h2 class=\"wp-block-heading\"> 11. ARAMA fonksiyonu<\/h2><p> <strong>SEARCH i\u015flevi bir sat\u0131r, s\u00fctun veya tablodan (arad\u0131\u011f\u0131n\u0131z) bir de\u011feri d\u00f6nd\u00fcr\u00fcr<\/strong> . Basit bir ifadeyle, bir de\u011fer arayabilirsiniz ve SEARCH, o sat\u0131rda, s\u00fctunda veya tablodaysa bu de\u011feri d\u00f6nd\u00fcr\u00fcr.<\/p><h3 class=\"wp-block-heading\"> <strong>S\u00f6zdizimi<\/strong><\/h3><p> SEARCH(de\u011fer; arama_aral\u0131\u011f\u0131; [sonu\u00e7_aral\u0131\u011f\u0131])<\/p><p> \u0130ki t\u00fcr ARAMA i\u015flevi vard\u0131r.<\/p><ul><li> vekt\u00f6r \u015fekli<\/li><li> Tablo formu<\/li><\/ul><h3 class=\"wp-block-heading\"> <strong>Arg\u00fcmanlar<\/strong><\/h3><ul><li> <strong>de\u011fer:<\/strong> bir s\u00fctunda veya sat\u0131rda aramak istedi\u011finiz de\u011fer.<\/li><li> <strong>aranan_aral\u0131k:<\/strong> De\u011feri aramak istedi\u011finiz s\u00fctun veya sat\u0131r.<\/li><li> <strong>[sonu\u00e7_aral\u0131\u011f\u0131]:<\/strong> De\u011fer d\u00f6nd\u00fcrmek istedi\u011finiz s\u00fctun veya sat\u0131r. Bu iste\u011fe ba\u011fl\u0131 bir arg\u00fcmand\u0131r.<\/li><\/ul><h3 class=\"wp-block-heading\"> <strong>Yorumlar<\/strong><\/h3><ul><li> Dizi formunu kullanmak yerine D\u00dc\u015eEYARA veya YATAYARA kullanmak daha iyidir.<\/li><\/ul><h2 class=\"wp-block-heading\"> 12.E\u015eLE\u015eT\u0130RME i\u015flevi<\/h2><p> <strong>MATCH i\u015flevi bir dizi de\u011ferinin dizin numaras\u0131n\u0131 d\u00f6nd\u00fcr\u00fcr.<\/strong> Basit bir ifadeyle, MATCH i\u015flevi listede bir de\u011fer arar ve bu de\u011ferin listedeki konum numaras\u0131n\u0131 d\u00f6nd\u00fcr\u00fcr.<\/p><h3 class=\"wp-block-heading\"> <strong>S\u00f6zdizimi<\/strong><\/h3><p> KA\u00c7INCI (aranan_de\u011fer, aranan_dizi, [e\u015fle\u015fme_t\u00fcr\u00fc])<\/p><h3 class=\"wp-block-heading\"> <strong>Arg\u00fcmanlar<\/strong><\/h3><ul><li> <strong>aranan_de\u011fer<\/strong> : De\u011ferler listesinden konumunu almak istedi\u011finiz de\u011fer.<\/li><li> <strong>Lookup_array<\/strong> : H\u00fccre aral\u0131\u011f\u0131 veya dizi de\u011ferleri i\u00e7erir.<\/li><li> <strong>[match_type]<\/strong> : Excel&#8217;in de\u011ferler listesinde de\u011feri nas\u0131l arayaca\u011f\u0131n\u0131 belirten say\u0131 (-1, 0 ve 1).<ol><li> 1 kullan\u0131rsan\u0131z, arama de\u011ferine e\u015fit veya ondan k\u00fc\u00e7\u00fck en b\u00fcy\u00fck de\u011feri d\u00f6nd\u00fcr\u00fcr. Listedeki de\u011ferler artan d\u00fczende s\u0131ralanmal\u0131d\u0131r.<\/li><li> -1 kullan\u0131rsan\u0131z, arama de\u011ferine e\u015fit veya ondan b\u00fcy\u00fck en k\u00fc\u00e7\u00fck de\u011feri d\u00f6nd\u00fcr\u00fcr. Listedeki de\u011ferler artan d\u00fczende s\u0131ralanmal\u0131d\u0131r.<\/li><li> 0 kullan\u0131rsan\u0131z listenin tam e\u015fle\u015fmesini d\u00f6nd\u00fcr\u00fcr.<\/li><\/ol><\/li><\/ul><h3 class=\"wp-block-heading\"> <strong>Yorumlar<\/strong><\/h3><ul><li> <a href=\"https:\/\/exceladvisor.org\/tr\/joker-karakterler-2\/\" data-wpil=\"url\">Joker karakterler<\/a> kullanabilirsiniz.<\/li><li> Listede e\u015fle\u015fen de\u011fer yoksa, #N\/A de\u011ferini d\u00f6nd\u00fcr\u00fcr.<\/li><li> E\u015fle\u015ftirme i\u015flevi b\u00fcy\u00fck\/k\u00fc\u00e7\u00fck harfe duyarl\u0131 de\u011fildir.<\/li><\/ul><h3 class=\"wp-block-heading\"> \u00d6rnek<\/h3><p> A\u015fa\u011f\u0131daki \u00f6rnekte e\u015fleme t\u00fcr\u00fc olarak 1&#8217;i kulland\u0131k ve 5 de\u011ferini ar\u0131yoruz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-37128\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-de-correspondance-excel-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-e\u015fle\u015fme-i\u015flevi-\u00f6rnek-1\" width=\"401\" height=\"466\"><\/figure><\/div><p> Daha \u00f6nce de belirtti\u011fim gibi e\u015fleme t\u00fcr\u00fcnde 1 kullan\u0131rsan\u0131z arama de\u011ferine e\u015fit veya ondan k\u00fc\u00e7\u00fck en b\u00fcy\u00fck de\u011feri d\u00f6nd\u00fcr\u00fcr. Listenin tamam\u0131nda 5&#8217;ten k\u00fc\u00e7\u00fck 3, en y\u00fcksek de\u011fer ise 4&#8217;t\u00fcr.<\/p><p> Bu nedenle sonu\u00e7ta 4 de\u011ferinin konumu olan 3 de\u011ferini d\u00f6nd\u00fcrd\u00fc.<\/p><h2 class=\"wp-block-heading\"> 13. Shift i\u015flevi<\/h2><p> <strong>OFFSET i\u015flevi, bir h\u00fccreden veya h\u00fccre aral\u0131\u011f\u0131ndan belirli say\u0131da sat\u0131r ve s\u00fctun uzakta olan bir aral\u0131\u011fa ba\u015fvuru d\u00f6nd\u00fcr\u00fcr.<\/strong> Basit bir ifadeyle, bir ba\u015flang\u0131\u00e7 h\u00fccresinden ba\u015flayarak sat\u0131rlar\u0131 ve s\u00fctunlar\u0131 kullanarak bir h\u00fccreye veya h\u00fccre aral\u0131\u011f\u0131na ba\u015fvurabilirsiniz.<\/p><h3 class=\"wp-block-heading\"> <strong>S\u00f6zdizimi<\/strong><\/h3><p> OFFSET(referans, sat\u0131rlar, s\u00fctunlar, [y\u00fckseklik], [geni\u015flik])<\/p><h3 class=\"wp-block-heading\"> <strong>Arg\u00fcmanlar<\/strong><\/h3><ul><li> <strong>referans<\/strong> : Ba\u015flamak i\u00e7in dengelemek istedi\u011finiz referans. Bir h\u00fccre veya bir dizi biti\u015fik h\u00fccre olabilir.<\/li><li> <strong>sat\u0131rlar<\/strong> : OFFSET&#8217;e referanstan yukar\u0131 veya a\u015fa\u011f\u0131 hareket etmesini s\u00f6yleyen sat\u0131r say\u0131s\u0131. A\u015fa\u011f\u0131 inmek i\u00e7in pozitif bir say\u0131ya, yukar\u0131 \u00e7\u0131kmak i\u00e7in ise negatif bir say\u0131ya ihtiyac\u0131n\u0131z vard\u0131r.<\/li><li> <strong>cols<\/strong> : S\u00fctun say\u0131s\u0131 OFFSET&#8217;e referanstan sola veya sa\u011fa hareket etmesini s\u00f6yler. Sa\u011fa gitmek i\u00e7in pozitif bir say\u0131ya, sola gitmek i\u00e7in ise negatif bir say\u0131ya ihtiyac\u0131n\u0131z vard\u0131r.<\/li><li> <strong>[y\u00fckseklik]<\/strong> : referansa hangi sat\u0131rlar\u0131n dahil edilece\u011fini belirten bir say\u0131.<\/li><li> <strong>[geni\u015flik]:<\/strong> Referansa hangi s\u00fctunlar\u0131n dahil edilece\u011fini belirten bir say\u0131.<\/li><\/ul><h3 class=\"wp-block-heading\"> <strong>Yorumlar<\/strong><\/h3><ul><li> OFFSET &#8220;ge\u00e7ici&#8221; bir i\u015flevdir; elektronik tabloda her de\u011fi\u015fiklik oldu\u011funda yeniden hesaplama yapar.<\/li><li> #REF! ofset \u00e7al\u0131\u015fma sayfas\u0131n\u0131n kenar\u0131n\u0131n d\u0131\u015f\u0131ndaysa hata de\u011feri.<\/li><li> Y\u00fckseklik veya geni\u015flik atlan\u0131rsa referans y\u00fckseklik ve geni\u015flik kullan\u0131l\u0131r.<\/li><\/ul><h3 class=\"wp-block-heading\"> \u00d6rnek<\/h3><p> A\u015fa\u011f\u0131daki \u00f6rnekte, belirli bir \u00fcr\u00fcn i\u00e7in t\u00fcm aylar\u0131n de\u011ferlerini toplayan dinamik bir aral\u0131k olu\u015fturmak i\u00e7in SUM ile OFFSET&#8217;i kulland\u0131k. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-37223\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-de-decalage-excel-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-offset-fonksiyon-\u00f6rnek-1\" width=\"676\" height=\"364\"><\/figure><\/div><h2 class=\"wp-block-heading\"> 14. HAT i\u015flevi<\/h2><p> <strong>ROW i\u015flevi ba\u015fvurulan h\u00fccrenin sat\u0131r numaras\u0131n\u0131 d\u00f6nd\u00fcr\u00fcr.<\/strong> Basit bir ifadeyle SATIR fonksiyonu ile bir h\u00fccrenin sat\u0131r numaras\u0131n\u0131 alabilirsiniz ve e\u011fer herhangi bir h\u00fccreye at\u0131fta bulunmuyorsan\u0131z, ekledi\u011finiz h\u00fccrenin sat\u0131r numaras\u0131n\u0131 d\u00f6nd\u00fcr\u00fcr.<\/p><h3 class=\"wp-block-heading\"> <strong>S\u00f6zdizimi<\/strong><\/h3><p> SATIR([ba\u015fvuru])<\/p><h3 class=\"wp-block-heading\"> <strong>Arg\u00fcmanlar<\/strong><\/h3><ul><li> <strong>ba\u015fvuru:<\/strong> Sat\u0131r numaras\u0131n\u0131 kontrol etmek istedi\u011finiz h\u00fccre ba\u015fvurusu veya h\u00fccre aral\u0131\u011f\u0131.<\/li><\/ul><h3 class=\"wp-block-heading\"> <strong>Yorumlar<\/strong><\/h3><ul><li> T\u00fcm sayfa t\u00fcrlerini (grafik sayfas\u0131, \u00e7al\u0131\u015fma sayfas\u0131 veya makro sayfas\u0131) i\u00e7erecektir.<\/li><li> Foliolara g\u00f6r\u00fcn\u00fcr, gizli veya \u00e7ok gizli olsalar bile ba\u015fvurabilirsiniz.<\/li><li> Fonksiyonda herhangi bir de\u011fer belirtmezseniz size fonksiyonu uygulad\u0131\u011f\u0131n\u0131z sayfan\u0131n sayfa numaras\u0131n\u0131 verecektir.<\/li><li> Ge\u00e7ersiz bir sayfa ad\u0131 belirtirseniz #YOK sonucunu d\u00f6nd\u00fcr\u00fcr.<\/li><li> Ge\u00e7ersiz bir sayfa referans\u0131 belirtirseniz #REF! sonucunu d\u00f6nd\u00fcr\u00fcr.<\/li><\/ul><h3 class=\"wp-block-heading\"> \u00d6rnek<\/h3><p> A\u015fa\u011f\u0131daki \u00f6rnekte, fonksiyonu kulland\u0131\u011f\u0131m\u0131z h\u00fccrenin sat\u0131r numaras\u0131n\u0131 kontrol etmek i\u00e7in sat\u0131r fonksiyonunu kulland\u0131k. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-37258\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-de-ligne-excel-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-sat\u0131r\u0131-fonksiyonu-\u00f6rnek-1\" width=\"424\" height=\"296\"><\/figure><\/div><p> A\u015fa\u011f\u0131daki \u00f6rnekte, o h\u00fccrenin sat\u0131r numaras\u0131n\u0131 almak i\u00e7in ba\u015fka bir h\u00fccreye referans verdik. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-37259\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-de-ligne-excel-2.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-sat\u0131r\u0131-fonksiyonu-\u00f6rnek-2\" width=\"430\" height=\"283\"><\/figure><\/div><p> E-tablonuzda seri numaralar\u0131n\u0131n bir listesini olu\u015fturmak i\u00e7in sat\u0131r i\u015flevini kullanabilirsiniz. Tek yapman\u0131z gereken bir h\u00fccreye sat\u0131r fonksiyonlar\u0131n\u0131 girmek ve bunu seri numaralar\u0131n\u0131 eklemek istedi\u011finiz h\u00fccreye s\u00fcr\u00fcklemektir. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-37260\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-de-ligne-excel-3.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-line-fonksiyon-\u00f6rnek-3\" width=\"341\" height=\"534\"><\/figure><\/div><h2 class=\"wp-block-heading\"> 15. HATLAR i\u015flevi<\/h2><p> <strong>SATIRLAR i\u015flevi, ba\u015fvurulan aral\u0131ktaki sat\u0131r say\u0131s\u0131n\u0131 d\u00f6nd\u00fcr\u00fcr.<\/strong> Basit bir deyi\u015fle, SATIRLAR i\u015fleviyle, bahsetti\u011finiz aral\u0131ktaki sat\u0131r say\u0131s\u0131n\u0131 sayabilirsiniz.<\/p><h3 class=\"wp-block-heading\"> <strong>S\u00f6zdizimi<\/strong><\/h3><p> HATLAR (tablo)<\/p><h3 class=\"wp-block-heading\"> <strong>Arg\u00fcmanlar<\/strong><\/h3><ul><li> <strong>dizi:<\/strong> Sat\u0131r say\u0131s\u0131n\u0131 kontrol etmek i\u00e7in bir h\u00fccre referans\u0131 veya dizi.<\/li><\/ul><h3 class=\"wp-block-heading\"> <strong>Yorumlar<\/strong><\/h3><ul><li> Ayr\u0131ca adland\u0131r\u0131lm\u0131\u015f bir aral\u0131k da kullanabilirsiniz.<\/li><li> H\u00fccrelerdeki de\u011ferlerle ilgilenmez, sadece bir referanstaki sat\u0131r say\u0131s\u0131n\u0131 d\u00f6nd\u00fcr\u00fcr.<\/li><\/ul><h3 class=\"wp-block-heading\"> \u00d6rnek<\/h3><p> A\u015fa\u011f\u0131daki \u00f6rnekte, 10 h\u00fccrelik dikey bir aral\u0131\u011fa ba\u015fvurduk ve aral\u0131k 10 sat\u0131rdan olu\u015ftu\u011fu i\u00e7in sonu\u00e7ta 10 de\u011ferini d\u00f6nd\u00fcrd\u00fc. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-39428\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-de-lignes-excel.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel sat\u0131r i\u015flevi \u00f6rne\u011fi\" width=\"510\" height=\"448\"><\/figure><\/div><h2 class=\"wp-block-heading\"> 16. TRANSPOSE i\u015flevi<\/h2><p id=\"content-box-grey\"> <strong>TRANSPOSE i\u015flevi bir aral\u0131\u011f\u0131n y\u00f6n\u00fcn\u00fc de\u011fi\u015ftirir.<\/strong> Basit bir deyi\u015fle, bu i\u015flevi kullanarak verileri bir sat\u0131rdan bir s\u00fctuna ve bir s\u00fctundan bir sat\u0131ra de\u011fi\u015ftirebilirsiniz.<\/p><h3 class=\"wp-block-heading\"> <strong>S\u00f6zdizimi<\/strong><\/h3><p> TRANSPOSE (tablo)<\/p><h3 class=\"wp-block-heading\"> <strong>Arg\u00fcmanlar<\/strong><\/h3><ul><li> <strong>dizi:<\/strong> Yerini de\u011fi\u015ftirmek istedi\u011finiz dizi veya aral\u0131k.<\/li><\/ul><h3 class=\"wp-block-heading\"> <strong>Yorumlar<\/strong><\/h3><ul><li> Ctrl+Shift+Enter tu\u015flar\u0131na basarak kaynak aral\u0131\u011f\u0131n\u0131zdaki ayn\u0131 say\u0131da h\u00fccreyi kullanarak TRANSPOSE&#8217;u bir dizi i\u015flevi olarak uygulaman\u0131z gerekir.<\/li><li> Kaynak aral\u0131\u011f\u0131ndan daha k\u00fc\u00e7\u00fck h\u00fccreleri se\u00e7erseniz veriler yaln\u0131zca bu h\u00fccrelere aktar\u0131lacakt\u0131r.<\/li><\/ul><h3 class=\"wp-block-heading\"> \u00d6rnek<\/h3><p> Burada verileri B2:D4 aral\u0131\u011f\u0131ndan G2 ila I4 aral\u0131\u011f\u0131na aktarmam\u0131z gerekir: <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-37352\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-de-transposition-excel-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-transpoze-fonksiyon-\u00f6rnek-1\" width=\"555\" height=\"268\"><\/figure><\/div><p> Bunun i\u00e7in \u00f6ncelikle G2 h\u00fccresine gidip I4\u2019e kadar olan h\u00fccre aral\u0131\u011f\u0131n\u0131 se\u00e7memiz gerekiyor. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-37353\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-fonction-de-transposition-exemple-2.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-transpoze-fonksiyon-\u00f6rnek-2\" width=\"565\" height=\"288\"><\/figure><\/div><p> Daha sonra, G2 h\u00fccresine (=TRANSPOSE(B2:D4)) yaz\u0131n ve Ctrl+Shift+Enter tu\u015flar\u0131na bas\u0131n. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-37354\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-fonction-de-transposition-exemple-3.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-transpoze-fonksiyon-\u00f6rnek-3\" width=\"577\" height=\"282\"><\/figure><\/div><p> TRANSPOSE, verileri sat\u0131rlardan s\u00fctunlara d\u00f6n\u00fc\u015ft\u00fcrecek ve uygulad\u0131\u011f\u0131m\u0131z form\u00fcl bir dizi form\u00fcl\u00fc, tek bir h\u00fccresini de\u011fi\u015ftiremezsiniz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-37355\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/excel-fonction-de-transposition-exemple-4.png\" sizes=\"auto, \" srcset=\"\" alt=\"excel-transpoze-fonksiyon-\u00f6rnek-4\" width=\"568\" height=\"270\"><\/figure><\/div>","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-2112","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Excel&#039;de arama i\u015flevleri nas\u0131l kullan\u0131l\u0131r?<\/title>\n<meta name=\"description\" content=\"Bu yaz\u0131m\u0131zda en iyi 17 Excel arama fonksiyonunu \u00f6rneklerle listeledik.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/exceladvisor.org\/tr\/excel-arama-fonksiyonlari\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel&#039;de arama i\u015flevleri nas\u0131l kullan\u0131l\u0131r?\" \/>\n<meta property=\"og:description\" content=\"Bu yaz\u0131m\u0131zda en iyi 17 Excel arama fonksiyonunu \u00f6rneklerle listeledik.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/tr\/excel-arama-fonksiyonlari\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-10T06:00:11+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-dadresse-excel-1.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Tahmini okuma s\u00fcresi\" \/>\n\t<meta name=\"twitter:data1\" content=\"19 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/excel-arama-fonksiyonlari\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/excel-arama-fonksiyonlari\/\",\"name\":\"Excel&#39;de arama i\u015flevleri nas\u0131l kullan\u0131l\u0131r?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/excel-arama-fonksiyonlari\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/excel-arama-fonksiyonlari\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-dadresse-excel-1.png\",\"datePublished\":\"2023-10-15T12:42:55+00:00\",\"dateModified\":\"2023-12-10T06:00:11+00:00\",\"description\":\"Bu yaz\u0131m\u0131zda en iyi 17 Excel arama fonksiyonunu \u00f6rneklerle listeledik.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/excel-arama-fonksiyonlari\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/tr\/excel-arama-fonksiyonlari\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/excel-arama-fonksiyonlari\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-dadresse-excel-1.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-dadresse-excel-1.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/excel-arama-fonksiyonlari\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/exceladvisor.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel&#39;de arama i\u015flevleri nas\u0131l kullan\u0131l\u0131r?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/#website\",\"url\":\"https:\/\/exceladvisor.org\/tr\/\",\"name\":\"Excel Advisor\",\"description\":\"Veri hakimiyetine y\u00f6nelik nihai rehberiniz!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/tr\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"tr\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/tr\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/tr\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel&#39;de arama i\u015flevleri nas\u0131l kullan\u0131l\u0131r?","description":"Bu yaz\u0131m\u0131zda en iyi 17 Excel arama fonksiyonunu \u00f6rneklerle listeledik.","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:\/\/exceladvisor.org\/tr\/excel-arama-fonksiyonlari\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel&#39;de arama i\u015flevleri nas\u0131l kullan\u0131l\u0131r?","og_description":"Bu yaz\u0131m\u0131zda en iyi 17 Excel arama fonksiyonunu \u00f6rneklerle listeledik.","og_url":"https:\/\/exceladvisor.org\/tr\/excel-arama-fonksiyonlari\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-10T06:00:11+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-dadresse-excel-1.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tahmini okuma s\u00fcresi":"19 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/tr\/excel-arama-fonksiyonlari\/","url":"https:\/\/exceladvisor.org\/tr\/excel-arama-fonksiyonlari\/","name":"Excel&#39;de arama i\u015flevleri nas\u0131l kullan\u0131l\u0131r?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/tr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/tr\/excel-arama-fonksiyonlari\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/tr\/excel-arama-fonksiyonlari\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-dadresse-excel-1.png","datePublished":"2023-10-15T12:42:55+00:00","dateModified":"2023-12-10T06:00:11+00:00","description":"Bu yaz\u0131m\u0131zda en iyi 17 Excel arama fonksiyonunu \u00f6rneklerle listeledik.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/tr\/excel-arama-fonksiyonlari\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/tr\/excel-arama-fonksiyonlari\/"]}]},{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/exceladvisor.org\/tr\/excel-arama-fonksiyonlari\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-dadresse-excel-1.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-dadresse-excel-1.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/tr\/excel-arama-fonksiyonlari\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/exceladvisor.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Excel&#39;de arama i\u015flevleri nas\u0131l kullan\u0131l\u0131r?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/tr\/#website","url":"https:\/\/exceladvisor.org\/tr\/","name":"Excel Advisor","description":"Veri hakimiyetine y\u00f6nelik nihai rehberiniz!","publisher":{"@id":"https:\/\/exceladvisor.org\/tr\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/tr\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"tr"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/tr\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/tr\/","logo":{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/exceladvisor.org\/tr\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/tr\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/tr\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/tr\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/2112","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/comments?post=2112"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/2112\/revisions"}],"predecessor-version":[{"id":2386,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/2112\/revisions\/2386"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/media?parent=2112"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}