Excel'de İki Koşula Göre Düşeyara Formülü Kullanımı | Çaprazara
30,3bin30,3 bin izleme
Yayın tarihi 22 kas 202322 kas 2023
{"pages":{"search":{"query":"Excel+Eğitim+|+Emre+Akyüz","originalQuery":"Excel+Eğitim+|+Emre+Akyüz","serpid":"1752033050024221-2602925977422066606-balancer-l7leveler-kubr-yp-sas-118-BAL","reqid":"1752033050024221-2602925977422066606-balancer-l7leveler-kubr-yp-sas-118-BAL","parentReqid":"","serpItems":[{"id":"12872940642157707889-0-0","type":"videoSnippet","props":{"videoId":"12872940642157707889"},"curPage":0}],"filters":{},"serpFooter":{"linksGroups":[{"type":"geo","links":[{"label":"Columbus","title":"Columbus","url":"//yandex.com.tr/tune/geo/","logNode":{"name":"region"},"target":"_self","a11yLabel":"Bölgeniz Columbus","needRetpath":true}]},{"type":"help","links":[{"label":"Bize ulaşın","url":"https://yandex.com.tr/support/video/troubleshooting.html","logNode":{"name":"feedback"},"needRetpath":true},{"label":"Yardım","url":"https://yandex.com.tr/support/video/","logNode":{"name":"help"},"needRetpath":true}]},{"type":"settings","links":[{"label":"Ayarlar","url":"https://yandex.com.tr/tune/search/","target":"_self","logNode":{"name":"settings"},"needRetpath":true}]},{"type":"company","links":[{"label":"Şirket hakkında","url":"//yandex.com.tr/company/","logNode":{"name":"about"},"target":"_blank"},{"label":"Kullanım lisansı","url":"//yandex.com.tr/legal/termsofuse/","logNode":{"name":"license"},"target":"_blank"},{"label":"Gizlilik Politikası","url":"//yandex.com.tr/legal/confidential/","logNode":{"name":"confidential"},"target":"_blank"}],"a11yHidden":true}],"hasExtralinks":true},"currentPage":0,"prevPageToLoad":-1,"nextPageToLoad":1,"isTranslationsFilterEnabled":false,"isTranslationsDistributionEnabled":false,"isTranslationsDistributionOnboardingEnabled":false,"isFeedbackModalVisible":false,"viewerData":{},"prevention":{},"hasNextPage":false,"rightSerpItems":[{"type":"direct","id":"search-list-right","props":{"advRsyaActivateParams":{"pcodeParams":{"blockId":"R-I-8843654-1","renderTo":"search-list-right-0-R-I-8843654-1","pageNumber":0,"grab":"dEV4Y2VsK0XEn2l0aW0rfCtFbXJlK0FrecO8ego=","darkTheme":false,"lazyLoad":false,"extParams":{"reqid":"1752033050024221-2602925977422066606-balancer-l7leveler-kubr-yp-sas-118-BAL","ui":"desktop","yuid":"9037840391752033048"}}},"isAdult":false,"position":0,"placement":"search-list-right"},"curPage":0}],"quasarData":{"title":""},"isAdultQuery":false,"errorList":[],"layout":"list","retpath":"https%3A%2F%2Fgs.yandex.com.tr%2Fvideo%2Fpreview%2F12872940642157707889%3Ftext%3DExcel%252BE%25C4%259Fitim%252B%257C%252BEmre%252BAky%25C3%25BCz"},"main":{"_isInitial":true,"snippets":[],"serpFooter":{"linksGroups":[]},"isLoggedIn":false}},"internal":{"nonce":"6029259774220666067118","expFlags":{"video_depot_viewer":1,"video_instream_player_yaru_loader":1,"video_skeleton_doc_update":1,"velocity_delay_drawer":1,"video_instream_disable_hosts":"dzen.ru,ok.ru,vk.com,video.mail.ru","video_search_toggle_with_text":1,"video_single_vh_unmute":1,"video_update_d2d_after_clickout":1,"video_viewer_desktop_hide_tabs":1,"velocity_disable_suspense":1,"video_viewer_desktop_smart_layout":1,"dark_theme_desktop":"cookie","video_instream_player_config":{"vmapScenarioId":119,"category":2,"impId":7,"partnerId":2216089},"video_font_yandex_sans":1,"video_adv_new_show_rules":1,"video_resource_loader":1,"video_adv_config_desktop":{"before-player":{"regular":{"default":"R-I-2120168-1"}}},"video_nohost_full_filter_onboarding_enable":1,"video_skeleton_direct_under_player_update":1,"video_instream_player_config_porno":{"vmapScenarioId":119,"category":3,"impId":4,"partnerId":1988486},"video_vh_player_js":0,"video_dzc":1,"video_masthead_ratio":"180,4","video_searchdata_scheme":1,"video_adv_serp_right_fixed_screens":3,"video_single_vh_iframe":1,"velocity_delay_metrika":1,"video_viewer_desktop_visible_header":1,"video_partner_label":1,"video_direct_render_in_viewport":1,"video_skeleton_instream_update":1,"video_resource_loader_load_timeout":6000,"int_tr":1,"video_viewer_catch_sandbox_early_inits":1,"int_newstr_header_tab":1,"mmui_extended_escape_scheme":"searchdata.clips.0.authorname","spok":"id","video_search_grid_direct_repeat":6,"video_direct_config_desktop_search":"search-grid-row:R-I-48058-718:R-I-474674-109,search-grid-head:R-I-2120168-7","init_meta":{"ask-user-purchase-history":1,"use-src-videoquickp":1,"enable-begemot":1,"enable_masthead":1,"use-src-videop":1,"use-src-videoquickp_misspell":1,"enable_blackbox_multisession":1,"begemot-enable-cancelled-misspell-rtmr":1,"enable_video_iron_fetcher":1,"use-related-only":1,"ask-yandex-io-devices":1,"use-images-device-setup":1,"use-src-imagesp":1,"images-apphost-collections-front":1,"enable_aab_apphost":1,"graph-is-video-search":1,"use-src-imagesp_misspell":1,"use-src-imagesultrap":1,"use-video-apphost-pre-templates":1,"use-src-videop_misspell":1,"use-video-apphost-post-templates":1,"use-src-imagesquickp":1,"enable_video_carousels":"1","restrict-max-docs":"1000","use-images-region-setup":1,"use-post-auto2":1,"use-images-settings-setup":1,"use-src-ugc_favorites":1,"video_vitrina_disable":"0","use-images-user-setup":1,"use-video-pre-search-data":1,"begemot-no-suggest-history":1},"video_depot_viewer_masthead_ssr_only":1,"video_skeleton_direct_organic_update":1,"video_blender":1,"video_search_grid_enable":0,"video_depot_viewer_legacy_counters":1,"video_search_grid_direct_start":3,"video_instream_players_yaru_enable":1,"video_adv_new_show_rules_docs_count":1,"beauty_header_futuris_tab":9,"video_redirect_plug":2,"video_disable_serp_dzc":1,"video_direct_pos_id":"R-I-48058-73","dark_theme_desktop_default_pref":"system","video_search_toggle_enable":1,"video_viewer_desktop_blocks":1,"velocity_split_hydration":4,"video_duration_counter_new_format":1,"video_force_grid_on_premordie":1,"video_nohost_full_filter":1,"video_baobab_blockstat":1,"video_thumb_poster_full":1,"video_scrollpages":2,"video_serp_desktop_block_design":1,"video_nohost_youtube_filter":0,"video_direct_pos":5,"video_direct_viewport_margin_desktop":700},"slots":["949985,0,12;151171,0,13;126345,0,71;1230682,0,58;1281084,0,75;287509,0,61;1299576,0,57;1299588,0,47;1254366,0,48;1277331,0,83;1288010,0,13;1313711,0,9"],"isYandexNet":false,"platform":"desktop","isEnLogo":true,"retpath":"https%3A%2F%2Fgs.yandex.com.tr%2Fvideo%2Fpreview%2F12872940642157707889%3Ftext%3DExcel%252BE%25C4%259Fitim%252B%257C%252BEmre%252BAky%25C3%25BCz","mordaUrl":"//yandex.com.tr/","videoSearchUrl":"https://gs.yandex.com.tr/video/search?text=Excel%2BE%C4%9Fitim%2B%7C%2BEmre%2BAky%C3%BCz","settingsUrl":"https://yandex.com.tr/tune/search/","helpUrl":"https://yandex.com.tr/support/video/","legalUrl":"//legal.yandex.com.tr/termsofuse/","feedbackUrl":"https://yandex.com.tr/support/video/troubleshooting.html","basename":"/video","currentPageName":"previewShort","isYandexApp":false,"isYandexAppAndroid":false,"isYandexAppIos":false,"isAnyYaBro":false,"isAndroid":false,"isHamster":false,"serpid":"1752033050024221-2602925977422066606-balancer-l7leveler-kubr-yp-sas-118-BAL","backUrl":"//ya.ru","url":"https://gs.yandex.com.tr/video/preview/12872940642157707889?text=Excel%2BE%C4%9Fitim%2B%7C%2BEmre%2BAky%C3%BCz","isIntegrationTest":false,"isEndToEndTest":false,"shouldDropLogs":false,"seo":{"url":"https://gs.yandex.com.tr/video/preview/12872940642157707889?text=Excel%2BE%C4%9Fitim%2B%7C%2BEmre%2BAky%C3%BCz","title":"Excel'de İki Koşula Göre Düşeyara Formülü Kullanımı | Çaprazara","description":"Emre Akyüz ile ücretsiz Excel eğitim videoları. Excel'de ileri seviyeye ulaşmanız için bilmeniz ger...","image":"http://avatars.mds.yandex.net/get-vthumb/4077329/601837e24c16f6dba63bbda8634cc799/800x450","imageSecureUrl":"https://avatars.mds.yandex.net/get-vthumb/4077329/601837e24c16f6dba63bbda8634cc799/800x450","video":"https://video-preview.s3.yandex.net/7HCrQgIAAAA.mp4","videoType":"video/mp4","imageWidth":800,"imageHeight":450,"type":"video"},"isEmbedded":false,"isPumpkin":false,"quasarCsrfToken":"y3f82d64b8588fe826243afd92f557ba8","reportFeedbackBaseProps":{"initEmail":"","metaFields":{"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","userTestids":"949985,151171,126345,1230682,1281084,287509,1299576,1299588,1254366,1277331,1288010,1313711","queryText":"Excel+Eğitim+|+Emre+Akyüz","reqid":"1752033050024221-2602925977422066606-balancer-l7leveler-kubr-yp-sas-118-BAL","userRegionName":"","userRegionId":"function() {\n return this._region.id;\n }","yandexuid":"9037840391752033048","uid":"0","isChildAccount":false}},"userTestids":"191768,238743,246500,253288,265553,270072,277807,274239,294077,278842,299121,313103,331010,338398,378416,359879,415420,644350,652605,645301,679708,689693,690449,696466,696473,722746,740796,776165,771230,781521,790415,801982,851450,886706,883477,900639,931367,937268,969063,935488,945314,989988,982463,991363,990185,1015567,1011895,1035320,1033956,1035241,1036046,1087297,1089355,1060131,1099741,1071879,1078818,1077703,1116602,1045814,1131637,1144233,1151726,1152703,1156933,1174275,1173000,1167408,1202006,1194718,1221235,1228280,1239596,1227266,1226860,1279793,1279825,1246754,1277457,1281110,1276447,1289213,1288208,1313568,1299604","regionId":20815,"isYaRu":false,"shouldUnmountSearchPageInViewer":false,"videoGlobalContext":{"platform":"desktop","isPumpkin":false,"language":"tr","user_time":{"epoch":"1752033050","tz":"America/Louisville","to_iso":"2025-07-08T23:50:50-0400","__is_plain":1},"isQuasarEnabled":false,"isHermione":false,"shouldStubImages":true,"enableVideoPreviewInHermione":false,"reqid":"1752033050024221-2602925977422066606-balancer-l7leveler-kubr-yp-sas-118-BAL","tld":"com.tr","isEmbedded":false,"shouldDailyClickoutDzenInSerp":false,"shouldDailyClickoutDzenInViewer":true,"shouldDisableWebp":false,"removeLinkPrefix":"/video","shouldUseHighresPreview":true,"shouldCutSnippetTitle":true,"shouldShowPlusBadge":true,"reportFeedbackBaseProps":{"initEmail":"","metaFields":{"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","userTestids":"949985,151171,126345,1230682,1281084,287509,1299576,1299588,1254366,1277331,1288010,1313711","queryText":"Excel+Eğitim+|+Emre+Akyüz","reqid":"1752033050024221-2602925977422066606-balancer-l7leveler-kubr-yp-sas-118-BAL","userRegionName":"","userRegionId":"function() {\n return this._region.id;\n }","yandexuid":"9037840391752033048","uid":"0","isChildAccount":false}},"deviceDetect":{"OSFamily":"Unknown","isTV":0,"x64":0,"GoogleToolBarVersion":"","MultiTouch":0,"BrowserBase":"","YandexBarVersion":"","isTablet":0,"YandexBar":0,"hasWebOmni":0,"isTouch":0,"hasYandexCamera":0,"isMobile":0,"DeviceKeyboard":"","device":"desktop","TurboAppPlatformVersion":"","historySupport":0,"BrowserShellVersion":"","DeviceVendor":"","isBrowser":0,"hasFlash":0,"MailRuSputnikVersion":"","isSameSiteSupported":0,"BrowserBaseVersion":"","BrowserVersionRaw":"","hasWebVert":0,"DeviceId":"","error":"","MailRuAgent":0,"ScreenWidth":0,"inAppBrowser":0,"hasHTML5":0,"isEmulator":0,"J2ME":0,"MailRuAgentVersion":"","BrowserEngineVersionRaw":"537.36","isRobot":1,"__is_plain":1,"BrowserEngineVersion":"0537.0036","BrowserName":"Unknown","DeviceModel":"","BrowserEngine":"WebKit","DeviceName":"","OSVersionRaw":"","OSName":"","GoogleToolBar":0,"ScreenSize":"","isTurboApp":0,"MailRuSputnik":0,"YaBuildName":"","isWAP":0,"PreferMobile":0,"DesktopMode":0,"BrowserVersion":"","BitsPerPixel":0,"BrowserShell":"","YaGUI":"","isBeta":0,"OSVersion":"","ScreenHeight":0},"nonce":"6029259774220666067118","disableDoc2DocHostLink":true,"shouldHideChannelLink":true,"enableSlowBufferingAlert":false,"enableSlowBufferingAlertDedup":false,"userConnectionRtt":163,"visibleHeader":true,"hideTabs":true,"animated":false,"isServiceLikeViewer":false,"isDoc2DocScrollFix":false,"smartDesktopLayout":true,"isAdvDisabled":false,"shouldShowVideoPlaylistPane":false,"isVideoTranslationSupported":false,"isSummaryDisabled":false,"isPlainHeader":false,"shouldRenderBroSummaryApiContainer":false,"shouldDropLogs":false,"shouldUseBeacon":false,"hasAdBlock":false,"isVerificationMarkDisabled":false,"shouldPlayNonStopForExternal":false,"forceSlowBufferingAlert":false},"shouldShowAdvId":false,"isAdultQuery":false,"classQueryIsPornoWebScore":0.0008613072569,"showSensitive":false,"shouldReplaceHref":false},"user":{"tld":"com.tr","isEuDomain":false,"login":"","passportId":"","isLoggedIn":false,"locationName":"Columbus","isFamily":false,"yandexuid":"9037840391752033048","ugcCsrfToken":"","family":1,"isChild":false},"config":{"skinMode":"system","skin":"light","version":"releases/frontend/video/v1.1624.0#19c598bf2204641e066502556399e0d3f23c74e8","isGridSupported":false,"advConfig":{"under-player":{"regular":{"default":"R-I-48058-725","mail":"R-A-13411721-6"},"adult":{"default":"R-I-474674-114","mail":"R-A-13426421-6"}},"under-player-lite":{"regular":{"default":"R-I-48058-728"},"adult":{"default":"R-I-474674-103"}},"under-player-old":{"regular":{"default":"R-I-48058-725","mail":"R-A-13411721-6"},"adult":{"default":"R-I-474674-114","mail":"R-A-13426421-6"}},"video-list":{"regular":{"default":"R-I-48058-708","mail":"R-A-13411721-2"},"adult":{"default":"R-I-474674-101","mail":"R-A-13426421-2"}},"search-list":{"regular":{"default":"R-I-48058-715","mail":"R-A-13411721-3"},"adult":{"default":"R-I-474674-108","mail":"R-A-13426421-3"}},"search-grid-row":{"regular":{"default":"R-I-48058-718","mail":"R-A-13411721-4"},"adult":{"default":"R-I-474674-109","mail":"R-A-13426421-4"}},"search-grid-head":{"regular":{"default":"R-I-2120168-7"}},"search-list-right":{"regular":{"default":"R-I-8843654-1"}},"before-player-old":{"regular":{"default":"R-I-2120168-1"}},"before-player":{"regular":{"default":"R-I-2120168-1"}}},"isSkinInitedOnClient":false},"counters":{"params":{"useBeacon":false,"clickHost":"gs.yandex.com.tr/clck","pid":197},"dict":{"viewer":"2921","user":"538","info":"1275","sources":"1500","select":"775","close":"486","open":"842","source":"186","link":"513","click":"882","tech":"690","player":"1242","change":"719","summary":"3410","init":"1309","item":"22","button":"440","shown":"3780","copy":"1276","text":"232","load":"1724","fallback":"2010","channel":"1345","hide":"1656"}},"clips":{"items":{"12872940642157707889":{"videoId":"12872940642157707889","docid":"34-9-7-Z9DDA908055E68521","description":"Emre Akyüz ile ücretsiz Excel eğitim videoları. Excel'de ileri seviyeye ulaşmanız için bilmeniz gereken tüm detaylar bu kanalda anlatılmaktadır. Sıfırdan İleri Seviyeye Sertifikalı Eğitim Almak...","preview":{"posterSrc":"//avatars.mds.yandex.net/get-vthumb/4077329/601837e24c16f6dba63bbda8634cc799/564x318_1","videoSrc":"https://video-preview.s3.yandex.net/7HCrQgIAAAA.mp4","videoType":"video/mp4"},"target":"_self","position":"0","reqid":"1752033050024221-2602925977422066606-balancer-l7leveler-kubr-yp-sas-118-BAL","summary":{"isFull":true,"fullTextUrl":"/video/result?ask_summarization=1&numdoc=1&noreask=1&nomisspell=1&parent-reqid=1752033050024221-2602925977422066606-balancer-l7leveler-kubr-yp-sas-118-BAL&text=videoid:12872940642157707889","teaser":[{"list":{"type":"unordered","items":["Bu video, Excel'de birden fazla koşulu göz önünde bulundurarak arama yapma özelliğini anlatan bir eğitim içeriğidir.","Videoda, Excel'de çapraz ara formülü kullanılarak birden fazla koşulla düşey ara yapma yöntemi adım adım gösterilmektedir. Örnek olarak, personel ismi Emre ve şehir İzmir olan kişilerin satış adetlerini bulma işlemi anlatılmaktadır. Formülün nasıl kullanılacağı, arama değerlerinin nasıl girileceği ve sonuçların nasıl döndürüleceği detaylı olarak açıklanmaktadır. Ayrıca, çapraz ara formülünün Excel'in eski sürümlerinde çalışmadığı bilgisi de paylaşılmaktadır."]},"endTime":131,"title":"Excel'de Birden Fazla Koşulla Düşey Ara Yapma","beginTime":0}],"fullResult":[{"index":0,"title":"Excel'de Birden Fazla Koşula Göre Arama Yapma","list":{"type":"unordered","items":["Video, Excel'de birden fazla koşula göre arama yapma özelliğini anlatıyor.","Örnek olarak, personel ismi \"Emre\" ve şehir \"İzmir\" olan kayıtları bulup satış adetini getirmek istiyoruz.","Bu işlem için Çapraz Ara (XLOOKUP) formülü kullanılıyor."]},"beginTime":0,"endTime":33,"href":"/video/preview/12872940642157707889?parent-reqid=1752033050024221-2602925977422066606-balancer-l7leveler-kubr-yp-sas-118-BAL&text=Excel%2BE%C4%9Fitim%2B%7C%2BEmre%2BAky%C3%BCz&t=0&ask_summarization=1"},{"index":1,"title":"Çapraz Ara Formülünün Kullanımı","list":{"type":"unordered","items":["Formülde arama değeri kısmına önce personel ismi, sonra \"ve\" işareti ve şehir koşulu giriliyor.","Arama dizisi kısmında önce personel sütunu, sonra \"ve\" işareti ve şehir sütunu seçiliyor.","Sonuç değerini nereden döndüreceğimiz, yani satış adet sütunu seçiliyor."]},"beginTime":33,"endTime":89,"href":"/video/preview/12872940642157707889?parent-reqid=1752033050024221-2602925977422066606-balancer-l7leveler-kubr-yp-sas-118-BAL&text=Excel%2BE%C4%9Fitim%2B%7C%2BEmre%2BAky%C3%BCz&t=33&ask_summarization=1"},{"index":2,"title":"Formülün Çalışması ve Kısıtlamalar","list":{"type":"unordered","items":["Formül, belirtilen koşullara göre uygun kaydı bulup satış adetini getiriyor.","Farklı personel ve şehir kombinasyonları girildiğinde, formül uygun değerleri otomatik olarak döndürüyor.","Çapraz Ara formülü Excel'in eski sürümlerinde çalışmıyor, bu konu göz önünde bulundurulmalı."]},"beginTime":89,"endTime":129,"href":"/video/preview/12872940642157707889?parent-reqid=1752033050024221-2602925977422066606-balancer-l7leveler-kubr-yp-sas-118-BAL&text=Excel%2BE%C4%9Fitim%2B%7C%2BEmre%2BAky%C3%BCz&t=89&ask_summarization=1"}],"linkTemplate":"/video/preview/12872940642157707889?parent-reqid=1752033050024221-2602925977422066606-balancer-l7leveler-kubr-yp-sas-118-BAL&text=Excel%2BE%C4%9Fitim%2B%7C%2BEmre%2BAky%C3%BCz&t=%%timestamp%%&ask_summarization=1"},"isAdultDoc":false,"relatedParams":{"text":"Excel'de İki Koşula Göre Düşeyara Formülü Kullanımı | Çaprazara","related_orig_text":"Excel+Eğitim+|+Emre+Akyüz","related_porno":false,"related_short":true,"related_less_3m_off":true,"client":"d2d","no_cnt":1,"related_src":"serp","related":"{\"porno\":false,\"vfp\":1,\"orig_text\":\"Excel+Eğitim+|+Emre+Akyüz\",\"url\":\"http:\\/\\/www.youtube.com\\/watch?v=ROpRdkMOfxc\",\"src\":\"serp\",\"rvb\":\"EhYKFDEyODcyOTQwNjQyMTU3NzA3ODg5GhYKFDEyODcyOTQwNjQyMTU3NzA3ODg5WhQxMjg3Mjk0MDY0MjE1NzcwNzg4OWqxDBIBMBgAIkQaMAAKKWhob3pwd3JraXBtb3lvdmhoVUN0cGthSjQwVkpLWW5iWFRVSHpfM1l3EgIAESoQwg8PGg8_E4MBggQkAYAEKyqLARABGniBCPD99gT7APf28g8ICPwCEPL5AfYA_wAF9xcCAgT-APIACfv7AAAA7AkH-AYAAAD6BvD7A_4AABv4AQjxAAAAEwn3_fYAAAD9BfDw_wEAAP0T8AAD_wAAFAQB_f8AAAAXEwj5_v8AAQUJBAQAAAAA9u7v_AAAAAAgAC3028Y7OBNACUhOUAIqhAIQABrwAX9CKP_237MElC0P___DDQGdvhr_ESb4AK4xEgHEIOYBws_9AR7l1ACSFasBpe8CAPv2u_4e8O4BH-z5_hnpGgDe4NgBIgUXAPwx5QERJPv9GxVA__66GAA12An_Q_75_0bII_3C4RD9rfe8AWP4OQAX7QL_H_AtAwH94v6yEg8A4p_s-y2_6AYgl977IQ8i-xn-FQo-OSn--Ob8Ay_83QPoAPT49vLKAiAoCgcpEO8D2hASDEQK-_cdLC7-3g8ZBu4--AA4c-4TJBMvAxm8-_DbF-sLBgH7ARca6hjUH-b2_hUO8cJM8P4hFRjyxPUE5iAALSUj3zo4E0AJSGFQAirPBxAAGsAHY0Pvvg_Bp7zTgIM7o1M8vfTIG7zrTTG84OLXvHi0EDzYkwa7iEYnPgnEazwNhCk9OGmKvtEMPTztrn08OxlsPq4M6jyCjCU8dckovtpUnT2TkKM8R48Pvm2kkTxoOMo8NhxbPdow1LwMtNa8EjFVPrzeZz2eUcS8x1YEvNBk370Rhfu8kT_9vA1rjzzsvRi9G8lUvJ_xM7y5cB48bM_MPUI6H7x3gVQ7KBkvvaxgCr2F5p-8qUs2vtRWtrzV5I484UyCvBtMQz38R1A97WaGPBgzkz379yq8qcSQPRFIkzzHRLE7lXT_upTZRbscjyO9iIdNu35MEL3_pkE8qMghvgJ8HD3o6W0899a2Parw1DloVwQ78tHivASa_rwdeRw8MVuCvW5HXby1qoA8AUCEPflf-DxRNA285ww7vR_kqzzQptk61V-KPWswiD1v4po808JgParkLTuct5y7uF-pvV2H6jxjY7k8yD0EPIYTYj1pnm08u9ToPdV5VDycpfc5Ojs-PRjtEb0RInC7uk4TPpYGvjw8ISa70omEO_dGA726gU06GTQZPRQAKL3y45a7V1gVPYtUeL2SEN27m9yUPa2F2T35xqU66DI1PkF9UD0tVbO6tDOWPC7Ezzxft2O8LX2jvdmHJj1eqYC71D38vNgtIr1-y1G5uNIGPQhW1b0-uhK6YYIEPfql9Dwg-6y7HLjevB4bnL1u-HS5BeoDPbZHD70dhM670vGyvSeoPLy36p06Z1uCPc5LCj0q2GG5zBI4PU95dLyWpB06aeZkvZ27-jkYVlO5rm7rvKbwID0Llp65LKSXvJ24_L3o_Vm47fpAPZlpdr3nY_A4Bz7rvA9YQ715vQK6OkrUPArFEb168wY7EvVCvSIY5714Guo3N1OhvLOvFTn9MjU5Fwd8PUJ2Hr6jYIw36iq4PHXkBTpgRFO4Vwn2vVMPLLzhDg06D3davS1G-DxcHBY4ja73vMDJy72hpYE52th2PTiaJ7tLWQ64hA2_PSsW3z3zDaK3F2iCvVKruTxluZa4sEKQvUwAmb0hZWO42cuLvToin7wBl0A46hAOvZqkx7vA2W04gNQGPiwr7b0ILMA5QXF2Pd40Qj1fnKK27CwfvWvJVD1buaA42-GKPafEPzzRKxE5yzg6OypcCj3rsIM31TuBPO89h73Nk783cX-0PdekOz3kJ1q4P47GPSveCL6HIrS4iITPPWuySz2Jt4U4KEKPPJsbeLy5NL-4K6advVjywrzwqKW3uEuRvH7vJbxpk5I3IAA4E0AJSG1QASpzEAAaYBzxADsVKeTgF_nf_wwxM9j00OA64hv_QrMAokTYHww-w-nuBAAc9CkQpAAAACT62BzMAPB07fz_9NsxNMzQ0P7ofyX-V7i9BRAjui8KPu6CC-JHNgDbFsb-I83u__cXyyAALSw6FDs4E0AJSG9QAjAJOAFKAGAAaAA,\"}","related_url":"http://www.youtube.com/watch?v=ROpRdkMOfxc","parent-reqid":"1752033050024221-2602925977422066606-balancer-l7leveler-kubr-yp-sas-118-BAL","related_vfp":1,"relatedVideo":"yes"},"cwidth":1920,"cheight":1080,"cratio":1.77777,"dups":["12872940642157707889"],"episode":0,"season":0,"isEmbedOnly":false,"greenHost":"YouTube","hasTranslation":false,"contentTypeId":null}},"dups":{"12872940642157707889":{"videoId":"12872940642157707889","title":"Excel'de İki Koşula Göre Düşeyara Formülü Kullanımı | Çaprazara","cleanTitle":"Excel'de İki Koşula Göre Düşeyara Formülü Kullanımı | Çaprazara","host":{"title":"YouTube","href":"http://www.youtube.com/live/ROpRdkMOfxc","playerUri":"\u003ciframe src=\"//www.youtube.com/embed/ROpRdkMOfxc?enablejsapi=1&wmode=opaque\" frameborder=\"0\" scrolling=\"no\" allowfullscreen=\"1\" allow=\"autoplay; fullscreen; accelerometer; gyroscope; picture-in-picture\" aria-label=\"Video\">\u003c/iframe>","playerId":"youtube","providerName":"youtube.com","sourceHost":"www.youtube.com","name":"youtube.com","secondPart":{"type":"CHANNEL","id":"d3d3LnlvdXR1YmUuY29tO1VDdHBrYUo0MFZKS1luYlhUVUh6XzNZdw==","name":"Emre Akyüz","isVerified":false,"subscribersCount":0,"url":"/video/search?channelId=d3d3LnlvdXR1YmUuY29tO1VDdHBrYUo0MFZKS1luYlhUVUh6XzNZdw%3D%3D&how=tm&text=Emre+Aky%C3%BCz","origUrl":"http://www.youtube.com/@emreakyuuz","a11yText":"Emre Akyüz. "},"faviconUrl":"//favicon.yandex.net/favicon/v2/http%3A%2F%2Fyoutube.com?color=255%2C255%2C255%2C0&size=32&stub=1"},"duration":{"value":131,"text":"2:11","a11yText":"Süre 2 dakika 11 saniye"},"views":{"text":"30,3bin","shouldShowInSnippet":true,"a11yText":"30,3 bin izleme"},"date":"22 kas 2023","modifyTime":1700611200000,"isExternal":false,"shouldShowQuasar":false,"player":{"embedUrl":"https://www.youtube.com/embed/ROpRdkMOfxc?autoplay=1&enablejsapi=1&wmode=opaque","playerId":"youtube","videoUrl":"http://www.youtube.com/watch?v=ROpRdkMOfxc","reqid":"1752033050024221-2602925977422066606-balancer-l7leveler-kubr-yp-sas-118-BAL","duration":131},"parentClipId":"12872940642157707889","href":"/preview/12872940642157707889?parent-reqid=1752033050024221-2602925977422066606-balancer-l7leveler-kubr-yp-sas-118-BAL&text=Excel%2BE%C4%9Fitim%2B%7C%2BEmre%2BAky%C3%BCz","rawHref":"/video/preview/12872940642157707889?parent-reqid=1752033050024221-2602925977422066606-balancer-l7leveler-kubr-yp-sas-118-BAL&text=Excel%2BE%C4%9Fitim%2B%7C%2BEmre%2BAky%C3%BCz","isEmbedOnly":false}}},"viewer":{"_isInitial":false,"clips":{"items":{"12872940642157707889":{"videoId":"12872940642157707889","docid":"34-9-7-Z9DDA908055E68521","description":"Emre Akyüz ile ücretsiz Excel eğitim videoları. Excel'de ileri seviyeye ulaşmanız için bilmeniz gereken tüm detaylar bu kanalda anlatılmaktadır. Sıfırdan İleri Seviyeye Sertifikalı Eğitim Almak...","preview":{"posterSrc":"//avatars.mds.yandex.net/get-vthumb/4077329/601837e24c16f6dba63bbda8634cc799/564x318_1","videoSrc":"https://video-preview.s3.yandex.net/7HCrQgIAAAA.mp4","videoType":"video/mp4"},"target":"_self","position":"0","reqid":"1752033050024221-2602925977422066606-balancer-l7leveler-kubr-yp-sas-118-BAL","summary":{"isFull":true,"fullTextUrl":"/video/result?ask_summarization=1&numdoc=1&noreask=1&nomisspell=1&parent-reqid=1752033050024221-2602925977422066606-balancer-l7leveler-kubr-yp-sas-118-BAL&text=videoid:12872940642157707889","teaser":[{"list":{"type":"unordered","items":["Bu video, Excel'de birden fazla koşulu göz önünde bulundurarak arama yapma özelliğini anlatan bir eğitim içeriğidir.","Videoda, Excel'de çapraz ara formülü kullanılarak birden fazla koşulla düşey ara yapma yöntemi adım adım gösterilmektedir. Örnek olarak, personel ismi Emre ve şehir İzmir olan kişilerin satış adetlerini bulma işlemi anlatılmaktadır. Formülün nasıl kullanılacağı, arama değerlerinin nasıl girileceği ve sonuçların nasıl döndürüleceği detaylı olarak açıklanmaktadır. Ayrıca, çapraz ara formülünün Excel'in eski sürümlerinde çalışmadığı bilgisi de paylaşılmaktadır."]},"endTime":131,"title":"Excel'de Birden Fazla Koşulla Düşey Ara Yapma","beginTime":0}],"fullResult":[{"index":0,"title":"Excel'de Birden Fazla Koşula Göre Arama Yapma","list":{"type":"unordered","items":["Video, Excel'de birden fazla koşula göre arama yapma özelliğini anlatıyor.","Örnek olarak, personel ismi \"Emre\" ve şehir \"İzmir\" olan kayıtları bulup satış adetini getirmek istiyoruz.","Bu işlem için Çapraz Ara (XLOOKUP) formülü kullanılıyor."]},"beginTime":0,"endTime":33,"href":"/video/preview/12872940642157707889?parent-reqid=1752033050024221-2602925977422066606-balancer-l7leveler-kubr-yp-sas-118-BAL&text=Excel%2BE%C4%9Fitim%2B%7C%2BEmre%2BAky%C3%BCz&t=0&ask_summarization=1"},{"index":1,"title":"Çapraz Ara Formülünün Kullanımı","list":{"type":"unordered","items":["Formülde arama değeri kısmına önce personel ismi, sonra \"ve\" işareti ve şehir koşulu giriliyor.","Arama dizisi kısmında önce personel sütunu, sonra \"ve\" işareti ve şehir sütunu seçiliyor.","Sonuç değerini nereden döndüreceğimiz, yani satış adet sütunu seçiliyor."]},"beginTime":33,"endTime":89,"href":"/video/preview/12872940642157707889?parent-reqid=1752033050024221-2602925977422066606-balancer-l7leveler-kubr-yp-sas-118-BAL&text=Excel%2BE%C4%9Fitim%2B%7C%2BEmre%2BAky%C3%BCz&t=33&ask_summarization=1"},{"index":2,"title":"Formülün Çalışması ve Kısıtlamalar","list":{"type":"unordered","items":["Formül, belirtilen koşullara göre uygun kaydı bulup satış adetini getiriyor.","Farklı personel ve şehir kombinasyonları girildiğinde, formül uygun değerleri otomatik olarak döndürüyor.","Çapraz Ara formülü Excel'in eski sürümlerinde çalışmıyor, bu konu göz önünde bulundurulmalı."]},"beginTime":89,"endTime":129,"href":"/video/preview/12872940642157707889?parent-reqid=1752033050024221-2602925977422066606-balancer-l7leveler-kubr-yp-sas-118-BAL&text=Excel%2BE%C4%9Fitim%2B%7C%2BEmre%2BAky%C3%BCz&t=89&ask_summarization=1"}],"linkTemplate":"/video/preview/12872940642157707889?parent-reqid=1752033050024221-2602925977422066606-balancer-l7leveler-kubr-yp-sas-118-BAL&text=Excel%2BE%C4%9Fitim%2B%7C%2BEmre%2BAky%C3%BCz&t=%%timestamp%%&ask_summarization=1"},"isAdultDoc":false,"relatedParams":{"text":"Excel'de İki Koşula Göre Düşeyara Formülü Kullanımı | Çaprazara","related_orig_text":"Excel+Eğitim+|+Emre+Akyüz","related_porno":false,"related_short":true,"related_less_3m_off":true,"client":"d2d","no_cnt":1,"related_src":"serp","related":"{\"porno\":false,\"vfp\":1,\"orig_text\":\"Excel+Eğitim+|+Emre+Akyüz\",\"url\":\"http:\\/\\/www.youtube.com\\/watch?v=ROpRdkMOfxc\",\"src\":\"serp\",\"rvb\":\"EhYKFDEyODcyOTQwNjQyMTU3NzA3ODg5GhYKFDEyODcyOTQwNjQyMTU3NzA3ODg5WhQxMjg3Mjk0MDY0MjE1NzcwNzg4OWqxDBIBMBgAIkQaMAAKKWhob3pwd3JraXBtb3lvdmhoVUN0cGthSjQwVkpLWW5iWFRVSHpfM1l3EgIAESoQwg8PGg8_E4MBggQkAYAEKyqLARABGniBCPD99gT7APf28g8ICPwCEPL5AfYA_wAF9xcCAgT-APIACfv7AAAA7AkH-AYAAAD6BvD7A_4AABv4AQjxAAAAEwn3_fYAAAD9BfDw_wEAAP0T8AAD_wAAFAQB_f8AAAAXEwj5_v8AAQUJBAQAAAAA9u7v_AAAAAAgAC3028Y7OBNACUhOUAIqhAIQABrwAX9CKP_237MElC0P___DDQGdvhr_ESb4AK4xEgHEIOYBws_9AR7l1ACSFasBpe8CAPv2u_4e8O4BH-z5_hnpGgDe4NgBIgUXAPwx5QERJPv9GxVA__66GAA12An_Q_75_0bII_3C4RD9rfe8AWP4OQAX7QL_H_AtAwH94v6yEg8A4p_s-y2_6AYgl977IQ8i-xn-FQo-OSn--Ob8Ay_83QPoAPT49vLKAiAoCgcpEO8D2hASDEQK-_cdLC7-3g8ZBu4--AA4c-4TJBMvAxm8-_DbF-sLBgH7ARca6hjUH-b2_hUO8cJM8P4hFRjyxPUE5iAALSUj3zo4E0AJSGFQAirPBxAAGsAHY0Pvvg_Bp7zTgIM7o1M8vfTIG7zrTTG84OLXvHi0EDzYkwa7iEYnPgnEazwNhCk9OGmKvtEMPTztrn08OxlsPq4M6jyCjCU8dckovtpUnT2TkKM8R48Pvm2kkTxoOMo8NhxbPdow1LwMtNa8EjFVPrzeZz2eUcS8x1YEvNBk370Rhfu8kT_9vA1rjzzsvRi9G8lUvJ_xM7y5cB48bM_MPUI6H7x3gVQ7KBkvvaxgCr2F5p-8qUs2vtRWtrzV5I484UyCvBtMQz38R1A97WaGPBgzkz379yq8qcSQPRFIkzzHRLE7lXT_upTZRbscjyO9iIdNu35MEL3_pkE8qMghvgJ8HD3o6W0899a2Parw1DloVwQ78tHivASa_rwdeRw8MVuCvW5HXby1qoA8AUCEPflf-DxRNA285ww7vR_kqzzQptk61V-KPWswiD1v4po808JgParkLTuct5y7uF-pvV2H6jxjY7k8yD0EPIYTYj1pnm08u9ToPdV5VDycpfc5Ojs-PRjtEb0RInC7uk4TPpYGvjw8ISa70omEO_dGA726gU06GTQZPRQAKL3y45a7V1gVPYtUeL2SEN27m9yUPa2F2T35xqU66DI1PkF9UD0tVbO6tDOWPC7Ezzxft2O8LX2jvdmHJj1eqYC71D38vNgtIr1-y1G5uNIGPQhW1b0-uhK6YYIEPfql9Dwg-6y7HLjevB4bnL1u-HS5BeoDPbZHD70dhM670vGyvSeoPLy36p06Z1uCPc5LCj0q2GG5zBI4PU95dLyWpB06aeZkvZ27-jkYVlO5rm7rvKbwID0Llp65LKSXvJ24_L3o_Vm47fpAPZlpdr3nY_A4Bz7rvA9YQ715vQK6OkrUPArFEb168wY7EvVCvSIY5714Guo3N1OhvLOvFTn9MjU5Fwd8PUJ2Hr6jYIw36iq4PHXkBTpgRFO4Vwn2vVMPLLzhDg06D3davS1G-DxcHBY4ja73vMDJy72hpYE52th2PTiaJ7tLWQ64hA2_PSsW3z3zDaK3F2iCvVKruTxluZa4sEKQvUwAmb0hZWO42cuLvToin7wBl0A46hAOvZqkx7vA2W04gNQGPiwr7b0ILMA5QXF2Pd40Qj1fnKK27CwfvWvJVD1buaA42-GKPafEPzzRKxE5yzg6OypcCj3rsIM31TuBPO89h73Nk783cX-0PdekOz3kJ1q4P47GPSveCL6HIrS4iITPPWuySz2Jt4U4KEKPPJsbeLy5NL-4K6advVjywrzwqKW3uEuRvH7vJbxpk5I3IAA4E0AJSG1QASpzEAAaYBzxADsVKeTgF_nf_wwxM9j00OA64hv_QrMAokTYHww-w-nuBAAc9CkQpAAAACT62BzMAPB07fz_9NsxNMzQ0P7ofyX-V7i9BRAjui8KPu6CC-JHNgDbFsb-I83u__cXyyAALSw6FDs4E0AJSG9QAjAJOAFKAGAAaAA,\"}","related_url":"http://www.youtube.com/watch?v=ROpRdkMOfxc","parent-reqid":"1752033050024221-2602925977422066606-balancer-l7leveler-kubr-yp-sas-118-BAL","related_vfp":1,"relatedVideo":"yes"},"cwidth":1920,"cheight":1080,"cratio":1.77777,"dups":["12872940642157707889"],"episode":0,"season":0,"isEmbedOnly":false,"greenHost":"YouTube","hasTranslation":false,"contentTypeId":null}},"dups":{"12872940642157707889":{"videoId":"12872940642157707889","title":"Excel'de İki Koşula Göre Düşeyara Formülü Kullanımı | Çaprazara","cleanTitle":"Excel'de İki Koşula Göre Düşeyara Formülü Kullanımı | Çaprazara","host":{"title":"YouTube","href":"http://www.youtube.com/live/ROpRdkMOfxc","playerUri":"\u003ciframe src=\"//www.youtube.com/embed/ROpRdkMOfxc?enablejsapi=1&wmode=opaque\" frameborder=\"0\" scrolling=\"no\" allowfullscreen=\"1\" allow=\"autoplay; fullscreen; accelerometer; gyroscope; picture-in-picture\" aria-label=\"Video\">\u003c/iframe>","playerId":"youtube","providerName":"youtube.com","sourceHost":"www.youtube.com","name":"youtube.com","secondPart":{"type":"CHANNEL","id":"d3d3LnlvdXR1YmUuY29tO1VDdHBrYUo0MFZKS1luYlhUVUh6XzNZdw==","name":"Emre Akyüz","isVerified":false,"subscribersCount":0,"url":"/video/search?channelId=d3d3LnlvdXR1YmUuY29tO1VDdHBrYUo0MFZKS1luYlhUVUh6XzNZdw%3D%3D&how=tm&text=Emre+Aky%C3%BCz","origUrl":"http://www.youtube.com/@emreakyuuz","a11yText":"Emre Akyüz. "},"faviconUrl":"//favicon.yandex.net/favicon/v2/http%3A%2F%2Fyoutube.com?color=255%2C255%2C255%2C0&size=32&stub=1"},"duration":{"value":131,"text":"2:11","a11yText":"Süre 2 dakika 11 saniye"},"views":{"text":"30,3bin","shouldShowInSnippet":true,"a11yText":"30,3 bin izleme"},"date":"22 kas 2023","modifyTime":1700611200000,"isExternal":false,"shouldShowQuasar":false,"player":{"embedUrl":"https://www.youtube.com/embed/ROpRdkMOfxc?autoplay=1&enablejsapi=1&wmode=opaque","playerId":"youtube","videoUrl":"http://www.youtube.com/watch?v=ROpRdkMOfxc","reqid":"1752033050024221-2602925977422066606-balancer-l7leveler-kubr-yp-sas-118-BAL","duration":131},"parentClipId":"12872940642157707889","href":"/preview/12872940642157707889?parent-reqid=1752033050024221-2602925977422066606-balancer-l7leveler-kubr-yp-sas-118-BAL&text=Excel%2BE%C4%9Fitim%2B%7C%2BEmre%2BAky%C3%BCz","rawHref":"/video/preview/12872940642157707889?parent-reqid=1752033050024221-2602925977422066606-balancer-l7leveler-kubr-yp-sas-118-BAL&text=Excel%2BE%C4%9Fitim%2B%7C%2BEmre%2BAky%C3%BCz","isEmbedOnly":false}},"loadingStatus":"None"},"internal":{"videoId":"12872940642157707889","sandboxEventPrefix":"sandbox:","sandboxVersion":"0x37b97f62901","isHermione":false,"isEmbedded":false,"from":"yavideo","service":"ya-video","hbPeriod":30,"rknWarnHosts":[""],"table":"video_tech","nonce":"6029259774220666067118","errorList":[],"isAdultAdv":false,"isImportantCommonAdv":false,"shouldShowAdvId":false,"advConfig":{"under-player":{"regular":{"default":"R-I-48058-725","mail":"R-A-13411721-6"},"adult":{"default":"R-I-474674-114","mail":"R-A-13426421-6"}},"under-player-lite":{"regular":{"default":"R-I-48058-728"},"adult":{"default":"R-I-474674-103"}},"under-player-old":{"regular":{"default":"R-I-48058-725","mail":"R-A-13411721-6"},"adult":{"default":"R-I-474674-114","mail":"R-A-13426421-6"}},"video-list":{"regular":{"default":"R-I-48058-708","mail":"R-A-13411721-2"},"adult":{"default":"R-I-474674-101","mail":"R-A-13426421-2"}},"search-list":{"regular":{"default":"R-I-48058-715","mail":"R-A-13411721-3"},"adult":{"default":"R-I-474674-108","mail":"R-A-13426421-3"}},"search-grid-row":{"regular":{"default":"R-I-48058-718","mail":"R-A-13411721-4"},"adult":{"default":"R-I-474674-109","mail":"R-A-13426421-4"}},"search-grid-head":{"regular":{"default":"R-I-2120168-7"}},"search-list-right":{"regular":{"default":"R-I-8843654-1"}},"before-player-old":{"regular":{"default":"R-I-2120168-1"}},"before-player":{"regular":{"default":"R-I-2120168-1"}}},"shouldValidateSandbox":false,"isSSROnlyMastheadEnabled":true,"query":"Excel+Eğitim+|+Emre+Akyüz","queryUriEscaped":"Excel%2BE%C4%9Fitim%2B%7C%2BEmre%2BAky%C3%BCz","filterMode":1,"isUserChild":false},"playbackQueue":{"currentIndex":0,"items":[{"type":"VIDEO","videoId":"12872940642157707889","source":"serp","selectEvent":"click"}]},"related":{"items":[],"pages":[],"loadingStatus":"None","nextPageNum":0,"ncrnd":0},"playlist":{"items":{}}}}