{"id":5026,"date":"2021-02-12T20:02:56","date_gmt":"2021-02-12T20:02:56","guid":{"rendered":"https:\/\/clickteller.com\/excel-vlookup-index-match-fonksiyonlari\/"},"modified":"2023-09-18T06:20:38","modified_gmt":"2023-09-18T06:20:38","slug":"excel-vlookup-index-match-fonksiyonlari","status":"publish","type":"post","link":"https:\/\/clickteller.com\/tr\/excel-vlookup-index-match-fonksiyonlari\/","title":{"rendered":"Excel Vlookup, Index, Match Fonksiyonlar\u0131"},"content":{"rendered":"

[et_pb_section fb_built=”1″ admin_label=”section” _builder_version=”4.16″ global_colors_info=”{}”][et_pb_row admin_label=”row” _builder_version=”4.16″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text admin_label=”Text” _builder_version=”4.18.0″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” hover_enabled=”0″ global_colors_info=”{}” sticky_enabled=”0″]<\/p>\n

Merhaba arkada\u015flar,<\/span><\/p>\n

Dijital pazarlama kampanyalar\u0131 ve web analizi raporlar\u0131 haz\u0131rlarken en \u00e7ok ihtiya\u00e7 duydu\u011fum fonksiyonlar olan Vlookup, Index ve Match hakk\u0131nda bildiklerimi aktarmak isterim.<\/span><\/p>\n

\u00c7ok say\u0131da verinin kar\u015f\u0131la\u015ft\u0131r\u0131lmas\u0131, bir h\u00fccredeki bilginin farkl\u0131 bir dizinin i\u00e7inde bulunmas\u0131 gibi durumlarda kolayl\u0131k sa\u011flamaktad\u0131r. Bu fonksiyonlar sayesinde saatler s\u00fcrecek arama, e\u015fle\u015ftirme gibi i\u015flemleri \u00e7ok k\u0131sa s\u00fcrelerde tamamlayabilirsiniz.<\/span><\/p>\n

\u00d6ncelikle Vlookup fonksiyonunun \u00e7al\u0131\u015fma prensibini anlayal\u0131m.<\/span><\/p>\n

<\/span><\/p>\n

Vlookup<\/span><\/h2>\n

<\/span><\/p>\n

VLOOKUP(lookup_value,table_array,col_index_num,range_lookup)<\/span><\/p>\n

lookup_value : aranacak de\u011fer<\/span><\/p>\n

table_array : de\u011ferin aranaca\u011f\u0131 dizi<\/span><\/p>\n

col_index_num : fonksiyonun dizideki ka\u00e7\u0131nc\u0131 s\u00fctunu de\u011fer olarak geri d\u00f6nd\u00fcrece\u011fi<\/span><\/p>\n

range_lookup : tam e\u015fle\u015fme \/ yak\u0131n e\u015fle\u015fme se\u00e7imi (FALSE \/ TRUE)\u00d6rnek bir dizi ve de\u011fer \u00fczerinden bakmak istersek;<\/span><\/p>\n

\"\"<\/span><\/p>\n

Fonksiyon M\u00fc\u015fteri 11 de\u011ferini sol taraftaki tablonun i\u00e7inde ar\u0131yor, dizide M\u00fc\u015fteri 11 de\u011ferini buldu\u011fu sat\u0131r\u0131ndaki, ikinci s\u00fctundaki de\u011feri d\u00f6nd\u00fcr\u00fcyor.<\/span><\/p>\n

\"\"<\/span><\/p>\n

B\u00f6ylelikle, 11 numaral\u0131 m\u00fc\u015fterinin telefon numaras\u0131n\u0131 elde edebiliyoruz.<\/span><\/p>\n

Bu fonksiyonu daha fazla veriyi birbiri ile kar\u015f\u0131la\u015ft\u0131rmak i\u00e7in de kullanabilirsiniz. Fonksiyonun bulundu\u011fu kutucu\u011fun sa\u011f alt taraf\u0131na \u00e7ift t\u0131klad\u0131\u011f\u0131n\u0131zda form\u00fcl di\u011fer sat\u0131rlar i\u00e7in de ge\u00e7erli olacakt\u0131r.<\/span><\/p>\n

\"\"<\/span><\/p>\n

Yukar\u0131daki \u00f6rnekteki gibi, m\u00fc\u015fterilerin tersten listelenmesi durumunda, do\u011fru telefonlar\u0131n hepsi fonksiyonun d\u00f6n\u00fc\u015f de\u011feri olarak h\u00fccrelere yerle\u015fecektir.<\/span><\/p>\n

<\/span><\/p>\n

Index ve Match \u0130kilisi<\/span><\/h2>\n

Vlookup, \u00e7al\u0131\u015fma prensibi gere\u011fi daha fazla kar\u015f\u0131la\u015ft\u0131rma i\u015flemi yapt\u0131\u011f\u0131 i\u00e7in, \u00e7ok uzun dizilerde uyguland\u0131\u011f\u0131nda y\u00fcksek performans harcamakta ve uzun s\u00fcre gerektirmektedir. Y\u00fczbinlerce sat\u0131rdan olu\u015fan bir dizide y\u00fczbinlerce arama yaparsan\u0131z, Excel\u2019in i\u015flemleri bitirmesi saatler hatta g\u00fcnler alabilir.<\/span><\/p>\n

Bu s\u00fcreyi bir miktar da olsa k\u0131saltmak ad\u0131na, bir alternatif olan Index ve Match fonksiyonlar\u0131n\u0131ndan da bahsetmek isterim.<\/span><\/p>\n

<\/span><\/p>\n

Match Fonksiyonu<\/span><\/h3>\n

MATCH(lookup_value, lookup_array, [match_type])<\/span><\/p>\n

lookup_value : aranacak de\u011fer<\/span><\/p>\n

lookup_array : aranaca\u011f\u0131 s\u00fctun<\/span><\/p>\n

match_type : tam e\u015fle\u015fme \/ yak\u0131n e\u015fle\u015fme se\u00e7imi (FALSE \/ TRUE)<\/span><\/p>\n

\"\"<\/span><\/p>\n

Match fonksiyonunu Vlookup fonksiyonundan ay\u0131ran temel \u00f6zellik, \u00fcst tabloda da g\u00f6rece\u011finiz gibi araman\u0131n sadece bir s\u00fctunda yap\u0131labilmesi. Ayr\u0131ca fonksiyon, de\u011fer olarak h\u00fccredeki de\u011feri de\u011fil, buldu\u011fu sat\u0131r\u0131n indisini geri d\u00f6nd\u00fcr\u00fcr.<\/span><\/p>\n

<\/span><\/p>\n

Index Fonksyionu<\/span><\/h3>\n

INDEX(array, row_num, [column_num])<\/span><\/p>\n

array : dizi<\/span><\/p>\n

row_num : sat\u0131r indisi<\/span><\/p>\n

column_num : s\u00fctun indisi<\/span><\/p>\n

Index fonksiyonu bir diziye bakar, sat\u0131r ve s\u00fctun indislerini kullanarak bu dizide buldu\u011fu h\u00fccredeki de\u011fer geri d\u00f6nd\u00fcr\u00fcr.<\/span><\/p>\n

Birlikte kullan\u0131ld\u0131klar\u0131nda, Match ile sat\u0131r indisi bulunduktan sonra, Index ile o sat\u0131r indisindeki ve 2. s\u00fctundaki de\u011feri geri d\u00f6nd\u00fcrebiliriz. Sonu\u00e7 olarak Vlookup ile hi\u00e7 bir farkl\u0131l\u0131k g\u00f6stermemesine ra\u011fmen, \u00e7al\u0131\u015fma prensipleri a\u00e7\u0131s\u0131ndan \u00e7ok b\u00fcy\u00fck farkl\u0131l\u0131klar vard\u0131r.<\/span><\/p>\n

\u00d6zellikle \u00e7ok b\u00fcy\u00fck dizilerde Index \/ Match ikilisini kullanmak hesaplamada Vlookup a k\u0131yasla daha avantajl\u0131 olmaktad\u0131r.<\/span><\/p>\n

Te\u015fekk\u00fcrler.<\/span><\/p>\n

 <\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"

Merhaba arkada\u015flar, Dijital pazarlama kampanyalar\u0131 ve web analizi raporlar\u0131 haz\u0131rlarken en \u00e7ok ihtiya\u00e7 duydu\u011fum fonksiyonlar olan Vlookup, Index ve Match hakk\u0131nda bildiklerimi aktarmak isterim. \u00c7ok say\u0131da verinin kar\u015f\u0131la\u015ft\u0131r\u0131lmas\u0131, bir h\u00fccredeki bilginin farkl\u0131 bir dizinin i\u00e7inde bulunmas\u0131 gibi durumlarda kolayl\u0131k sa\u011flamaktad\u0131r. Bu fonksiyonlar sayesinde saatler s\u00fcrecek arama, e\u015fle\u015ftirme gibi i\u015flemleri \u00e7ok k\u0131sa s\u00fcrelerde tamamlayabilirsiniz. \u00d6ncelikle Vlookup […]<\/p>\n","protected":false},"author":11,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[],"tags":[],"class_list":["post-5026","post","type-post","status-publish","format-standard","hentry"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/clickteller.com\/tr\/wp-json\/wp\/v2\/posts\/5026","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/clickteller.com\/tr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/clickteller.com\/tr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/clickteller.com\/tr\/wp-json\/wp\/v2\/users\/11"}],"replies":[{"embeddable":true,"href":"https:\/\/clickteller.com\/tr\/wp-json\/wp\/v2\/comments?post=5026"}],"version-history":[{"count":8,"href":"https:\/\/clickteller.com\/tr\/wp-json\/wp\/v2\/posts\/5026\/revisions"}],"predecessor-version":[{"id":5034,"href":"https:\/\/clickteller.com\/tr\/wp-json\/wp\/v2\/posts\/5026\/revisions\/5034"}],"wp:attachment":[{"href":"https:\/\/clickteller.com\/tr\/wp-json\/wp\/v2\/media?parent=5026"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/clickteller.com\/tr\/wp-json\/wp\/v2\/categories?post=5026"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/clickteller.com\/tr\/wp-json\/wp\/v2\/tags?post=5026"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}