\u00d6rne\u011fin, bunu yapmak i\u00e7in a\u015fa\u011f\u0131daki s\u00f6zdizimini kullanabilirsiniz:<\/span><\/span><\/p>\n Bu \u00f6zel form\u00fcl, Tablo 1’in<\/strong> s\u00fctun adlar\u0131nda A11<\/strong> h\u00fccresinin de\u011ferini ve Tablo 1’in<\/strong> “Tak\u0131m” s\u00fctununda B10<\/strong> h\u00fccresinin de\u011ferini arar ve bu de\u011ferlerin kesi\u015fimindeki de\u011feri d\u00f6nd\u00fcr\u00fcr.<\/span><\/p>\n A\u015fa\u011f\u0131daki \u00f6rnek, bu s\u00f6zdiziminin pratikte nas\u0131l kullan\u0131laca\u011f\u0131n\u0131 g\u00f6sterir.<\/span><\/p>\n Diyelim ki Excel’de farkl\u0131 basketbol tak\u0131mlar\u0131n\u0131n \u00fc\u00e7 farkl\u0131 ma\u00e7ta att\u0131\u011f\u0131 puanlarla ilgili bilgileri i\u00e7eren bir tablomuz ve her tak\u0131m\u0131n puan de\u011ferlerini bulmak istedi\u011fimiz farkl\u0131 formatta ba\u015fka bir tablomuz var:<\/span> <\/p>\n \u0130kinci tabloda ma\u00e7 numaras\u0131n\u0131 ve tak\u0131m ad\u0131n\u0131 aramak ve ilk tablodan uygun puan de\u011ferini d\u00f6nd\u00fcrmek istedi\u011fimizi varsayal\u0131m.<\/span><\/p>\n Bunu yapmak i\u00e7in B11<\/b> h\u00fccresine a\u015fa\u011f\u0131daki form\u00fcl\u00fc yazabiliriz:<\/span><\/p>\n A\u015fa\u011f\u0131daki ekran g\u00f6r\u00fcnt\u00fcs\u00fc bu form\u00fcl\u00fcn pratikte nas\u0131l kullan\u0131laca\u011f\u0131n\u0131 g\u00f6stermektedir:<\/span> <\/p>\n Mavs i\u00e7in Oyun 1 puan de\u011ferine kar\u015f\u0131l\u0131k gelen ilk dizideki de\u011fer olan 100<\/strong> form\u00fcl\u00fcn\u00fc d\u00f6nd\u00fcr\u00fcr.<\/span><\/p>\n Daha sonra bu form\u00fcl\u00fc t\u0131klay\u0131p B s\u00fctunundaki kalan h\u00fccrelere ve ard\u0131ndan G s\u00fctununa ula\u015fana kadar her bir h\u00fccreye s\u00fcr\u00fckleyebiliriz:<\/span> <\/p>\n Form\u00fcl, tak\u0131m ad\u0131 ve ma\u00e7 numaras\u0131n\u0131n her kombinasyonu i\u00e7in puan de\u011ferini do\u011fru bir \u015fekilde d\u00f6nd\u00fcr\u00fcr.<\/span><\/p>\n A\u015fa\u011f\u0131daki e\u011fitimlerde Excel’de di\u011fer yayg\u0131n i\u015flemlerin nas\u0131l ger\u00e7ekle\u015ftirilece\u011fi a\u00e7\u0131klanmaktad\u0131r:<\/span><\/p>\n Excel: INDEX MATCH ile IF i\u015flevinin nas\u0131l kullan\u0131laca\u011f\u0131<\/a> Bir tablonun sat\u0131r ve s\u00fctunlar\u0131nda belirli de\u011ferleri bulmak ve ba\u015fka bir tablodan kar\u015f\u0131l\u0131k gelen de\u011feri d\u00f6nd\u00fcrmek i\u00e7in INDIRECT i\u015flevini Excel’deki INDEX ve MATCH i\u015flevleriyle birlikte kullanabilirsiniz. \u00d6rne\u011fin, bunu yapmak i\u00e7in a\u015fa\u011f\u0131daki s\u00f6zdizimini kullanabilirsiniz: =INDEX(INDIRECT(“Table1[“& $A11 &”]”),MATCH( B$10 , Table1[[Team]:[Team]] ,0)) Bu \u00f6zel form\u00fcl, Tablo 1’in s\u00fctun adlar\u0131nda A11 h\u00fccresinin de\u011ferini ve Tablo 1’in “Tak\u0131m” s\u00fctununda […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[],"class_list":["post-4887","post","type-post","status-publish","format-standard","hentry","category-rehber"],"yoast_head":"\n =INDEX(INDIRECT(\"Table1[\"& $A11<\/span> &\"]\"),MATCH( B$10<\/span> , Table1[[Team]:[Team]]<\/span> ,0))<\/strong><\/pre>\n \u00d6rnek: Excel’de INDEX MATCH ile INDIRECT nas\u0131l kullan\u0131l\u0131r?<\/strong><\/span><\/h2>\n
![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/indir1.png\")
<\/p>\n =INDEX(INDIRECT(\"Table1[\"& $A11<\/span> &\"]\"),MATCH( B$10<\/span> , Table1[[Team]:[Team]]<\/span> ,0))<\/strong><\/pre>\n![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/indir2.png\")
<\/p>\n![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/indir3.png\")
<\/p>\n Ek kaynaklar<\/strong><\/span><\/h2>\n
Excel: INDEX MATCH ile SUM nas\u0131l kullan\u0131l\u0131r?<\/a>
Excel: Birden \u00c7ok De\u011feri Dikey Olarak D\u00f6nd\u00fcrmek i\u00e7in INDEX ve MATCH’i Kullan\u0131n<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"