{"id":4818,"date":"2023-03-14T19:53:31","date_gmt":"2023-03-14T16:53:31","guid":{"rendered":"https:\/\/bymmb.com\/?p=4818"},"modified":"2023-03-14T19:53:33","modified_gmt":"2023-03-14T16:53:33","slug":"excel-caprazaraxlookup-fonksiyonu","status":"publish","type":"post","link":"https:\/\/bymmb.com\/excel-caprazaraxlookup-fonksiyonu\/","title":{"rendered":"Excel \u00c7aprazara(XLOOKUP) Fonksiyonu"},"content":{"rendered":"\n<p>2019 y\u0131l\u0131nda Office 365 ile birlikte tan\u0131t\u0131lan bana g\u00f6re Excel&#8217;in en g\u00fc\u00e7l\u00fc fonksiyonudur. Tek ba\u015f\u0131na D\u00fc\u015feyara(Vlookup), \u0130ndis(Index), Ka\u00e7\u0131nc\u0131(Match), Yatayara(Hlookup), E\u011ferhata(Iferror) fonksiyonlar\u0131n\u0131n yerine kullan\u0131labilir.<\/p>\n\n\n\n<p>Ancak bu fonksiyonu kullanabilmek i\u00e7in ya Office 2021 ya da Microsoft 365 kullan\u0131c\u0131s\u0131 olman\u0131z gerekiyor. Eski versiyonlarda \u00c7aprazara fonksiyonunu bulamayacaks\u0131n\u0131z.<\/p>\n\n\n\n<p>T\u00fcm detaylar\u0131yla birlikte \u00f6\u011frenmek i\u00e7in a\u015fa\u011f\u0131da yer alan video&#8217;yu izleyebilirsiniz.<\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe loading=\"lazy\" title=\"Excel&#039;de \u00c7aprazara Uygulamalar\u0131 (XLOOKUP)\" width=\"720\" height=\"405\" src=\"https:\/\/www.youtube.com\/embed\/JaH5GrtLEaw?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" allowfullscreen><\/iframe>\n<\/div><\/figure>\n\n\n\n<p>Video&#8217;da yer alan dosyaya <a href=\"https:\/\/bit.ly\/3T5YnB3\" target=\"_blank\" data-type=\"URL\" data-id=\"https:\/\/bit.ly\/3T5YnB3\" rel=\"noreferrer noopener\">buradan<\/a> ula\u015fabilirsiniz.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>2019 y\u0131l\u0131nda Office 365 ile birlikte tan\u0131t\u0131lan bana g\u00f6re Excel&#8217;in en g\u00fc\u00e7l\u00fc fonksiyonudur. Tek ba\u015f\u0131na D\u00fc\u015feyara(Vlookup), \u0130ndis(Index), Ka\u00e7\u0131nc\u0131(Match), Yatayara(Hlookup), E\u011ferhata(Iferror) fonksiyonlar\u0131n\u0131n yerine kullan\u0131labilir.<\/p>\n","protected":false},"author":1,"featured_media":4820,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_kad_blocks_custom_css":"","_kad_blocks_head_custom_js":"","_kad_blocks_body_custom_js":"","_kad_blocks_footer_custom_js":"","_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"_joinchat":[],"footnotes":""},"categories":[1],"tags":[1173,22,804,21,453,207,1174],"acf":[],"views":670,"taxonomy_info":{"category":[{"value":1,"label":"Genel"}],"post_tag":[{"value":1173,"label":"\u00e7aprazara"},{"value":22,"label":"d\u00fc\u015feyara"},{"value":804,"label":"D\u00fc\u015feyara (VLOOKUP) Fonksiyonu"},{"value":21,"label":"excel"},{"value":453,"label":"excel form\u00fclleri"},{"value":207,"label":"excel \u00f6rnekleri"},{"value":1174,"label":"xlookup"}]},"featured_image_src_large":["https:\/\/bymmb.com\/wp-content\/uploads\/2023\/03\/xlookup-uygulamalari-1024x576.png",1024,576,true],"author_info":{"display_name":"bymmb","author_link":"https:\/\/bymmb.com\/author\/bymmb\/"},"comment_info":0,"category_info":[{"term_id":1,"name":"Genel","slug":"genel","term_group":0,"term_taxonomy_id":1,"taxonomy":"category","description":"","parent":0,"count":26,"filter":"raw","cat_ID":1,"category_count":26,"category_description":"","cat_name":"Genel","category_nicename":"genel","category_parent":0}],"tag_info":[{"term_id":1173,"name":"\u00e7aprazara","slug":"caprazara","term_group":0,"term_taxonomy_id":1173,"taxonomy":"post_tag","description":"","parent":0,"count":4,"filter":"raw"},{"term_id":22,"name":"d\u00fc\u015feyara","slug":"duseyara","term_group":0,"term_taxonomy_id":22,"taxonomy":"post_tag","description":"","parent":0,"count":3,"filter":"raw"},{"term_id":804,"name":"D\u00fc\u015feyara (VLOOKUP) Fonksiyonu","slug":"duseyara-vlookup-fonksiyonu","term_group":0,"term_taxonomy_id":804,"taxonomy":"post_tag","description":"","parent":0,"count":4,"filter":"raw"},{"term_id":21,"name":"excel","slug":"excel","term_group":0,"term_taxonomy_id":21,"taxonomy":"post_tag","description":"","parent":0,"count":8,"filter":"raw"},{"term_id":453,"name":"excel form\u00fclleri","slug":"excel-formulleri","term_group":0,"term_taxonomy_id":453,"taxonomy":"post_tag","description":"","parent":0,"count":9,"filter":"raw"},{"term_id":207,"name":"excel \u00f6rnekleri","slug":"excel-ornekleri","term_group":0,"term_taxonomy_id":207,"taxonomy":"post_tag","description":"","parent":0,"count":34,"filter":"raw"},{"term_id":1174,"name":"xlookup","slug":"xlookup","term_group":0,"term_taxonomy_id":1174,"taxonomy":"post_tag","description":"","parent":0,"count":4,"filter":"raw"}],"_links":{"self":[{"href":"https:\/\/bymmb.com\/wp-json\/wp\/v2\/posts\/4818"}],"collection":[{"href":"https:\/\/bymmb.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bymmb.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/bymmb.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/bymmb.com\/wp-json\/wp\/v2\/comments?post=4818"}],"version-history":[{"count":1,"href":"https:\/\/bymmb.com\/wp-json\/wp\/v2\/posts\/4818\/revisions"}],"predecessor-version":[{"id":4821,"href":"https:\/\/bymmb.com\/wp-json\/wp\/v2\/posts\/4818\/revisions\/4821"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/bymmb.com\/wp-json\/wp\/v2\/media\/4820"}],"wp:attachment":[{"href":"https:\/\/bymmb.com\/wp-json\/wp\/v2\/media?parent=4818"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bymmb.com\/wp-json\/wp\/v2\/categories?post=4818"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bymmb.com\/wp-json\/wp\/v2\/tags?post=4818"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}