{"id":2054,"date":"2023-10-22T06:31:46","date_gmt":"2023-10-22T06:31:46","guid":{"rendered":"https:\/\/exceladvisor.org\/tr\/geriye-dogru-arama\/"},"modified":"2023-12-10T06:04:24","modified_gmt":"2023-12-10T06:04:24","slug":"geriye-dogru-arama","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/tr\/geriye-dogru-arama\/","title":{"rendered":"Index-match ile excel&#39;de d\u00fc\u015feyara nas\u0131l tersine \u00e7evrilir?"},"content":{"rendered":"<div class=\"excel-icerikten-once\" id=\"excel-2063318095\"><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>INDEX ve MATCH&#8217;in geriye do\u011fru arama form\u00fcl\u00fc olarak nas\u0131l \u00e7al\u0131\u015ft\u0131\u011f\u0131n\u0131 anlamak i\u00e7in basit bir \u015fey se\u00e7meniz gerekir: <strong>Match, dizine bir s\u00fctun veya sat\u0131rdaki bir de\u011ferin konumunu (h\u00fccre numaras\u0131) bildirir, ard\u0131ndan dizin bu de\u011feri d\u00f6nd\u00fcr\u00fcr. Bu konumu kullanarak de\u011fer (h\u00fccre numaras\u0131)<\/strong> .<\/p><p> \u015e\u00f6yle d\u00fc\u015f\u00fcn\u00fcn, MATCH fonksiyonu su\u00e7luyu bulan gizli bir ajan, INDEX fonksiyonu ise daha sonra o su\u00e7luyu tutuklayan bir polis. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/correspondance-dindex-obtenir-la-valeur-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"indeks-e\u015fle\u015fme-alma-de\u011feri\" width=\"811\" height=\"249\"><\/figure><\/div><p> Ancak gelin bu iki i\u015flevi nas\u0131l birle\u015ftirebilece\u011fimizi detayl\u0131 olarak \u00f6\u011frenelim. A\u015fa\u011f\u0131da bildi\u011finiz gibi INDEX&#8217;in s\u00f6z dizimi bulunmaktad\u0131r.<\/p><p class=\"formula\"> INDEX(dizi; sat\u0131r_say\u0131s\u0131; [s\u00fctun_say\u0131s\u0131])<\/p><p> INDEX i\u015flevinde sat\u0131r_say\u0131s\u0131 arg\u00fcman\u0131, de\u011feri hangi sat\u0131rdan d\u00f6nd\u00fcrmesi gerekti\u011fini s\u00f6yler. Diyelim ki 4 girerseniz 4. sat\u0131r\u0131n de\u011ferini d\u00f6nd\u00fcrecek.<\/p><p> <strong><span style=\"background-color: #ffff00;\"><strong>Geriye do\u011fru arama form\u00fcl\u00fcn\u00fc olu\u015fturmak i\u00e7in MATCH&#8217;\u0131 INDEX&#8217;in sat\u0131r_argumentiyle de\u011fi\u015ftirmemiz gerekir.<\/strong><\/span><\/strong><\/p><p> MATCH kulland\u0131\u011f\u0131m\u0131zda arama s\u00fctununda de\u011feri arar ve o de\u011ferin h\u00fccre numaras\u0131n\u0131 d\u00f6nd\u00fcr\u00fcr. Daha sonra INDEX, de\u011fer s\u00fctunundan h\u00fccre konumunu belirlemek i\u00e7in bu say\u0131y\u0131 kullan\u0131r.<\/p><p> Sonunda o h\u00fccrenin de\u011ferini d\u00f6nd\u00fcr\u00fcr ve arad\u0131\u011f\u0131n\u0131z de\u011feri elde edersiniz. Ama \u015fimdi ger\u00e7ek bir \u00f6rnekle \u00e7al\u0131\u015fal\u0131m. A\u015fa\u011f\u0131da \u015fehirlerin ve orada \u00e7al\u0131\u015fan \u00e7al\u0131\u015fanlar\u0131n adlar\u0131n\u0131n bir listesi bulunmaktad\u0131r. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/donnees-dexemple-de-correspondance-dindex-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"dizin e\u015fle\u015fme form\u00fcl\u00fc \u00f6rne\u011fi girin\" width=\"346\" height=\"430\"><\/figure><\/div><p> Burada Mumbai&#8217;de \u00e7al\u0131\u015fan \u00e7al\u0131\u015fan\u0131n ad\u0131n\u0131 aramam\u0131z gerekiyor. \u015eimdi, verilere bakarsan\u0131z, \u015fehirlerin oldu\u011fu s\u00fctunda, bu bizim arama s\u00fctunumuzdur ve \u00e7al\u0131\u015fan adlar\u0131n\u0131n oldu\u011fu s\u00fctunda, bu da sizin de\u011fer s\u00fctununuzdur. Ve form\u00fcl \u015f\u00f6yle olacak: <\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=INDEX(B2:B11,MATCH(E3,A2:A11,0),0)<\/code><\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/index-match-exemple-de-formule-entrer-1.png\" sizes=\"\" srcset=\"\" alt=\"dizin e\u015fle\u015fme form\u00fcl\u00fc \u00f6rne\u011fi girin\"><\/figure><\/div><p> Anlamak i\u00e7in bu form\u00fcl\u00fc iki par\u00e7aya ay\u0131ral\u0131m.<\/p><p> <strong><span style=\"color: #3ba956;\">B\u00f6l\u00fcm 1<\/span><\/strong> : \u0130lk b\u00f6l\u00fcmde \u201cMumbai\u201d de\u011ferini aramak i\u00e7in match fonksiyonunu kulland\u0131k ve bu, \u015fehirler s\u00fctununda \u201cMumbai\u201d de\u011ferinin bulundu\u011fu h\u00fccrenin konumu olan \u201c5\u201d de\u011ferini d\u00f6nd\u00fcrd\u00fc. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/65-index-correspondent-comment-fonctionne-la-correspondance-1.png\" sizes=\"\" srcset=\"\" alt=\"dizin e\u015fle\u015fmesi e\u015fle\u015fmenin i\u015fleyi\u015f \u015fekli\"><\/figure><\/div><p> <span style=\"color: #3ba956;\"><b>B\u00f6l\u00fcm 2<\/b><\/span> : \u0130kinci b\u00f6l\u00fcmde INDEX&#8217;i kulland\u0131k ve de\u011feri bulmak i\u00e7in \u00e7al\u0131\u015fan ad\u0131 s\u00fctununa ba\u015fvurduk. Burada indeks fonksiyonu s\u00fctunun 5. h\u00fccresinin de\u011ferini istedi\u011finizi biliyor. Yani sonu\u00e7ta \u201cSiya\u201d d\u00f6nd\u00fcrd\u00fc. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/lindex-correspond-au-fonctionnement-de-lindex-1.png\" sizes=\"\" srcset=\"\" alt=\"indeks indeksin \u00e7al\u0131\u015fma \u015feklidir\"><\/figure><\/div><h2 id=\"tab-con-22\" class=\"wp-block-heading\"> Daha Fazla INDEX ve E\u015fle\u015ftirme \u00d6rne\u011fi<\/h2><p> INDEX MATCH form\u00fcl\u00fcn\u00fc kullanarak \u00e7\u00f6zd\u00fc\u011f\u00fcm\u00fcz baz\u0131 genel sorunlar\u0131m\u0131z var. <strong><span style=\"color: #000000; background-color: #fff44f;\">\u00d6rnek dosyalara eri\u015fin:<\/span><\/strong> Her \u00f6rne\u011fi takip etmek i\u00e7in <a href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/match-dindex-3.zip\" rel=\"nofollow\">bu \u00f6rnek dosyalar\u0131 buradan indirdi\u011finizden<\/a> emin olun.<\/p><h3 class=\"wp-block-heading\"> 1. INDEX \u2013 MATCH ile temel arama<\/h3><p> Normal bir arama, arama form\u00fclleriyle yapman\u0131z gereken en \u00f6nemli g\u00f6revlerden biridir ve INDEX MATCH bunun i\u00e7in m\u00fckemmeldir. Burada \u00e7al\u0131\u015fan kimli\u011fini ve ad\u0131n\u0131 i\u00e7eren bir veri tablomuz var. Her kimlik benzersizdir ve \u00e7al\u0131\u015fan\u0131n ad\u0131n\u0131 kimli\u011fiyle birlikte araman\u0131z gerekir. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/01-recherche-normale-avec-table-de-donnees-de-correspondance-dindex-1.png\" sizes=\"\" srcset=\"\" alt=\"indeks e\u015fle\u015fme veri tablosuyla normal arama\"><\/figure><\/div><p> Diyelim ki EMP-132 ad\u0131n\u0131 aramak istiyorsunuz. Bunun i\u00e7in form\u00fcl \u015fu \u015fekilde olacakt\u0131r: <\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=INDEX(name_column,MATCH(emp-id,emp-id_column,0))<\/code><\/pre><p class=\"has-text-align-center\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/02-recherche-nominale-avec-correspondance-dindex-entrer-la-formule-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"dizin e\u015fle\u015fmesi ile normal arama form\u00fcl\u00fc girin\" width=\"330\" height=\"139\" data-id=\"12698\"><\/p><h4 class=\"wp-block-heading\"> bu form\u00fcl bu \u015fekilde \u00e7al\u0131\u015f\u0131yor<\/h4><p> <strong>\u00d6ncelikle<\/strong> MATCH, emp id s\u00fctunundaki emp id ile e\u015fle\u015fir ve arad\u0131\u011f\u0131n\u0131z id&#8217;nin h\u00fccre numaras\u0131n\u0131 d\u00f6nd\u00fcr\u00fcr. Burada sat\u0131r numaras\u0131 6&#8217;d\u0131r. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/04-recherche-normale-avec-correspondance-dindex-donne-le-numero-de-ligne-1.png\" sizes=\"\" srcset=\"\" alt=\"indeks e\u015fle\u015fmeli normal arama sat\u0131r numaras\u0131n\u0131 verir\"><\/figure><\/div><p> <strong>Bundan sonra<\/strong> INDEX, ayn\u0131 h\u00fccre numaras\u0131n\u0131 kullanarak isim s\u00fctunundan \u00e7al\u0131\u015fan ad\u0131n\u0131 d\u00f6nd\u00fcr\u00fcr. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/03-recherche-normale-avec-index-correspondant-a-lindex-renvoie-le-nom-1.png\" sizes=\"\" srcset=\"\" alt=\"dizin e\u015fle\u015fmesi ile normal arama dizin ad\u0131n\u0131 d\u00f6nd\u00fcr\u00fcr\"><\/figure><\/div><h2 class=\"wp-block-heading\"> 2. Sola bak\u0131n<\/h2><p> Bir de\u011fer ararken D\u00dc\u015eEYARA sola gidemez. Bahsetti\u011fim gibi INDEX ve MATCH&#8217;te istedi\u011finiz y\u00f6nde arama yapabilirsiniz. A\u015fa\u011f\u0131daki veri tablosunda tutar s\u00fctunundan sonra fatura numaras\u0131 s\u00fctunu bulunmaktad\u0131r. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/05-recherche-a-gauche-avec-table-de-donnees-de-correspondance-dindex-1.png\" sizes=\"\" srcset=\"\" alt=\"dizin e\u015fle\u015fme veri tablosuyla sol arama\"><\/figure><\/div><p> Yani belirli bir faturan\u0131n tutar\u0131n\u0131 aramak istiyorsan\u0131z D\u00dc\u015eEYARA ile bu m\u00fcmk\u00fcn de\u011fildir. D\u00dc\u015eEYARA&#8217;da bir tablo se\u00e7ti\u011finizde, o tablodaki ilk s\u00fctun arama s\u00fctunu olacakt\u0131r.<\/p><p> Ancak burada, bu tabloda, tablonun son s\u00fctununu arama s\u00fctunu olarak kullanmam\u0131z gerekiyor. D\u00dc\u015eEYARA&#8217;y\u0131 burada be\u011fenmedim. Kurtarma i\u00e7in INDEX ve MATCH&#8217;i \u00e7a\u011f\u0131ral\u0131m ve form\u00fcl \u015f\u00f6yle olacakt\u0131r: <\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=INDEX(G2:G14,MATCH(L6,J2:J14,0),0)<\/code><\/pre><p class=\"has-text-align-center\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/06-recherche-a-gauche-avec-correspondance-dindex-entrer-la-formule-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"dizin e\u015fle\u015fmesi ile sola arama yap\u0131n form\u00fcl\u00fc girin\" width=\"279\" height=\"168\" data-id=\"12704\"><\/p><h4 class=\"wp-block-heading\"> \u2026bu form\u00fcl bu \u015fekilde i\u015fliyor<\/h4><ul><li> <strong>\u00d6ncelikle<\/strong> indeks fonksiyonunda miktar s\u00fctununa de\u011findiniz. Bu, de\u011feri almam\u0131z gereken s\u00fctundur.<\/li><li> <strong>\u0130kinci olarak<\/strong> , indeks fonksiyonunun sat\u0131r_numaras\u0131 arg\u00fcman\u0131nda, e\u015fle\u015ftirme fonksiyonunu kullan\u0131p fatura numaras\u0131n\u0131 belirttiniz, fatura s\u00fctununa at\u0131fta bulundunuz ve tam e\u015fle\u015fme i\u00e7in s\u0131f\u0131r kulland\u0131n\u0131z.<\/li><li> <strong>\u00dc\u00e7\u00fcnc\u00fcs\u00fc<\/strong> , e\u015fle\u015ftirme i\u015flevi aral\u0131ktan faturan\u0131n h\u00fccre numaras\u0131n\u0131 d\u00f6nd\u00fcr\u00fcr. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/07-recherche-a-gauche-avec-le-numero-de-ligne-de-retour-de-correspondance-dindex-1.png\" sizes=\"\" srcset=\"\" alt=\"dizin e\u015fle\u015fmesi ile sol arama sat\u0131r numaras\u0131n\u0131 d\u00f6nd\u00fcr\u00fcr\"><\/figure><\/div><p> Ve sonunda INDEX, h\u00fccreyi miktar s\u00fctunundan konumland\u0131rarak tutar\u0131 d\u00f6nd\u00fcrmek i\u00e7in bu say\u0131y\u0131 kullan\u0131r. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/08-recherche-a-gauche-avec-le-montant-des-retours-de-correspondance-dindex-1.png\" sizes=\"\" srcset=\"\" alt=\"dizin e\u015fle\u015fmesi ile sol arama, miktar\u0131 d\u00f6nd\u00fcr\u00fcr\"><\/figure><\/div><h3 class=\"wp-block-heading\"> 3. Bulan\u0131k Arama<\/h3><p> T\u0131pk\u0131 D\u00dc\u015eEYARA gibi kaba bir arama i\u00e7in INDEX\/MATCH&#8217;i de kullanabilirsiniz.<\/p><p> Bulan\u0131k arama, arad\u0131\u011f\u0131n\u0131z de\u011ferin listelenmedi\u011fi ve en yak\u0131n e\u015fle\u015fmeyi elde etmek istedi\u011finiz durumlarda yararl\u0131 olabilir. A\u015fa\u011f\u0131daki tabloda notlara g\u00f6re notlar\u0131n bir listesi bulunmaktad\u0131r. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/09-table-de-donnees-de-correspondance-dindex-de-recherche-approximative-min-1.png\" sizes=\"\" srcset=\"\" alt=\"minimum bulan\u0131k indeks e\u015fle\u015fme veri tablosu\"><\/figure><\/div><p> E\u011fer 79 puan almak istiyorsan\u0131z a\u015fa\u011f\u0131daki form\u00fcl\u00fc kullanabilirsiniz. <\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=INDEX(B2:B6,MATCH(D3,A2:A6,1))<\/code><\/pre><p class=\"has-text-align-center\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/10-correspondance-dindex-de-recherche-approximative-entrer-la-formule-min-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"yakla\u015f\u0131k arama dizini e\u015fle\u015fmesi form\u00fcl\u00fc girin min\" width=\"481\" height=\"190\" data-id=\"12715\"><\/p><h4 class=\"wp-block-heading\"> \u2026bu form\u00fcl bu \u015fekilde i\u015fliyor<\/h4><p> Bu form\u00fclde, yakla\u015f\u0131k bir arama yapmas\u0131na olanak tan\u0131yan <span style=\"color: #0000ee;\">match_type<\/span> i\u00e7in match i\u015flevinde 1&#8217;i kulland\u0131k. Arama de\u011ferinden k\u00fc\u00e7\u00fck veya ona e\u015fit olan ilk de\u011feri d\u00f6nd\u00fcr\u00fcr. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/12-correspondance-dindex-de-recherche-approximative-renvoie-la-note-min-1.png\" sizes=\"\" srcset=\"\" alt=\"bulan\u0131k arama dizini e\u015fle\u015fmesi notu d\u00f6nd\u00fcr\u00fcr\"><\/figure><\/div><p> 79 i\u00e7in ilk en d\u00fc\u015f\u00fck de\u011fer 75, 75 i\u00e7in ise B notu oluyor. Bu y\u00fczden sonu\u00e7ta B notu al\u0131yorsunuz.<\/p><h3 class=\"wp-block-heading\"> 4. Yatay ARAMA<\/h3><p> Bildi\u011finiz gibi YATAYARA yatay arama i\u00e7indir ancak bunun i\u00e7in INDEX ve MATCH&#8217;\u0131 da kullanabilirsiniz. A\u015fa\u011f\u0131daki veri tablosunda ayl\u0131k sat\u0131\u015flara ili\u015fkin yatay bir tablonuz var ve \u201cMay\u0131s ay\u0131\u201d sat\u0131\u015f de\u011ferini almak istiyorsunuz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/13-lignes-de-donnees-de-correspondance-dindex-de-recherche-horizontale-min-1.png\" sizes=\"\" srcset=\"\" alt=\"yatay arama dizini e\u015fle\u015fme veri sat\u0131r\u0131\"><\/figure><\/div><p> Ve form\u00fcl \u015f\u00f6yle olacak: <\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=INDEX(amount,0,MATCH(lookup_month,months,0))<\/code><\/pre><p class=\"has-text-align-center\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/14-correspondance-dindex-de-recherche-horizontale-entrer-la-formule-min-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"yatay arama dizini e\u015fle\u015fmesi form\u00fcl\u00fc girin\" width=\"632\" height=\"173\" data-id=\"12721\"><\/p><h4 class=\"wp-block-heading\"> \u2026bu form\u00fcl bu \u015fekilde i\u015fliyor<\/h4><p> Yukar\u0131daki form\u00fclde indeksin sat\u0131r_say\u0131s\u0131 arg\u00fcman\u0131nda MATCH kullanmak yerine s\u00fctun_say\u0131s\u0131&#8217;nda kulland\u0131k. Match, May\u0131s ay\u0131n\u0131n s\u00fctun numaras\u0131n\u0131 d\u00f6nd\u00fcr\u00fcr. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/15-correspondance-dindex-de-recherche-horizontale-renvoie-le-numero-de-colonne-min-1.png\" sizes=\"\" srcset=\"\" alt=\"yatay arama dizini e\u015fle\u015fmesi s\u00fctun numaras\u0131n\u0131 d\u00f6nd\u00fcr\u00fcr\"><\/figure><\/div><p> Daha sonra INDEX, konum numaras\u0131na g\u00f6re sonu\u00e7 s\u00fctununun de\u011ferini d\u00f6nd\u00fcr\u00fcr. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/16-correspondance-dindex-de-recherche-horizontale-quantite-de-retours-min-1.png\" sizes=\"\" srcset=\"\" alt=\"yatay arama dizini e\u015fle\u015fmesi miktar\u0131 d\u00f6nd\u00fcr\u00fcr\"><\/figure><\/div><h3 class=\"wp-block-heading\"> 5. \u0130ki y\u00f6nl\u00fc arama<\/h3><p> \u0130ki y\u00f6nl\u00fc aramada bir tablodan de\u011fer almam\u0131z gerekir. B\u00f6lgeye ve \u00fcr\u00fcne g\u00f6re sat\u0131\u015f miktarlar\u0131n\u0131 bulabilece\u011finiz a\u015fa\u011f\u0131daki tabloya bakman\u0131z yeterli. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/17-index-de-recherche-bidirectionnel-correspondant-aux-donnees-de-vente-min-1.png\" sizes=\"\" srcset=\"\" alt=\"iki y\u00f6nl\u00fc arama dizini sat\u0131\u015f verileriyle e\u015fle\u015fiyor\"><\/figure><\/div><p> Art\u0131k bir \u00fcr\u00fcn\u00fcn belirli bir alandaki sat\u0131\u015f miktar\u0131n\u0131 \u00f6\u011frenmek istiyorsan\u0131z iki y\u00f6nl\u00fc bir aramaya ihtiyac\u0131n\u0131z var ve bunun i\u00e7in INDEX MATCH MATCH kombinasyonunu kullanman\u0131z gerekiyor. Evet, burada MATCH&#8217;i iki kez kullanman\u0131z gerekiyor.<\/p><p> Normal bir INDEX ve MATCH kombinasyonunda, sat\u0131r numaras\u0131 i\u00e7in MATCH&#8217;i kullan\u0131rs\u0131n\u0131z, ancak iki y\u00f6nl\u00fc aramada bunu s\u00fctun numaras\u0131 i\u00e7in de kullanman\u0131z gerekir. Form\u00fcller \u015f\u00f6yle olacakt\u0131r: <\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=INDEX(A1:F5,MATCH(H3,A1:F1,0),MATCH(H2,A1:A5,0))<\/code><\/pre><p class=\"has-text-align-center\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/18-correspondance-dindex-de-recherche-bidirectionnelle-entrer-la-formule-min-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"iki y\u00f6nl\u00fc arama dizini e\u015fle\u015fen form\u00fcl girin\" width=\"629\" height=\"342\" data-id=\"12727\"><\/p><h4 class=\"wp-block-heading\"> \u2026bu form\u00fcl bu \u015fekilde i\u015fliyor<\/h4><p> Yukar\u0131daki form\u00fclde, tablodan sat\u0131\u015f tutar\u0131n\u0131 almak i\u00e7in indeks fonksiyonunu ve ard\u0131ndan sat\u0131r_say\u0131s\u0131 ve s\u00fctun_say\u0131s\u0131 arg\u00fcmanlar\u0131 i\u00e7in e\u015fle\u015ftirme fonksiyonunu kulland\u0131n\u0131z. S\u00fctun_num arg\u00fcman\u0131 olan match fonksiyonu, ba\u015fvurdu\u011funuz aral\u0131\u011f\u0131n 5. sat\u0131r\u0131nda Product-D de\u011feri olarak 5 de\u011ferini d\u00f6nd\u00fcr\u00fcr. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/19-la-correspondance-dindex-de-recherche-bidirectionnelle-renvoie-le-numero-de-ligne-min-1.png\" sizes=\"\" srcset=\"\" alt=\"iki y\u00f6nl\u00fc arama dizini e\u015fle\u015fmesi sat\u0131r numaras\u0131n\u0131 d\u00f6nd\u00fcr\u00fcr\"><\/figure><\/div><p> Ve sat\u0131r_say\u0131s\u0131 ba\u011f\u0131ms\u0131z de\u011fi\u015fkeninde bulunan e\u015fle\u015fme i\u015flevi 2 de\u011ferini d\u00f6nd\u00fcr\u00fcr \u00e7\u00fcnk\u00fc kuzey b\u00f6lgesi de\u011feri ba\u015fvuruda bulundu\u011funuz aral\u0131\u011f\u0131n ikinci s\u00fctunundad\u0131r. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/20-correspondance-dindex-de-recherche-bidirectionnelle-renvoie-le-numero-de-colonne-min-1.png\" sizes=\"\" srcset=\"\" alt=\"iki y\u00f6nl\u00fc arama dizini e\u015fle\u015fmesi s\u00fctun numaras\u0131n\u0131 d\u00f6nd\u00fcr\u00fcr\"><\/figure><\/div><p> \u015eimdi bu de\u011ferlerle indeks fonksiyonu 2. s\u00fctun ve 5. sat\u0131rdaki de\u011feri d\u00f6nd\u00fcrd\u00fc: 1456. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/21-correspondance-dindex-de-recherche-bidirectionnelle-renvoie-le-montant-des-ventes-min-1.png\" sizes=\"\" srcset=\"\" alt=\"iki y\u00f6nl\u00fc arama dizini e\u015fle\u015fmesi sat\u0131\u015f tutar\u0131n\u0131 d\u00f6nd\u00fcr\u00fcr\"><\/figure><\/div><h3 class=\"wp-block-heading\"> 6. B\u00fcy\u00fck\/k\u00fc\u00e7\u00fck harfe duyarl\u0131<\/h3><p> Bir liste veya s\u00fctunda iki ayn\u0131 de\u011fere sahip oldu\u011funuzda ancak metnin b\u00fcy\u00fck\/k\u00fc\u00e7\u00fck harf durumu farkl\u0131 oldu\u011funda bir sorunla kar\u015f\u0131la\u015f\u0131rsan\u0131z, do\u011fru de\u011feri bulmak i\u00e7in b\u00fcy\u00fck\/k\u00fc\u00e7\u00fck harfe duyarl\u0131 bir arama yapabilirsiniz. A\u015fa\u011f\u0131daki ikinci s\u00fctunda i\u015faretledi\u011finiz ad\u0131n\u0131z\u0131n bulundu\u011fu \u00f6\u011frenci listesine bir g\u00f6z atal\u0131m. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/22-index-de-recherche-sensible-a-la-casse-correspondant-aux-donnees-des-etudiants-min.png\" sizes=\"\" srcset=\"\" alt=\"B\u00fcy\u00fck\/k\u00fc\u00e7\u00fck harfe duyarl\u0131 arama dizini \u00f6\u011frenci verileriyle e\u015fle\u015fir\"><\/figure><\/div><p> Ve ba\u015flang\u0131\u00e7ta ayn\u0131 olan ancak farkl\u0131 metin durumlar\u0131nda olan isimler var. \u00d6rne\u011fin John Parker ve JOHN Mathew. Diyelim ki &#8220;John&#8221; de\u011fil &#8220;JOHN&#8221; markalar\u0131n\u0131 aramak istiyorsunuz, INDEX ve MATCH ile tam e\u015fleme aramas\u0131 olu\u015fturabilirsiniz. Ve form\u00fcl \u015f\u00f6yle olacak: <\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=INDEX(B2:B21,MATCH(TRUE,EXACT(E5,A2:A21),0))<\/code><\/pre><p class=\"has-text-align-center\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/23-correspondance-dindex-de-recherche-sensible-a-la-casse-entrer-la-formule-min-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"b\u00fcy\u00fck\/k\u00fc\u00e7\u00fck harfe duyarl\u0131 arama dizini e\u015fle\u015fmesi form\u00fcl\u00fc girin\" width=\"597\" height=\"408\" data-id=\"12734\"><\/p><h4 class=\"wp-block-heading\"> \u2026bu form\u00fcl bu \u015fekilde i\u015fliyor<\/h4><p> Bu form\u00fclde, e\u015fle\u015ftirme i\u015flevinde TAM i\u015flevini kulland\u0131n\u0131z. E\u015fle\u015ftirme i\u015flevi b\u00fcy\u00fck\/k\u00fc\u00e7\u00fck harfe duyarl\u0131 bir de\u011fer arayamad\u0131\u011f\u0131ndan ve EXACT bunun i\u00e7in m\u00fckemmel bir i\u015flevdir.<\/p><p> \u0130ki de\u011feri kar\u015f\u0131la\u015ft\u0131rabilir ve tamamen ayn\u0131ysa (b\u00fcy\u00fck\/k\u00fc\u00e7\u00fck harf dahil) DO\u011eRU d\u00f6nd\u00fcrebilir, ancak bu form\u00fcl\u00fc tablo bi\u00e7iminde girmeniz gerekir \u00e7\u00fcnk\u00fc t\u00fcm s\u00fctunu EXACT&#8217;taki tek bir de\u011ferle kar\u015f\u0131la\u015ft\u0131rman\u0131z gerekir. Girdi\u011finizde a\u015fa\u011f\u0131daki gibi bir dizi d\u00f6nd\u00fcrecektir. <\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=INDEX(Sheet1!$B$2:$B$21,MATCH(TRUE,{FALSE;FALSE;FALSE;FALSE;FALSE;FALSE;FALSE;FALSE;FALSE;FALSE;FALSE;FALSE;FALSE;FALSE;FALSE;TRUE;FALSE;FALSE;FALSE;FALSE},0))<\/code><\/pre><p class=\"has-text-align-center\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/24-index-de-recherche-sensible-a-la-casse-correspondant-au-tableau-de-retour-exact-min-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"B\u00fcy\u00fck\/k\u00fc\u00e7\u00fck harfe duyarl\u0131 arama dizini tam d\u00f6n\u00fc\u015f dizisiyle e\u015fle\u015fir\" width=\"646\" height=\"226\" data-id=\"12735\"><\/p><p> Buradan, diziden TRUE konumunu almak i\u00e7in match fonksiyonunu kullanman\u0131z gerekir. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/25-correspondance-dindex-de-recherche-sensible-a-la-casse-renvoie-le-numero-de-ligne-min-1.png\" sizes=\"\" srcset=\"\" alt=\"B\u00fcy\u00fck\/k\u00fc\u00e7\u00fck harfe duyarl\u0131 arama dizini e\u015fle\u015ftirmesi sat\u0131r numaras\u0131n\u0131 d\u00f6nd\u00fcr\u00fcr\"><\/figure><\/div><p> Bu noktada bulman\u0131z gereken de\u011ferin h\u00fccre numaras\u0131na (sat\u0131r numaras\u0131na) sahipsiniz. Ve bu s\u00fctun de\u011feri i\u00e7in INDEX&#8217;i kullanabilirsiniz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/26-correspondance-dindex-de-recherche-sensible-a-la-casse-renvoie-le-score-de-letudiant-min-1.png\" sizes=\"\" srcset=\"\" alt=\"B\u00fcy\u00fck\/k\u00fc\u00e7\u00fck harfe duyarl\u0131 arama dizini e\u015fle\u015ftirmesi \u00f6\u011frenci puan\u0131n\u0131 d\u00f6nd\u00fcr\u00fcr\"><\/figure><\/div><p class=\"qt-tip\"> <strong><span style=\"color: #000000;\">\u00d6nemli nokta:<\/span><\/strong> E\u011fer EXACT ile birden fazla TRUE elde ederseniz, e\u015fle\u015fme sadece ilk TRUE&#8217;nun say\u0131s\u0131n\u0131 d\u00f6nd\u00fcrecektir.<\/p><h3 class=\"wp-block-heading\"> 7. INDEX MATCH ile joker karakterlerle<\/h3><p> Joker karakterler \u00e7ok faydal\u0131d\u0131r. <a href=\"https:\/\/exceladvisor.org\/tr\/joker-karakterler-2\/\" data-wpil=\"url\">Joker karakterleri<\/a> kullanarak k\u0131smi arama yapabilirsiniz. Ve en iyi yan\u0131, di\u011fer t\u00fcm form\u00fcl aramalar\u0131nda oldu\u011fu gibi, indeks ve e\u015fle\u015fme ile joker karakterleri de kullanabilmenizdir.<\/p><p> \u00c7al\u0131\u015fanlar\u0131n adlar\u0131n\u0131, soyadlar\u0131n\u0131 ve ya\u015flar\u0131n\u0131 i\u00e7eren a\u015fa\u011f\u0131daki isim listesine bir g\u00f6z atman\u0131z yeterli. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/27-donnees-de-correspondance-dindex-de-caracteres-generiques-de-recherche-min-1.png\" sizes=\"\" srcset=\"\" alt=\"joker karakter dizini e\u015fle\u015fme verilerini ara\"><\/figure><\/div><p> Bu listeden belirli bir \u00e7al\u0131\u015fan\u0131n (Sondra) ya\u015f\u0131n\u0131 alman\u0131z gerekir. Ama ger\u00e7ek \u015fu ki siz sadece ilk ismi biliyorsunuz.<\/p><p> Y\u0131ld\u0131z i\u015fareti kullan\u0131rsan\u0131z, Sondra&#8217;n\u0131n ya\u015f\u0131n\u0131 ilk ad\u0131n\u0131 kullanarak arayabilirsiniz. Bunun i\u00e7in form\u00fcl \u015fu \u015fekilde olacakt\u0131r: <\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=INDEX(B2:B11,MATCH(\"Sondra*\",A2:A11,0),0)<\/code><\/pre><p class=\"has-text-align-center\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/28-correspondance-dindex-de-caracteres-generiques-de-recherche-entrer-des-donnees-min-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"joker karakterleri ara dizin e\u015fle\u015fmesi veri girin\" width=\"543\" height=\"291\" data-id=\"12740\"><\/p><h4 class=\"wp-block-heading\"> \u2026bu form\u00fcl bu \u015fekilde i\u015fliyor<\/h4><p> Y\u0131ld\u0131z i\u015fareti, n say\u0131da karakterin yerini alabilecek bir joker karakterdir. Yani ad\u0131ndan sonra kullan\u0131ld\u0131\u011f\u0131nda soyad\u0131n\u0131n yerine ge\u00e7iyordu. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/29-correspondance-dindex-de-caracteres-generiques-de-recherche-renvoie-le-numero-de-ligne-min-1.png\" sizes=\"\" srcset=\"\" alt=\"joker karakter dizini e\u015fle\u015fmesi sat\u0131r numaras\u0131n\u0131 d\u00f6nd\u00fcr\u00fcr\"><\/figure><\/div><h3 class=\"wp-block-heading\"> 8. En d\u00fc\u015f\u00fck de\u011fer<\/h3><p> Diyelim ki a\u015fa\u011f\u0131daki gibi puanlara sahip bir \u00f6\u011frenci listeniz var. \u015eimdi bu listeden en d\u00fc\u015f\u00fck puan\u0131 alan \u00f6\u011frencinin ad\u0131n\u0131 aramak istiyorsunuz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/31-recherche-de-donnees-de-correspondance-dindex-de-valeur-la-plus-basse-min-1.png\" sizes=\"\" srcset=\"\" alt=\"en d\u00fc\u015f\u00fck de\u011fer indeksi e\u015fle\u015fme verilerini bul\"><\/figure><\/div><p> Bunun i\u00e7in MIN fonksiyonunu indeks ve e\u015fle\u015fme ile kullanabilirsiniz, form\u00fcl \u015fu \u015fekilde olacakt\u0131r: <\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=INDEX(A2:A21,MATCH(MIN(B2:B21),B2:B21,0))<\/code><\/pre><p class=\"has-text-align-center\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/32-rechercher-la-valeur-la-plus-basse-de-la-correspondance-dindex-entrer-la-formule-min-2-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"en d\u00fc\u015f\u00fck de\u011fere sahip dizin e\u015fle\u015fmesini bul form\u00fcl\u00fc girin\" width=\"558\" height=\"492\" data-id=\"12750\"><\/p><p> A s\u00fctununda \u00f6\u011frencilerin adlar\u0131, B s\u00fctununda ise puanlar\u0131 var.<\/p><p> Yani bu form\u00fcl\u00fc bir h\u00fccreye yaz\u0131p Enter&#8217;a bast\u0131\u011f\u0131n\u0131zda en d\u00fc\u015f\u00fck puan\u0131 alan \u00f6\u011frencinin ad\u0131 yani Librada Bastian d\u00f6necektir.<\/p><h4 class=\"wp-block-heading\"> A\u00e7\u0131klama<\/h4><p> Bu form\u00fclde \u00fc\u00e7 farkl\u0131 par\u00e7am\u0131z var.<\/p><p> <strong>\u0130lk<\/strong> b\u00f6l\u00fcmde MIN i\u015flevi en d\u00fc\u015f\u00fck puan\u0131 d\u00f6nd\u00fcr\u00fcr. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/33-rechercher-la-valeur-la-plus-basse-index-match-retours-valeur-min-min-1.png\" sizes=\"\" srcset=\"\" alt=\"en d\u00fc\u015f\u00fck de\u011ferin dizin e\u015fle\u015fmesini bul, de\u011fer d\u00f6nd\u00fcr\u00fcr\"><\/figure><\/div><p> Bundan sonra, ikinci b\u00f6l\u00fcmde, e\u015fle\u015ftirme i\u015flevi o en d\u00fc\u015f\u00fck puana sahip h\u00fccreyi d\u00f6nd\u00fcr\u00fcr. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/34-recherche-la-correspondance-dindex-de-valeur-la-plus-basse-renvoie-le-numero-de-ligne-min-1.png\" sizes=\"\" srcset=\"\" alt=\"en d\u00fc\u015f\u00fck de\u011feri bul dizin e\u015fle\u015fmesi sat\u0131r numaras\u0131n\u0131 d\u00f6nd\u00fcr\u00fcr\"><\/figure><\/div><p> Sonunda indeks i\u015flevi, e\u015fle\u015fmenin d\u00f6nd\u00fcrd\u00fc\u011f\u00fc ayn\u0131 h\u00fccre konumunu kullanarak \u00f6\u011frenci ad\u0131 s\u00fctununun de\u011ferini d\u00f6nd\u00fcr\u00fcr. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/35-recherche-de-la-valeur-la-plus-basse-de-lindex-correspondant-au-nom-de-retour-min-1.png\" sizes=\"\" srcset=\"\" alt=\"en d\u00fc\u015f\u00fck de\u011fere sahip dizin e\u015fle\u015fmesinin arama d\u00f6n\u00fc\u015f ad\u0131\"><\/figure><\/div><p class=\"qt-tip\"> <strong>\u0130pucu:<\/strong> Ayn\u0131 \u015fekilde en y\u00fcksek puan\u0131 alan \u00f6\u011frencinin ad\u0131n\u0131 da alabilirsiniz.<\/p><h3 class=\"wp-block-heading\"> 9. En iyi n&#8217;inci skor<\/h3><p> \u015eimdi \u015f\u00f6yle d\u00fc\u015f\u00fcn\u00fcn, elinizde s\u0131nav puanlar\u0131 olan \u00f6\u011frencilerin bir listesi var ve bu listeden 2. en y\u00fcksek puan\u0131 alan \u00f6\u011frencinin ad\u0131n\u0131 almak istiyorsunuz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/35.png\" sizes=\"\" srcset=\"\" alt=\"\u00fcst n'inci puan indeksi e\u015fle\u015ftirme verileri\"><\/figure><\/div><p> Sorun \u015fu ki, ikinci en y\u00fcksek puan\u0131n ne oldu\u011funu bilmiyorsunuz.<\/p><p> Normalde form\u00fcl aramalar\u0131 ile bir de\u011fer arad\u0131\u011f\u0131n\u0131zda arad\u0131\u011f\u0131n\u0131z de\u011ferden emin olursunuz. Ancak burada ikinci en y\u00fcksek puan\u0131n ne oldu\u011funu bilmiyorsunuz.<\/p><p> Yani bunun i\u00e7in b\u00fcy\u00fck bir fonksiyonu bir indeksle birle\u015ftirip e\u015fle\u015ftirebilirsiniz. B\u00fcy\u00fck fonksiyon, aral\u0131ktaki ikinci en y\u00fcksek de\u011feri belirlemenize yard\u0131mc\u0131 olacakt\u0131r.<\/p><p> Ve form\u00fcl \u015f\u00f6yle olacak: <\/p><pre class=\"wp-block-code\"><code class=\"language-excel-formula\" lang=\"excel-formula\"> =INDEX(student_names,MATCH(LARGE(score,2),score,0))<\/code><\/pre><p class=\"has-text-align-center\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/36-top-nth-score-index-match-entrer-la-formule-min-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"en iyi n'inci puan indeks e\u015fle\u015fmesi form\u00fcl\u00fc girin\" width=\"583\" height=\"140\" data-id=\"12780\"><\/p><h3 id=\"tab-con-19\" class=\"wp-block-heading\"> \u2026bu form\u00fcl bu \u015fekilde i\u015fliyor<\/h3><p> Bu form\u00fclde aranan_de\u011fer ba\u011f\u0131ms\u0131z de\u011fi\u015fkeni i\u00e7in e\u015fle\u015fme i\u015flevi i\u00e7indeki b\u00fcy\u00fck i\u015flevi kulland\u0131n\u0131z. Ve b\u00fcy\u00fck fonksiyonda ikinci en y\u00fcksek de\u011feri elde etmek i\u00e7in puan aral\u0131\u011f\u0131ndan ve 2&#8217;den bahsettiniz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/37-top-nth-score-index-match-grand-retour-deuxieme-valeur-la-plus-elevee-min-1.png\" sizes=\"\" srcset=\"\" alt=\"en iyi n'inci skor indeks ma\u00e7\u0131 b\u00fcy\u00fck getiri ikinci en y\u00fcksek de\u011fer\"><\/figure><\/div><p> B\u00fcy\u00fck i\u015flev ikinci en b\u00fcy\u00fck de\u011feri d\u00f6nd\u00fcrd\u00fckten sonra, e\u015fle\u015ftirme i\u015flevi bu de\u011feri kullan\u0131r ve kar\u015f\u0131l\u0131k gelen h\u00fccre numaras\u0131n\u0131 d\u00f6nd\u00fcr\u00fcr. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/38-top-nieme-score-index-correspondance-retour-numero-de-ligne-min-1.png\" sizes=\"\" srcset=\"\" alt=\"en iyi n'inci puan indeksi ma\u00e7 d\u00f6n\u00fc\u015f sat\u0131r\u0131 numaras\u0131\"><\/figure><\/div><p> Ve sonunda indeks fonksiyonu bu h\u00fccre numaras\u0131n\u0131 kullan\u0131r ve \u00f6\u011frenci ad\u0131n\u0131 d\u00f6nd\u00fcr\u00fcr. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/39-top-nth-score-index-match-renvoie-nom-min-1.png\" sizes=\"\" srcset=\"\" alt=\"en y\u00fcksek puan indeksi e\u015fle\u015fmesi ad\u0131 d\u00f6nd\u00fcr\u00fcr\"><\/figure><\/div><h3 class=\"wp-block-heading\"> 10. \u00c7oklu kriterler<\/h3><p> Normalde indeks ve e\u015fle\u015fme kombinasyonunun amac\u0131 tek bir de\u011feri aramakt\u0131r. \u0130\u015fte bu y\u00fczden match i\u015flevinde yaln\u0131zca bir aral\u0131k kullan\u0131rs\u0131n\u0131z.<\/p><p> Ancak bazen ger\u00e7ek d\u00fcnyadaki verilerle kar\u015f\u0131 kar\u015f\u0131ya kald\u0131\u011f\u0131n\u0131zda bir de\u011fer bulmak i\u00e7in birden fazla kriter kullanman\u0131z gerekir.<\/p><p> A\u015fa\u011f\u0131daki \u00f6rne\u011fi d\u00fc\u015f\u00fcn\u00fcn. Burada \u00fcr\u00fcn ad\u0131, kategori ve boyut gibi \u00e7e\u015fitli ayr\u0131nt\u0131lara sahip bir \u00fcr\u00fcn listeniz var.<\/p><p> Ve bu verilerden, t\u00fcm kriterleri kullanarak belirli bir \u00fcr\u00fcn\u00fcn fiyat\u0131n\u0131 almak istiyorsunuz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/40-donnees-de-correspondance-dindex-a-criteres-multiples-min-1.png\" sizes=\"\" srcset=\"\" alt=\"\u00e7ok kriterli indeks e\u015fle\u015ftirme verileri\"><\/figure><\/div><p> Bu nedenle form\u00fcl \u015f\u00f6yle olacakt\u0131r: <\/p><pre class=\"wp-block-code\"><code class=\"language-excel-formula\" lang=\"excel-formula\"> =INDEX(D2:D11,MATCH(1,(A14=A2:A11)*(B14=B2:B11)*(C14=C2:C11),0))<\/code><\/pre><p class=\"has-text-align-center\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/41-correspondance-dindex-de-criteres-multiples-entrer-la-formule-min-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"\u00e7ok \u00f6l\u00e7\u00fctl\u00fc dizin e\u015fle\u015fmesi form\u00fcl\u00fc girin\" width=\"664\" height=\"385\" data-id=\"12786\"><\/p><p class=\"qt-tip\"> <strong><span style=\"color: #000000;\">Not:<\/span><\/strong> Bu bir dizi form\u00fcl\u00fcd\u00fcr, dolay\u0131s\u0131yla ctrl + \u00fcst karakter + enter tu\u015flar\u0131n\u0131 kullanarak girmeniz gerekir.<\/p><h4 class=\"wp-block-heading\"> \u2026bu form\u00fcl bu \u015fekilde i\u015fliyor<\/h4><p> Bu form\u00fclde, \u00fc\u00e7 farkl\u0131 de\u011feri e\u015fle\u015ftirecek \u00fc\u00e7 farkl\u0131 diziniz var ve bu diziler, de\u011ferlerin e\u015fle\u015fti\u011fi yerde DO\u011eRU ve YANLI\u015e de\u011ferini d\u00f6nd\u00fcr\u00fcyor.<\/p><p> Daha sonra bunlar\u0131 birbiriyle \u00e7arpt\u0131\u011f\u0131n\u0131zda bir dizi veya buna benzer bir \u015fey elde edersiniz.<\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=INDEX(D2:D11,MATCH(1,{0;0;0;0;0;0;1;0;0;0},0))<\/code><\/pre><p> Ve match i\u015flevi dizi i\u00e7in 1 konumunu d\u00f6nd\u00fcr\u00fcr. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/42-correspondance-dindex-a-criteres-multiples-retour-numero-de-ligne-min-1.png\" sizes=\"\" srcset=\"\" alt=\"\u00e7oklu \u00f6l\u00e7\u00fct dizin e\u015fle\u015fmesi d\u00f6n\u00fc\u015f sat\u0131r numaras\u0131\"><\/figure><\/div><p> Sonunda INDEX, e\u015fle\u015fmenin d\u00f6nd\u00fcrd\u00fc\u011f\u00fc say\u0131y\u0131 kullanarak fiyat s\u00fctununun fiyat\u0131n\u0131 d\u00f6nd\u00fcr\u00fcr. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/43-indice-de-correspondance-a-criteres-multiples-retour-prix-unitaire-min-1.png\" sizes=\"\" srcset=\"\" alt=\"birden fazla kriterle e\u015fle\u015fen endeks getirisi birim fiyat\u0131\"><\/figure><\/div><p class=\"qt-tip\"> <strong>\u0130pucu:<\/strong> Dizi form\u00fcl\u00fc kullanmak istemiyorsan\u0131z <a href=\"https:\/\/exceladvisor.org\/tr\/toplam-urundeki-durum\/\">SUMproduct ko\u015fulunu<\/a> kullanabilirsiniz.<\/p><h3 class=\"wp-block-heading\"> 11. Bir aral\u0131\u011f\u0131n ilk say\u0131sal de\u011feri<\/h3><p> Diyelim ki hem metin hem de say\u0131sal de\u011ferlerin bulundu\u011fu bir listeniz var ve \u015fimdi bu listeden ilk say\u0131sal de\u011feri almak istiyorsunuz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/44-premieres-donnees-de-correspondance-dindex-de-valeur-numerique-min-1.png\" sizes=\"\" srcset=\"\" alt=\"ilk say\u0131sal de\u011fer dizini e\u015fle\u015fme verileri\"><\/figure><\/div><p> Bunu yapmak i\u00e7in ISNUMBER i\u015flevini indeks\/e\u015fle\u015fme ile birle\u015ftirebilirsiniz. ISNUMBER, hangi de\u011ferin say\u0131, hangisinin metin oldu\u011funu belirlemenize yard\u0131mc\u0131 olabilir.<\/p><p> Form\u00fcl \u015f\u00f6yle olacakt\u0131r: <\/p><pre class=\"wp-block-code\"><code class=\"language-excel-formula\" lang=\"excel-formula\"> =INDEX(list,MATCH(TRUE,ISNUMBER(list),0))<\/code><\/pre><p class=\"has-text-align-center\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/45-premiere-correspondance-dindex-de-valeur-numerique-entrer-la-formule-min-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"ilk say\u0131sal de\u011fer indeksi e\u015fle\u015fmesi form\u00fcl\u00fc girin\" width=\"624\" height=\"190\" data-id=\"12790\"><\/p><p> Bu form\u00fcl\u00fc tablo bi\u00e7iminde girmelisiniz (Ctrl + Shift + Enter tu\u015flar\u0131n\u0131 kullanarak).<\/p><h4 class=\"wp-block-heading\"> \u2026bu form\u00fcl bu \u015fekilde i\u015fliyor<\/h4><p> Bu form\u00fclde ISNUMBER, listenin uzunlu\u011funa e\u015fit bir dizi d\u00f6nd\u00fcr\u00fcr ve bu dizide say\u0131 olan de\u011ferler i\u00e7in TRUE ve geri kalan de\u011ferler i\u00e7in FALSE bulunur. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/46-premier-indice-de-valeur-numerique-correspond-a-la-matrice-de-numeros-min-1.png\" sizes=\"\" srcset=\"\" alt=\"ilk say\u0131sal de\u011fer dizini e\u015fle\u015fen say\u0131 dizisi\"><\/figure><\/div><p> Bundan sonra e\u015fle\u015ftirme fonksiyonunda arama de\u011feri olarak TRUE&#8217;yu kulland\u0131n\u0131z. B\u00f6ylece dizideki ilk DO\u011eRU&#8217;nun konum numaras\u0131n\u0131 d\u00f6nd\u00fcr\u00fcr. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/47-premiere-correspondance-dindex-de-valeur-numerique-renvoie-le-numero-de-ligne-min.png\" sizes=\"\" srcset=\"\" alt=\"ilk say\u0131sal de\u011fer dizini e\u015fle\u015fmesi sat\u0131r numaras\u0131n\u0131 d\u00f6nd\u00fcr\u00fcr\"><\/figure><\/div><p> Sonu\u00e7ta bu pozisyon numaras\u0131 indeksini kullanmak ilk say\u0131sal de\u011feri d\u00f6nd\u00fcr\u00fcr. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/48-premiere-correspondance-dindex-de-valeur-numerique-retour-premier-numero-min-1.png\" sizes=\"\" srcset=\"\" alt=\"48-ilk-say\u0131sal-de\u011fer-indeks-e\u015fle\u015fme-d\u00f6n\u00fc\u015f-ilk-say\u0131-min\"><\/figure><\/div><h3 class=\"wp-block-heading\"> 12. \u0130lk bo\u015f olmayan de\u011feri al\u0131n<\/h3><p> \u015e\u00f6yle d\u00fc\u015f\u00fcnelim, ilk h\u00fccrelerin bir k\u0131sm\u0131n\u0131n bo\u015f oldu\u011fu bir de\u011ferler listeniz var ve ilk bo\u015f olmayan de\u011feri elde etmek istiyorsunuz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/49-premieres-donnees-de-correspondance-dindex-non-vierges-min-1.png\" sizes=\"\" srcset=\"\" alt=\"ilk bo\u015f olmayan dizin e\u015fle\u015fme verileri\"><\/figure><\/div><p> Ve bu ilk bo\u015f olmayan de\u011feri elde etmek i\u00e7in bu form\u00fcl\u00fc kullanabilirsiniz. <\/p><pre class=\"wp-block-code\"><code class=\"language-excel-formula\" lang=\"excel-formula\"> =INDEX(A2:A11,MATCH(FALSE,ISBLANK(A2:A11),0))<\/code><\/pre><p class=\"has-text-align-center\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/49-premiere-correspondance-dindex-non-vide-entrer-la-formule-min-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"ilk bo\u015f olmayan dizin e\u015fle\u015fmesi form\u00fcl\u00fc girin\" width=\"583\" height=\"303\" data-id=\"12797\"><\/p><h4 class=\"wp-block-heading\"> \u2026bu form\u00fcl bu \u015fekilde i\u015fliyor<\/h4><p> Bu form\u00fcl\u00fc ak\u0131ll\u0131ca anlayabilmek i\u00e7in \u00fc\u00e7 farkl\u0131 par\u00e7aya ay\u0131rmam\u0131z gerekiyor.<\/p><p> <strong>\u0130lk olarak<\/strong> , bo\u015f h\u00fccreler i\u00e7in DO\u011eRU ve bo\u015f olmayan h\u00fccreler i\u00e7in YANLI\u015e&#8217;\u0131n oldu\u011fu bir dizi elde etmek i\u00e7in match i\u015flevindeki ISBLANK i\u015flevini kulland\u0131n\u0131z. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/50-premieres-correspondances-dindex-non-vides-tableau-vide-min-1.png\" sizes=\"\" srcset=\"\" alt=\"bo\u015f olmayan ilk dizin e\u015fle\u015fmesi isblank dizisi\"><\/figure><\/div><p> <strong>\u0130kinci olarak<\/strong> MATCH, ISBLANK taraf\u0131ndan d\u00f6nd\u00fcr\u00fclen dizideki ilk TRUE&#8217;nun konum numaras\u0131n\u0131 d\u00f6nd\u00fcr\u00fcr.<\/p><p> Yani bu noktada ilk bo\u015f olmayan de\u011ferin h\u00fccre numaras\u0131na sahipsiniz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/51-premiere-correspondance-dindex-non-vide-renvoie-le-numero-de-ligne-min-1.png\" sizes=\"\" srcset=\"\" alt=\"bo\u015f olmayan ilk dizin e\u015fle\u015fmesi sat\u0131r numaras\u0131n\u0131 d\u00f6nd\u00fcr\u00fcr\"><\/figure><\/div><p> <strong>\u00dc\u00e7\u00fcnc\u00fcs\u00fc<\/strong> , indeks i\u015flevi listedeki bo\u015f olmayan ilk de\u011feri d\u00f6nd\u00fcr\u00fcr. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/52-premiere-correspondance-dindex-non-vide-renvoie-la-valeur-de-la-premiere-cellule-non-vide-min-1.png\" sizes=\"\" srcset=\"\" alt=\"bo\u015f olmayan ilk dizin e\u015fle\u015fmesi, bo\u015f olmayan ilk h\u00fccrenin de\u011ferini d\u00f6nd\u00fcr\u00fcr\"><\/figure><\/div><h3 class=\"wp-block-heading\"> 13. En s\u0131k kullan\u0131lan metin<\/h3><p> \u015eimdi, metin de\u011ferlerinin bir listesi verildi\u011finde, en s\u0131k kullan\u0131lan metni sayman\u0131z gerekti\u011fini varsayal\u0131m.<\/p><p> A\u015fa\u011f\u0131daki listede isimleriniz var.<\/p><p> Ancak birden fazla kullan\u0131lan isimler de vard\u0131r. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/53-donnees-de-correspondance-dindex-de-texte-les-plus-frequentes-min-1.png\" sizes=\"\" srcset=\"\" alt=\"en s\u0131k metin dizini e\u015fle\u015fme verileri\"><\/figure><\/div><p> Yani \u015fimdi listede en y\u00fcksek tekrara sahip olan ismi alman\u0131z gerekiyor. MODE, INDEX ve MATCH kombinasyonundan olu\u015fan a\u015fa\u011f\u0131daki form\u00fcl\u00fc kullanabilirsiniz. <\/p><pre class=\"wp-block-code\"><code class=\"language-excel-formula\" lang=\"excel-formula\"> =INDEX(A2:A13,MODE(MATCH(A2:A13,A2:A13,0)))<\/code><\/pre><p class=\"has-text-align-center\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/55-correspondances-dindex-de-texte-les-plus-frequentes-entrer-la-formule-min-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"en s\u0131k metin dizini e\u015fle\u015fmesi form\u00fcl\u00fc girin\" width=\"616\" height=\"284\" data-id=\"12804\"><\/p><p> Bu form\u00fcl\u00fc ekledi\u011finizde en yayg\u0131n isim olan \u201cTamesha\u201d de\u011ferini d\u00f6nd\u00fcrecektir.<\/p><h4 class=\"wp-block-heading\"> \u2026bu form\u00fcl bu \u015fekilde i\u015fliyor<\/h4><p> <strong><span style=\"color: #554a47;\">\u0130lk olarak<\/span><\/strong> MATCH t\u00fcm ad aral\u0131\u011f\u0131n\u0131 kendisiyle kar\u015f\u0131la\u015ft\u0131racakt\u0131r. Ve bunu yaparken her metnin ilk konumunu temsil edece\u011fi bir dizi d\u00f6nd\u00fcrecektir.<\/p><p> Listedeki en yayg\u0131n ismimiz olan &#8220;Tamesha&#8221; ismine bir \u00f6rnek verelim. <strong><span style=\"color: #000000;\">\u015eimdi<\/span><\/strong> listeye bakarsan\u0131z, bu \u00f6nce 8. h\u00fccrede, sonra 12. h\u00fccrede ger\u00e7ekle\u015fti.<\/p><p> Ancak tabloya bakarsan\u0131z &#8220;Tamesha&#8221;n\u0131n oldu\u011fu t\u00fcm pozisyonlar i\u00e7in ilk pozisyonu olan 8&#8217;i d\u00f6nd\u00fcrd\u00fc. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/54-tableaux-de-correspondance-dindex-de-texte-les-plus-frequents-min-1.png\" sizes=\"\" srcset=\"\" alt=\"en s\u0131k kullan\u0131lan metin dizini arama tablosu\"><\/figure><\/div><p> Bundan sonra, MATCH taraf\u0131ndan d\u00f6nd\u00fcr\u00fclen diziden mode i\u015flevi, &#8221; <strong><span style=\"color: #000000;\">Tamesha<\/span><\/strong> &#8220;n\u0131n ilk ge\u00e7ti\u011fi h\u00fccre numaras\u0131 olan en s\u0131k say\u0131y\u0131 d\u00f6nd\u00fcrecektir. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/56-le-mode-de-correspondance-dindex-de-texte-le-plus-frequent-renvoie-le-numero-de-cellule-min-1.png\" sizes=\"\" srcset=\"\" alt=\"en s\u0131k kullan\u0131lan metin dizini e\u015fle\u015fme modu h\u00fccre numaras\u0131n\u0131 d\u00f6nd\u00fcr\u00fcr\"><\/figure><\/div><p> Ve sonunda INDEX, bu h\u00fccre numaras\u0131n\u0131 kullanarak metni d\u00f6nd\u00fcrecektir. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/57-correspondance-dindex-de-texte-la-plus-frequente-nom-de-retour-min-1.png\" sizes=\"\" srcset=\"\" alt=\"en s\u0131k kullan\u0131lan metin dizini e\u015fle\u015fmesi d\u00f6n\u00fc\u015f ad\u0131\"><\/figure><\/div><h3 class=\"wp-block-heading\"> 14. K\u00f6pr\u00fc olu\u015fturun<\/h3><p> \u015eimdi, bir de\u011fer araman\u0131n yan\u0131 s\u0131ra o de\u011fer i\u00e7in bir k\u00f6pr\u00fc de olu\u015fturmak istedi\u011finizi varsayal\u0131m. Bu \u015fekilde arama s\u00fctununuzun bulundu\u011fu h\u00fccreye h\u0131zl\u0131 bir \u015fekilde gidebilirsiniz.<\/p><p> \u00d6rne\u011fin a\u015fa\u011f\u0131daki tabloda bir ki\u015finin ya\u015f\u0131n\u0131 alman\u0131z gerekiyor. Ve bu de\u011fer i\u00e7in bir k\u00f6pr\u00fc olu\u015fturursan\u0131z bu de\u011ferin bulundu\u011fu h\u00fccreye kolayca gidebilirsiniz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/58-creer-des-donnees-de-correspondance-dindex-de-lien-hypertexte.png\" sizes=\"\" srcset=\"\" alt=\"k\u00f6pr\u00fc dizini e\u015fle\u015fme verileri olu\u015ftur\"><\/figure><\/div><p> Bunun i\u00e7in INDEX ve MATCH ile HYPERLINK + Cell&#8217;i kullanmal\u0131y\u0131z ve form\u00fcl \u015f\u00f6yle olacakt\u0131r:<\/p><h4 class=\"wp-block-heading\"> Bu form\u00fcl \u015fu \u015fekilde \u00e7al\u0131\u015f\u0131yor<\/h4><p> Daha iyi anlamak i\u00e7in bu form\u00fcl\u00fc birka\u00e7 par\u00e7aya ay\u0131ral\u0131m.<\/p><ul><li> <strong>\u00d6ncelikle<\/strong> h\u00fccre fonksiyonunda indeks ve e\u015fle\u015fmeyi kulland\u0131n\u0131z. Ve h\u00fccre i\u015flevinde her iki i\u015flevi de kulland\u0131\u011f\u0131n\u0131zda, kar\u015f\u0131l\u0131k gelen de\u011fer yerine kar\u015f\u0131l\u0131k gelen de\u011ferin h\u00fccre referans\u0131n\u0131 al\u0131rs\u0131n\u0131z.<\/li><li> <strong>\u0130kinci olarak<\/strong> , &#8220;#&#8221; i\u015faretini h\u00fccre referans\u0131yla birle\u015ftirdiniz.<\/li><li> <strong>\u00dc\u00e7\u00fcnc\u00fcs\u00fc<\/strong> , ba\u011flant\u0131 metni olarak kullan\u0131lacak e\u015fle\u015fen de\u011feri elde etmek i\u00e7in index ve match&#8217;i tekrar kulland\u0131n\u0131z. Bu \u015fekilde kar\u015f\u0131l\u0131k gelen de\u011fere ve bu de\u011ferin bulundu\u011fu h\u00fccreye olan ba\u011flant\u0131ya sahip olursunuz.<\/li><\/ul><div class=\"gb-container gb-container-0df56012 gb-container-mt\"> <a class=\"gb-button gb-button-f9f432f4 gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/tr\/formuller\/\">Excel form\u00fcllerinin listesi<\/a><h2 class=\"gb-headline gb-headline-233444e8 gb-headline-text gb-headline-mt-heading\"> \u0130lgili form\u00fcller <\/h2><div class=\"gb-grid-wrapper gb-grid-wrapper-a16fa65c gb-grid-wrapper-mt-grid\"><div class=\"gb-grid-column gb-grid-column-50d07e0d\"><div class=\"gb-container gb-container-50d07e0d\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/tr\/iferror-gorunumu\/\">Excel&#8217;de #YOK yerine D\u00dc\u015eEYARA i\u00e7eren E\u011eERHATA<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/cift-yonlu-arama\/\">Excel&#8217;de iki y\u00f6nl\u00fc arama ger\u00e7ekle\u015ftirme<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/vssearch-eslesmesi\/\">Excel&#8217;de D\u00dc\u015eEYARA E\u015eLE\u015eT\u0130RME&#8217;yi birle\u015ftirme<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/birden-fazla-kritere-goz-atma\/\">Excel&#8217;de birden fazla \u00f6l\u00e7\u00fctle D\u00dc\u015eEYARA<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/vlookup-ozellikli-joker-karakterler\/\">Excel&#8217;de D\u00dc\u015eEYARA i\u00e7eren joker karakterler<\/a><\/li><\/ul><\/div><\/div><\/div><\/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-2054","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>Index-Match ile Excel&#039;de D\u00dc\u015eEYARA nas\u0131l tersine \u00e7evrilir?<\/title>\n<meta name=\"description\" content=\"Excel&#039;deki \u00f6rnekler ve \u00f6rnek dosyalar i\u00e7eren eksiksiz bir INDEX\u200cMATCH k\u0131lavuzu.\" \/>\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\/geriye-dogru-arama\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Index-Match ile Excel&#039;de D\u00dc\u015eEYARA nas\u0131l tersine \u00e7evrilir?\" \/>\n<meta property=\"og:description\" content=\"Excel&#039;deki \u00f6rnekler ve \u00f6rnek dosyalar i\u00e7eren eksiksiz bir INDEX\u200cMATCH k\u0131lavuzu.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/tr\/geriye-dogru-arama\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-10T06:04:24+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/correspondance-dindex-obtenir-la-valeur-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=\"16 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/geriye-dogru-arama\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/geriye-dogru-arama\/\",\"name\":\"Index-Match ile Excel&#39;de D\u00dc\u015eEYARA nas\u0131l tersine \u00e7evrilir?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/geriye-dogru-arama\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/geriye-dogru-arama\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/correspondance-dindex-obtenir-la-valeur-1.png\",\"datePublished\":\"2023-10-22T06:31:46+00:00\",\"dateModified\":\"2023-12-10T06:04:24+00:00\",\"description\":\"Excel&#39;deki \u00f6rnekler ve \u00f6rnek dosyalar i\u00e7eren eksiksiz bir INDEX\u200cMATCH k\u0131lavuzu.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/geriye-dogru-arama\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/tr\/geriye-dogru-arama\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/geriye-dogru-arama\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/correspondance-dindex-obtenir-la-valeur-1.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/correspondance-dindex-obtenir-la-valeur-1.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/geriye-dogru-arama\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/exceladvisor.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Index-match ile excel&#39;de d\u00fc\u015feyara nas\u0131l tersine \u00e7evrilir?\"}]},{\"@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":"Index-Match ile Excel&#39;de D\u00dc\u015eEYARA nas\u0131l tersine \u00e7evrilir?","description":"Excel&#39;deki \u00f6rnekler ve \u00f6rnek dosyalar i\u00e7eren eksiksiz bir INDEX\u200cMATCH k\u0131lavuzu.","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\/geriye-dogru-arama\/","og_locale":"tr_TR","og_type":"article","og_title":"Index-Match ile Excel&#39;de D\u00dc\u015eEYARA nas\u0131l tersine \u00e7evrilir?","og_description":"Excel&#39;deki \u00f6rnekler ve \u00f6rnek dosyalar i\u00e7eren eksiksiz bir INDEX\u200cMATCH k\u0131lavuzu.","og_url":"https:\/\/exceladvisor.org\/tr\/geriye-dogru-arama\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-10T06:04:24+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/correspondance-dindex-obtenir-la-valeur-1.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tahmini okuma s\u00fcresi":"16 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/tr\/geriye-dogru-arama\/","url":"https:\/\/exceladvisor.org\/tr\/geriye-dogru-arama\/","name":"Index-Match ile Excel&#39;de D\u00dc\u015eEYARA nas\u0131l tersine \u00e7evrilir?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/tr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/tr\/geriye-dogru-arama\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/tr\/geriye-dogru-arama\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/correspondance-dindex-obtenir-la-valeur-1.png","datePublished":"2023-10-22T06:31:46+00:00","dateModified":"2023-12-10T06:04:24+00:00","description":"Excel&#39;deki \u00f6rnekler ve \u00f6rnek dosyalar i\u00e7eren eksiksiz bir INDEX\u200cMATCH k\u0131lavuzu.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/tr\/geriye-dogru-arama\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/tr\/geriye-dogru-arama\/"]}]},{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/exceladvisor.org\/tr\/geriye-dogru-arama\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/correspondance-dindex-obtenir-la-valeur-1.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/correspondance-dindex-obtenir-la-valeur-1.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/tr\/geriye-dogru-arama\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/exceladvisor.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Index-match ile excel&#39;de d\u00fc\u015feyara nas\u0131l tersine \u00e7evrilir?"}]},{"@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\/2054","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=2054"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/2054\/revisions"}],"predecessor-version":[{"id":2721,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/2054\/revisions\/2721"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/media?parent=2054"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}