İki Excel Listesindeki Verileri Birleştirme - Kolay Anlatim.
{"pages":{"search":{"query":"videoid:14331877731486731533","originalQuery":"","serpid":"1777079793875564-16103744211522117917-balancer-l7leveler-kubr-yp-vla-213-BAL","reqid":"1777079793875564-16103744211522117917-balancer-l7leveler-kubr-yp-vla-213-BAL","parentReqid":"","serpItems":[{"id":"14331877731486731533-0-0","type":"videoSnippet","props":{"videoId":"14331877731486731533"},"curPage":0},{"id":"R-I-113683-5-0-1","type":"direct","props":{"advRsyaActivateParams":{"pcodeParams":{"blockId":"","renderTo":"","pageNumber":1,"grab":"dHZpZGVvaWQ6MTQzMzE4Nzc3MzE0ODY3MzE1MzMK","statId":1,"lazyLoad":false,"extParams":{"reqid":"1777079793875564-16103744211522117917-balancer-l7leveler-kubr-yp-vla-213-BAL","ui":"desktop","yuid":"3833672641777079789"}}},"isAdult":false,"position":1,"placement":"empty"},"curPage":0},{"id":"R-I-113683-5-0-2","type":"direct","props":{"advRsyaActivateParams":{"pcodeParams":{"blockId":"","renderTo":"","pageNumber":2,"grab":"dHZpZGVvaWQ6MTQzMzE4Nzc3MzE0ODY3MzE1MzMK","statId":2,"lazyLoad":false,"extParams":{"reqid":"1777079793875564-16103744211522117917-balancer-l7leveler-kubr-yp-vla-213-BAL","ui":"desktop","yuid":"3833672641777079789"}}},"isAdult":false,"position":2,"placement":"empty"},"curPage":0},{"id":"R-I-113683-5-0-3","type":"direct","props":{"advRsyaActivateParams":{"pcodeParams":{"blockId":"","renderTo":"","pageNumber":3,"grab":"dHZpZGVvaWQ6MTQzMzE4Nzc3MzE0ODY3MzE1MzMK","statId":3,"lazyLoad":false,"extParams":{"reqid":"1777079793875564-16103744211522117917-balancer-l7leveler-kubr-yp-vla-213-BAL","ui":"desktop","yuid":"3833672641777079789"}}},"isAdult":false,"position":3,"placement":"empty"},"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,"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":"dHZpZGVvaWQ6MTQzMzE4Nzc3MzE0ODY3MzE1MzMK","lazyLoad":false,"extParams":{"reqid":"1777079793875564-16103744211522117917-balancer-l7leveler-kubr-yp-vla-213-BAL","ui":"desktop","yuid":"3833672641777079789"}}},"isAdult":false,"position":0,"placement":"search-list-right"},"curPage":0}],"isAdultQuery":false,"errorList":[],"layout":"list","retpath":"https%3A%2F%2Fyandex.com.tr%2Fvideo%2Fpreview%2F14331877731486731533","pages":[{"reqid":"1777079793875564-16103744211522117917-balancer-l7leveler-kubr-yp-vla-213-BAL","start":0,"end":4,"pageNumber":0,"isCounterSent":false}]},"main":{"_isInitial":true,"snippets":[],"serpFooter":{"linksGroups":[]},"isLoggedIn":false,"tags":[]}},"internal":{"nonce":"1037442115221179177213","expFlags":{"video_settings_toolbar_redesign":1,"velocity_delay_drawer":1,"video_feedback_in_d2d":1,"video_search_toggle_with_text":1,"video_viewer_show_placeholder":1,"velocity_disable_suspense":1,"video_viewer_desktop_smart_layout":1,"dark_theme_desktop":"cookie","video_viewer_check_sandbox_origin":1,"video_font_yandex_sans":1,"video_adv_new_show_rules":1,"video_adv_config_desktop":{"search-list":{"adult":{"default":"R-I-474674-135","mail":"R-A-13426421-23"},"regular":{"default":"R-I-48058-751","mail":"R-A-13411721-23"}},"search-grid-inplace":{"adult":{"default":"R-I-474674-126","mail":"R-A-13426421-16"},"regular":{"default":"R-I-48058-742","mail":"R-A-13411721-16"}}},"video_search_page_no_islands":1,"video_vh_player_js":0,"video_masthead_ratio":"180,4","video_viewer_related_fail_error_screen":1,"video_viewer_channel_link_mode":2,"int_tr":1,"mmui_extended_escape_scheme":"searchdata.clips.0.authorname","video_viewer_restore_mute_state":1,"tabs_order_version":"search,images,video,newstr,maps,translate,tr_ecom","spok":"id","video_suggest_use_serp":1,"video_search_grid_direct_repeat":6,"init_meta":{"enable-yabs-distr":1,"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,"bg-bert-video":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_viewer_comments_auth_popup":1,"video_depot_viewer_masthead_ssr_only":1,"video_kebab_advanced_actions":1,"video_search_grid_enable":0,"video_viewer_desktop_fix_d2d_scroll":1,"video_depot_viewer_legacy_counters":1,"video_search_grid_direct_start":3,"video_adv_new_show_rules_docs_count":1,"video_related_suggest_enable":1,"video_redirect_plug":2,"video_adv_grid_inplace":1,"dark_theme_desktop_default_pref":"system","video_search_toggle_enable":1,"velocity_split_hydration":4,"video_duration_counter_new_format":1,"video_force_grid_on_premordie":1,"int_online_summarization_video_snippet":1,"video_morda_header_nav":1,"video_nohost_full_filter":0,"video_baobab_blockstat":1,"video_nohost_youtube_filter":0,"video_viewer_host_link_mode":1,"video_comments_smart_nonstop":1},"slots":["1519497,0,80;1513918,0,81;1547188,0,12;1545280,0,58;1546029,0,24;1525905,0,80;1544451,0,21;1312966,0,64;1542919,0,56;1541043,0,76;6160,0,40;1538015,0,76;1544291,0,83;182558,0,92;127804,0,31;1541573,0,68;1519857,0,37;1538083,0,80;1550377,0,4;1543816,0,59;1544483,0,95;1537353,0,93;1349038,0,97;1524212,0,98;1534925,0,45;260562,0,18;1548306,0,50;90496,0,5;1549696,0,22;1548121,0,39;1541610,0,25;66190,0,77;1544108,0,21;1396445,0,77;19997,0,77;1543800,0,94;151171,0,82;1281084,0,86;1534488,0,10;287509,0,32;786154,0,34;1538600,0,97;1541137,0,87;912281,0,83;1545080,0,61"],"isYandexNet":false,"platform":"desktop","isEnLogo":true,"retpath":"https%3A%2F%2Fyandex.com.tr%2Fvideo%2Fpreview%2F14331877731486731533","mordaUrl":"//yandex.com.tr/","videoSearchUrl":"https://yandex.com.tr/video/search?text=%C4%B0ki+Excel+Listesindeki+Verileri+Birle%C5%9Ftirme+-+Kolay+Anlatim.","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":"1777079793875564-16103744211522117917-balancer-l7leveler-kubr-yp-vla-213-BAL","backUrl":"//ya.ru","url":"https://yandex.com.tr/video/preview/14331877731486731533?","isIntegrationTest":false,"isEndToEndTest":false,"shouldDropLogs":false,"seo":{"title":"İki Excel Listesindeki Verileri Birleştirme - Kolay Anlatim. - Yandex Video aramada çevrimiçi izle","description":"Technological Solution Videos. · 5:49 · 20 kas 2021","keywords":"","shareTitle":""},"isEmbedded":false,"isPumpkin":false,"sessionCsrfToken":"yb42886f7670cd475f2ec0889ad0548d3","reportFeedbackBaseProps":{"initEmail":"","metaFields":{"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","userTestids":"1519497,1513918,1547188,1545280,1546029,1525905,1544451,1312966,1542919,1541043,6160,1538015,1544291,182558,127804,1541573,1519857,1538083,1550377,1543816,1544483,1537353,1349038,1524212,1534925,260562,1548306,90496,1549696,1548121,1541610,66190,1544108,1396445,19997,1543800,151171,1281084,1534488,287509,786154,1538600,1541137,912281,1545080","queryText":"","reqid":"1777079793875564-16103744211522117917-balancer-l7leveler-kubr-yp-vla-213-BAL","userRegionName":"","userRegionId":"id() {\n return this._region.id;\n }","yandexuid":"3833672641777079789","uid":"0","isChildAccount":false}},"userTestids":"191768,238743,246500,253288,265553,270072,277807,274239,294077,278842,331010,338398,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,1060131,1071879,1078818,1077703,1116602,1045814,1131637,1144233,1151726,1156933,1174275,1173000,1167408,1202006,1194718,1221235,1228280,1239596,1226860,1246754,1276447,1289213,1316370,1313283,1321224,1300570,1320679,1352408,1342688,1344637,1341968,1345362,1343279,1367583,1348424,1382036,1391511,1384451,1402882,1407422,1417605,1424780,1429092,1438908,1444206,1449283,1452713,1457995,1459585,1461130,1492788,1495633,1511916,1514845,1535081,1540074,1545808,1543051,1299604","regionId":20815,"isYaRu":false,"shouldUnmountSearchPageInViewer":false,"videoGlobalContext":{"platform":"desktop","isPumpkin":false,"language":"tr","user_time":{"epoch":"1777079793","tz":"America/Louisville","to_iso":"2026-04-24T21:16:33-0400","__is_plain":1},"isHermione":false,"shouldStubImages":true,"enableVideoPreviewInHermione":false,"reqid":"1777079793875564-16103744211522117917-balancer-l7leveler-kubr-yp-vla-213-BAL","isEmbedded":false,"shouldShowMainPageButtonInViewer":false,"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":"1519497,1513918,1547188,1545280,1546029,1525905,1544451,1312966,1542919,1541043,6160,1538015,1544291,182558,127804,1541573,1519857,1538083,1550377,1543816,1544483,1537353,1349038,1524212,1534925,260562,1548306,90496,1549696,1548121,1541610,66190,1544108,1396445,19997,1543800,151171,1281084,1534488,287509,786154,1538600,1541137,912281,1545080","queryText":"","reqid":"1777079793875564-16103744211522117917-balancer-l7leveler-kubr-yp-vla-213-BAL","userRegionName":"","userRegionId":"id() {\n return this._region.id;\n }","yandexuid":"3833672641777079789","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":"1037442115221179177213","disableDoc2DocHostLink":false,"shouldHideChannelLink":false,"disableChannelLink":false,"userConnectionRtt":168,"animated":false,"isDoc2DocScrollFix":true,"smartDesktopLayout":true,"enableVIImprovements":false,"enableLazyPoster":false,"isAdvDisabled":false,"isVideoTranslationSupported":false,"isSummaryDisabled":false,"isSummaryOnlineEnabled":true,"shouldRenderBroSummaryApiContainer":false,"shouldDropLogs":false,"shouldUseBeacon":false,"hasAdBlock":false,"rknWarnHosts":[""],"postInstreamScreenDuration":2000,"minVideoDurationForInstream":120,"isInstreamEnabledInTesting":false,"wildcard":false,"disableEarlyEventsUnsubscribe":false,"showDebugRelatedURL":false,"shouldUseBetaErrorLogging":false,"shouldShowMetaUnderPlayer":false,"isVideoViewerMetaTitleHidden":false,"headerNoFavicon":false,"headerBranded":false,"shouldCensorSensitiveContent":false,"shouldCensorShockContent":false,"isAdvUnderPlayerTransparent":false,"isDoc2DocGridLayoutEnabled":false,"isWatchingProgressInDoc2DocEnabled":false,"detailsRedesignEnabled":false,"detailsRedesignV2Enabled":false,"detailsRedesignV3Enabled":false,"isD2DEmptyLoadFixDisabled":false,"isRoundedPlayerEnabled":false,"isSettingsToolbarRedesign":true,"isDoc2DocEmptyRetryEnabled":false,"isTouchAdvWithBackdrop":false,"isDoc2DocErrorScreenEnabled":true,"isDoc2DocFeedbackKebabEnabled":true,"isCommentsEnabled":false,"isReactionsEnabled":false,"isVideoReactionsEnabled":false,"isCommentsCountOnSnippetsEnabled":false,"isCommentsSmartNonStopEnabled":true,"isCommentsOnboardingEnabledInTesting":false,"commentsOnboardingTextVariant":null,"isVideoMainButtonInitiallyCollapsed":false,"isAdvUnderPlayerWithInnerPadding":false,"isKebabAdvancedActionsEnabled":true,"isKebabOnTouchVideoSearchEnabled":false,"isAdvVideoListLikeUnderPlayer":false,"isSummaryInMetaButtons":false,"isSummaryInMetaButtonsDesktop":false,"isMetaCommentsButtonEnabled":false,"isCommentsAuthPopup":true,"preventAdvHideOnEmpty":false,"isPlayerChangeCounterEnabled":false,"isSmallTitle":false,"shouldRestoreMuteState":true,"isAdvUnderPlayerWithSlider":false,"isAdvUnderPlayerCommentsAligned":false,"isSerialNavigatorDisabled":false,"isAdvInVideoListWithInnerPadding":false,"isEarlyAdvRenderEnabled":false},"shouldShowAdvId":false,"isAdultQuery":false,"isSensitivePage":false,"showSensitive":false,"showShock":false,"shouldReplaceHref":false},"user":{"tld":"com.tr","isEuDomain":false,"login":"","passportId":"","isLoggedIn":false,"locationName":"Columbus","isFamily":false,"yandexuid":"3833672641777079789","ugcCsrfToken":"","family":1,"isChild":false},"config":{"skinMode":"system","skin":"light","version":"releases-frontend-video-v1.1813.0__843c857f68fd1f2adde186579928288b90fa79c4","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":{"adult":{"default":"R-I-474674-135","mail":"R-A-13426421-23"},"regular":{"default":"R-I-48058-751","mail":"R-A-13411721-23"}},"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"}},"search-grid-inplace":{"adult":{"default":"R-I-474674-126","mail":"R-A-13426421-16"},"regular":{"default":"R-I-48058-742","mail":"R-A-13411721-16"}}},"isSkinInitedOnClient":false},"counters":{"params":{"useBeacon":false,"clickHost":"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","request_entry_completed":"2021","serp":"471","page":"143","loaded":"1007"}},"clips":{"items":{"14331877731486731533":{"videoId":"14331877731486731533","docid":"34-4-13-Z3BCF264F677B71A3","description":"I explained the finer points of the Vlookup Formula towards the end.","preview":{"posterSrc":"//avatars.mds.yandex.net/get-vthumb/4079336/769486145cad9aab1d03f1508d62cd5d/564x318_1","videoSrc":"https://video-preview.s3.yandex.net/R1ibNAIAAAA.mp4","videoType":"video/mp4"},"target":"_self","position":"0","reqid":"1777079793875564-16103744211522117917-balancer-l7leveler-kubr-yp-vla-213-BAL","summary":{"isFull":true,"fullTextUrl":"/video/result?ask_summarization=1&numdoc=1&noreask=1&nomisspell=1&parent-reqid=1777079793875564-16103744211522117917-balancer-l7leveler-kubr-yp-vla-213-BAL&text=videoid:14331877731486731533","teaser":[{"list":{"type":"unordered","items":["Bu video, bir eğitim içeriği olup, izleyicilere Excel'de iki liste arasındaki ortak alanları nasıl bulabileceklerini göstermektedir.","Video, iki farklı liste arasındaki ortak verileri otomatik olarak bulma yöntemini adım adım anlatmaktadır. Öncelikle \"Düşey Ara\" formülünün nasıl kullanılacağı gösterilmekte, ardından öğrenci numarası ve TC kimlik numarası gibi farklı arama senaryoları üzerinden örnekler verilmektedir. Özellikle \"Düşey Ara\" formülünün doğru kullanımı, aranan değerin sağındaki değerleri getirme ve sütun indis sayısının nasıl hesaplanacağı gibi önemli detaylar vurgulanmaktadır."]},"endTime":349,"title":"Excel'de İki Liste Arasındaki Ortak Alanları Bulma","beginTime":0}],"fullResult":[{"index":0,"title":"İki Liste Arasındaki Ortak Alanları Bulma","list":{"type":"unordered","items":["Video, iki liste arasındaki ortak alanları nasıl getirebileceğimizi göstermektedir.","Birinci listede tüm veriler bulunurken, ikinci listede aynı kişilerin bazı verileri eksik olduğu bir liste bulunmaktadır.","Az sayıda veri için tek tek arama yapılabilir ancak yüzlerce veya binlerce satır olduğunda bunu otomatik yapmak gerekmektedir."]},"beginTime":8,"endTime":66,"href":"/video/preview/14331877731486731533?parent-reqid=1777079793875564-16103744211522117917-balancer-l7leveler-kubr-yp-vla-213-BAL&t=8&ask_summarization=1"},{"index":1,"title":"DÜŞEYARA Formülünü Kullanma","list":{"type":"unordered","items":["İki liste arasındaki ortak alanları bulmak için DÜŞEYARA formülü kullanılır.","Formülde önce aranan değer (örneğin öğrenci numarası) seçilir.","İkinci adımda arama yapılacak tablo dizisi seçilir.","Üçüncü adımda istenen verinin sütun indis numarası girilir.","Dördüncü adımda tam eşleşme için 0 değeri kullanılır."]},"beginTime":66,"endTime":170,"href":"/video/preview/14331877731486731533?parent-reqid=1777079793875564-16103744211522117917-balancer-l7leveler-kubr-yp-vla-213-BAL&t=66&ask_summarization=1"},{"index":2,"title":"Formülün Uygulanması ve Detayları","list":{"type":"unordered","items":["Formül tamamlandıktan sonra Enter'a basıldığında, aranan değerin karşılığı otomatik olarak getirilir.","Formülü aşağı doğru sürükleyerek tüm satırlar için otomatik olarak değerler getirilebilir.","DÜŞEYARA formülünde önemli bir detay, aranan değerin sağındaki değerlerin sadece getirilebileceği yönündedir.","Aranan değer sol sütunda ise sağdaki tüm sütunlardaki veriler getirilebilir, ancak aranan değer ortada veya sağda ise sadece o değerin sağındaki veriler getirilebilir."]},"beginTime":170,"endTime":346,"href":"/video/preview/14331877731486731533?parent-reqid=1777079793875564-16103744211522117917-balancer-l7leveler-kubr-yp-vla-213-BAL&t=170&ask_summarization=1"}],"linkTemplate":"/video/preview/14331877731486731533?parent-reqid=1777079793875564-16103744211522117917-balancer-l7leveler-kubr-yp-vla-213-BAL&t=%%timestamp%%&ask_summarization=1"},"isAdultDoc":false,"relatedParams":{"text":"İki Excel Listesindeki Verileri Birleştirme - Kolay Anlatim.","related_porno":false,"related_short":true,"related_less_3m_off":true,"client":"d2d","no_cnt":1,"related_src":"serp","related":"{\"porno\":false,\"vfp\":1,\"url\":\"http:\\/\\/www.youtube.com\\/watch?v=y2RbdgGeWlI\",\"src\":\"serp\",\"rvb\":\"EhYKFDE0MzMxODc3NzMxNDg2NzMxNTMzGhYKFDE0MzMxODc3NzMxNDg2NzMxNTMzWhQxNDMzMTg3NzczMTQ4NjczMTUzM2qIFxIBMBgAIkUaMQAKKmhobHFpc3Fua2tyaGZrZGJoaFVDS3NYd0VQeElrRU10blA0WlJvMGlHdxICABIqEMIPDxoPPxPdAoIEJAGABCsqiwEQARp4gfgMBP8C_gD4_vkEDgX9AQgDCgr3__8A6QUS-gX_AQAO7wz9_wAAAO4ABAQAAAAAFO_0Cfz_AgERAff8BAAAABf4AA34AAAA8Qjz-P8BAAD8DPb3A_8AAA4JAQUAAAAABhUGAv4AAAAOCQL7AQAAAALo9QMBAAAAIAAtMJjKOzgTQAlITlACKoQCEAAa8AFpMkP89-G5A5lHHQAUzdcA1NoA_wwm4P-UOQMAxNTmAKvoDgAgEdj_x-vQAIHh3gPlBun-BjG4_zf77f75vBoA483wASDk8wIjXu7-CgoHANkCSv5KxgD_IPIfAQMd4gQ1qP79Avn1CNn03QYk4xwD_QsWAu8hKgIP2PcCviX3_vTL7AIVvCgF8azc-vIEBfn0_BcNU0D1BAzO1_4Hz_oM3OvSAAD0BfNA-dsDCTTxBOD5KBIh8fbu-igX9tw87_zRPO39Og_zBTkUAQAA3CH_9-vwDA73CvNYK-wMyCIX_AIEEQboAQH0NQIM4-zf7_0gAC29-fA6OBNACUhhUAIqzwcQABrABzkr-r4ZAwy8Nu-0usldXz2wQmC9eMnJvA4s5z3H5cu7ekYsvSaWuj1DHwy9XiqGPfaWYr4FeIE8eT8NvP7Viz4gxJ88hqkxO-_mmb1xDm09-ggBPUePD75tpJE8aDjKPHkTLjtgGu27ffUnvQqBLD45R_g8Jey2vBHxYL0jBQC9HTOWO5E__bwNa4887L0YvRMqOL2k8VU9M40mvPhEaD29w2283tu-O0HuR70pmGy9oOzcvKlLNr7UVra81eSOPOFMgrwbTEM9_EdQPS8_w7svsYk7coKbvB2Eij2W0Sg9HE7PPOqS0b3csg297dPxvIYbsDzkXBS9qACYPC-G8r10kHy8_SGsPOvaKL3Pqb-8aIx7vBlvED32VYM9Rq6APDgskr0pa6W8wO5PvNeK1j1wbfY7VIupuujuhLzHJXM96a4tOuQ7xjuM9wM-vyzIPA5sMD2g8ti6_yUGPFFwnL10A4q9s1-3PCxsPLy6oek9HDkYOy2PmjyGe8A8PRKrO_r8pDqX2ly9RtEBPNbBxj0jlAi8daBaOxamTz1QQyq9fywGO-nJZj2BsDM9nHU-O3FBkTuoV2W9jRHkO47M4z2Vgu49Xb3tunxhEj6j4G49302aO_ggH72DjBs9vPpCvChyUr10MDE9Pqn-uzJBKL0prJm9T4dCOynEqzsn66G9bAZ6O5t-vz0Ud_w89IgrOo0jezxV7zq8sJFBO3DqA700uR29WWaVuzm4xL2Qbh897xIDO9ablz3bzDc9Tbg6OSayRT2jzpw8LiVDOeFi4Lw4zYy8BmWluKkiprx1YkW8Q9HNuDXhKDw1lZq9qORHObmnmz2i3mK93IDMOCCYkz02gw274hrzOWKqzzxWMOi6qSNcOKdHybybE8W9AwKzOFWibDwiqNq9y4FTt_nzwj37XO29BrmDOEy8CL26UJG5MhlBuWa2lb0aVkw9N02GOcn3Vr2_FSS9ENvRuMK0ubxMip-9BmB2ODq6gLzhsq-7WTFfOHqOSD3K5E89XFOlOGoFXL1WvKw8xZrwtwdnlr12z_C8hj7Lt9_KTb2ynOS9DYO3OHqlrLvR9RM9h47gOLVwNDxhqgm-LbtGt4BlJTyC0sY96iyoOI3CBL3MVb07Rj9mt-THsbre-a896-6puBHmkb2w73k9IBGMuA2fujvPXFG9oUWutgVp5j0z6F88Ng8uOGsKmT1QzJW8Rxylt-NrDz6FTh49F3SuOHANpjvnvkE8Mc3SuAoGQb38JI29TLnoNn56Ij1pL2y7pVeeNiAAOBNACUhtUAEqcxAAGmAf6gBE_wbj3yccBu3rDy_t8r_dD-ZQ_y_HANAivdz5E8ns2D8AEugRB6YAAAATFgEswQD7d5z4A_nGICyBueL5_HENBi6v5f_gBvAiGScT3wn0LDsA9Qmk_Cn6sxoUF-IgAC2_Jxw7OBNACUhvUAIqrwYQDBqgBgAASMIAADxCAACAvwAAREIAAFDBAAAwwQAAvEIAAMBAAAAIwgAAiEEAAAAAAABcwgAAeMIAABjCAAAMQgAArsIAAAjCAABYwgAAgMAAAADBAABgQQAAHMIAAADBAAC4QQAAQMEAADBBAAAcwgAAAMIAAJBCAAAQwQAAuMEAAIDBAAC2wgAAuEIAAJjBAAAEwgAAWMIAAFBCAACAPwAAaEIAAEDBAACYQQAAkMEAAIDBAAAMwgAApMIAAMDBAABQwQAAAEEAAOhBAAAMwgAAIMEAACDBAAAAQAAAKEIAAOBAAACOwgAAAEAAAGBBAADwQQAAAEIAAEBAAABwwgAAxsIAAAxCAABIwgAAYEEAAKDBAACIwgAAEMIAAKJCAABwQQAA4EEAAKjBAAAIQgAAEMIAAHBBAACAwQAAgEEAALBBAABowgAAikIAAIBAAADIQQAA2MEAAEDAAAAoQgAAbEIAAGRCAADoQQAA0EEAAJhBAACCwgAAHMIAAEzCAAA0wgAAIEEAAKBAAADuQgAAwEAAAGDBAAAQQQAAREIAAABCAAAQwgAAoEAAAJjBAAAAQQAAwMAAADxCAACgQQAAAEEAACDCAACOQgAA0EEAAIjBAADAQAAAKMIAAMBBAAAgwQAA4MAAAMjBAADAQAAAksIAAMDAAABIQgAAhEIAADTCAAB4wgAAgEAAAEjCAAAEQgAAYMEAAOBBAAAwQQAA0EEAAGhCAACAwAAAGMIAACjCAABgQQAAIMIAAGBBAABwwQAAXEIAAMBAAABQwgAAmEEAAFhCAACWQgAAXMIAAJBBAADgQQAAkMIAAMDBAAAAwgAAFMIAADjCAAAwwQAA-EEAAMBAAACWQgAAqMEAABzCAAAQwQAAAEIAAIA_AABwQgAAMEIAABDBAADAwAAAjEIAAEBAAAA0wgAA6MEAAIDAAADgwAAAAMEAACxCAACaQgAARMIAAGBBAADYwQAAJEIAACRCAACQwQAAjsIAABDBAAAUQgAAHEIAABxCAAAAwAAAoMEAADTCAABQQQAAQEEAAIjCAACwwQAAQEAAAKDBIAA4E0AJSHVQASqPAhAAGoACAACqvgAAUD0AADw-AAAEvgAAEL0AAGQ-AAB8PgAAO78AAKi9AADYPQAAmL0AACy-AACovQAAqj4AADA9AADWvgAAEL0AAKi9AAC6PgAAAz8AAGs_AACoPQAAiL0AAGQ-AAD4vQAAPL4AAKY-AADGvgAAoj4AAJ4-AABAPAAAmD0AAKA8AAC4vQAARD4AALK-AACgvAAAoDwAAEA8AACovQAANL4AAFQ-AAAkPgAAor4AAPi9AAD4vQAAgLsAAJi9AABEvgAAdL4AAHA9AACAOwAALD4AAJa-AACIvQAAgLsAAH8_AADovQAAHD4AADA9AACAuwAAPD4AAHA9AAAsPiAAOBNACUh8UAEqjwIQARqAAgAAqL0AAEQ-AACIPQAAMb8AAKi9AAAcvgAAHL4AAHC9AAC4vQAAUD0AAIa-AADIvQAAoLwAALK-AADoPQAA6L0AAAy-AABDPwAAEL0AAIY-AAAMvgAApr4AAOA8AADIvQAAqL0AAFC9AACIvQAAML0AAPg9AABQPQAAoLwAAOg9AAAcvgAAEL0AABC9AACKPgAADD4AAHw-AAA8vgAAiL0AAKC8AADgvAAAFL4AAAQ-AACAuwAAMD0AAH-_AAAcvgAAVL4AAMg9AAAcPgAARL4AAJo-AACYPQAAVL4AAKC8AAAQPQAA2D0AAHy-AACYvQAA6D0AAGw-AAD4PQAAdL4gADgTQAlIfFABMAk4AUoAYABoAA,,\"}","related_url":"http://www.youtube.com/watch?v=y2RbdgGeWlI","parent-reqid":"1777079793875564-16103744211522117917-balancer-l7leveler-kubr-yp-vla-213-BAL","related_vfp":1,"relatedVideo":"yes"},"cwidth":1920,"cheight":1080,"cratio":1.77777,"dups":["14331877731486731533"],"episode":0,"season":0,"isEmbedOnly":false,"greenHost":"YouTube","hasTranslation":true,"contentTypeId":null,"censored":false,"censoredShock":false,"isShockDoc":false,"videoContentId":"1614006854"}},"dups":{"14331877731486731533":{"videoId":"14331877731486731533","title":"İki Excel Listesindeki Verileri Birleştirme - Kolay Anlatim.","cleanTitle":"İki Excel Listesindeki Verileri Birleştirme - Kolay Anlatim.","host":{"title":"YouTube","href":"http://www.youtube.com/live/y2RbdgGeWlI","playerUri":"\u003ciframe src=\"//www.youtube.com/embed/y2RbdgGeWlI?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":"d3d3LnlvdXR1YmUuY29tO1VDS3NYd0VQeElrRU10blA0WlJvMGlHdw==","name":"Technological Solution Videos.","isVerified":false,"subscribersCount":0,"url":"/video/search?text=Technological+Solution+Videos.","origUrl":"http://www.youtube.com/c/Teknolojik%C3%87%C3%B6z%C3%BCmVideolar%C4%B1","a11yText":"Technological Solution Videos.. "},"faviconUrl":"//favicon.yandex.net/favicon/v2/http%3A%2F%2Fyoutube.com?color=255%2C255%2C255%2C0&size=32&stub=1"},"duration":{"value":349,"text":"5:49","a11yText":"Süre 5 dakika 49 saniye","shortText":"5 dk."},"views":{"text":"39,1bin","a11yText":"39,1 bin izleme"},"date":"20 kas 2021","modifyTime":1637366400000,"isExternal":false,"player":{"embedUrl":"https://www.youtube.com/embed/y2RbdgGeWlI?autoplay=1&enablejsapi=1&wmode=opaque","playerId":"youtube","videoUrl":"http://www.youtube.com/watch?v=y2RbdgGeWlI","reqid":"1777079793875564-16103744211522117917-balancer-l7leveler-kubr-yp-vla-213-BAL","duration":349},"parentClipId":"14331877731486731533","href":"/preview/14331877731486731533?parent-reqid=1777079793875564-16103744211522117917-balancer-l7leveler-kubr-yp-vla-213-BAL","rawHref":"/video/preview/14331877731486731533?parent-reqid=1777079793875564-16103744211522117917-balancer-l7leveler-kubr-yp-vla-213-BAL","isEmbedOnly":false,"shouldPlayInstreamPreroll":false,"commentsDisabled":false}}},"viewer":{"_isInitial":false,"clips":{"items":{"14331877731486731533":{"videoId":"14331877731486731533","docid":"34-4-13-Z3BCF264F677B71A3","description":"I explained the finer points of the Vlookup Formula towards the end.","preview":{"posterSrc":"//avatars.mds.yandex.net/get-vthumb/4079336/769486145cad9aab1d03f1508d62cd5d/564x318_1","videoSrc":"https://video-preview.s3.yandex.net/R1ibNAIAAAA.mp4","videoType":"video/mp4"},"target":"_self","position":"0","reqid":"1777079793875564-16103744211522117917-balancer-l7leveler-kubr-yp-vla-213-BAL","summary":{"isFull":true,"fullTextUrl":"/video/result?ask_summarization=1&numdoc=1&noreask=1&nomisspell=1&parent-reqid=1777079793875564-16103744211522117917-balancer-l7leveler-kubr-yp-vla-213-BAL&text=videoid:14331877731486731533","teaser":[{"list":{"type":"unordered","items":["Bu video, bir eğitim içeriği olup, izleyicilere Excel'de iki liste arasındaki ortak alanları nasıl bulabileceklerini göstermektedir.","Video, iki farklı liste arasındaki ortak verileri otomatik olarak bulma yöntemini adım adım anlatmaktadır. Öncelikle \"Düşey Ara\" formülünün nasıl kullanılacağı gösterilmekte, ardından öğrenci numarası ve TC kimlik numarası gibi farklı arama senaryoları üzerinden örnekler verilmektedir. Özellikle \"Düşey Ara\" formülünün doğru kullanımı, aranan değerin sağındaki değerleri getirme ve sütun indis sayısının nasıl hesaplanacağı gibi önemli detaylar vurgulanmaktadır."]},"endTime":349,"title":"Excel'de İki Liste Arasındaki Ortak Alanları Bulma","beginTime":0}],"fullResult":[{"index":0,"title":"İki Liste Arasındaki Ortak Alanları Bulma","list":{"type":"unordered","items":["Video, iki liste arasındaki ortak alanları nasıl getirebileceğimizi göstermektedir.","Birinci listede tüm veriler bulunurken, ikinci listede aynı kişilerin bazı verileri eksik olduğu bir liste bulunmaktadır.","Az sayıda veri için tek tek arama yapılabilir ancak yüzlerce veya binlerce satır olduğunda bunu otomatik yapmak gerekmektedir."]},"beginTime":8,"endTime":66,"href":"/video/preview/14331877731486731533?parent-reqid=1777079793875564-16103744211522117917-balancer-l7leveler-kubr-yp-vla-213-BAL&t=8&ask_summarization=1"},{"index":1,"title":"DÜŞEYARA Formülünü Kullanma","list":{"type":"unordered","items":["İki liste arasındaki ortak alanları bulmak için DÜŞEYARA formülü kullanılır.","Formülde önce aranan değer (örneğin öğrenci numarası) seçilir.","İkinci adımda arama yapılacak tablo dizisi seçilir.","Üçüncü adımda istenen verinin sütun indis numarası girilir.","Dördüncü adımda tam eşleşme için 0 değeri kullanılır."]},"beginTime":66,"endTime":170,"href":"/video/preview/14331877731486731533?parent-reqid=1777079793875564-16103744211522117917-balancer-l7leveler-kubr-yp-vla-213-BAL&t=66&ask_summarization=1"},{"index":2,"title":"Formülün Uygulanması ve Detayları","list":{"type":"unordered","items":["Formül tamamlandıktan sonra Enter'a basıldığında, aranan değerin karşılığı otomatik olarak getirilir.","Formülü aşağı doğru sürükleyerek tüm satırlar için otomatik olarak değerler getirilebilir.","DÜŞEYARA formülünde önemli bir detay, aranan değerin sağındaki değerlerin sadece getirilebileceği yönündedir.","Aranan değer sol sütunda ise sağdaki tüm sütunlardaki veriler getirilebilir, ancak aranan değer ortada veya sağda ise sadece o değerin sağındaki veriler getirilebilir."]},"beginTime":170,"endTime":346,"href":"/video/preview/14331877731486731533?parent-reqid=1777079793875564-16103744211522117917-balancer-l7leveler-kubr-yp-vla-213-BAL&t=170&ask_summarization=1"}],"linkTemplate":"/video/preview/14331877731486731533?parent-reqid=1777079793875564-16103744211522117917-balancer-l7leveler-kubr-yp-vla-213-BAL&t=%%timestamp%%&ask_summarization=1"},"isAdultDoc":false,"relatedParams":{"text":"İki Excel Listesindeki Verileri Birleştirme - Kolay Anlatim.","related_porno":false,"related_short":true,"related_less_3m_off":true,"client":"d2d","no_cnt":1,"related_src":"serp","related":"{\"porno\":false,\"vfp\":1,\"url\":\"http:\\/\\/www.youtube.com\\/watch?v=y2RbdgGeWlI\",\"src\":\"serp\",\"rvb\":\"EhYKFDE0MzMxODc3NzMxNDg2NzMxNTMzGhYKFDE0MzMxODc3NzMxNDg2NzMxNTMzWhQxNDMzMTg3NzczMTQ4NjczMTUzM2qIFxIBMBgAIkUaMQAKKmhobHFpc3Fua2tyaGZrZGJoaFVDS3NYd0VQeElrRU10blA0WlJvMGlHdxICABIqEMIPDxoPPxPdAoIEJAGABCsqiwEQARp4gfgMBP8C_gD4_vkEDgX9AQgDCgr3__8A6QUS-gX_AQAO7wz9_wAAAO4ABAQAAAAAFO_0Cfz_AgERAff8BAAAABf4AA34AAAA8Qjz-P8BAAD8DPb3A_8AAA4JAQUAAAAABhUGAv4AAAAOCQL7AQAAAALo9QMBAAAAIAAtMJjKOzgTQAlITlACKoQCEAAa8AFpMkP89-G5A5lHHQAUzdcA1NoA_wwm4P-UOQMAxNTmAKvoDgAgEdj_x-vQAIHh3gPlBun-BjG4_zf77f75vBoA483wASDk8wIjXu7-CgoHANkCSv5KxgD_IPIfAQMd4gQ1qP79Avn1CNn03QYk4xwD_QsWAu8hKgIP2PcCviX3_vTL7AIVvCgF8azc-vIEBfn0_BcNU0D1BAzO1_4Hz_oM3OvSAAD0BfNA-dsDCTTxBOD5KBIh8fbu-igX9tw87_zRPO39Og_zBTkUAQAA3CH_9-vwDA73CvNYK-wMyCIX_AIEEQboAQH0NQIM4-zf7_0gAC29-fA6OBNACUhhUAIqzwcQABrABzkr-r4ZAwy8Nu-0usldXz2wQmC9eMnJvA4s5z3H5cu7ekYsvSaWuj1DHwy9XiqGPfaWYr4FeIE8eT8NvP7Viz4gxJ88hqkxO-_mmb1xDm09-ggBPUePD75tpJE8aDjKPHkTLjtgGu27ffUnvQqBLD45R_g8Jey2vBHxYL0jBQC9HTOWO5E__bwNa4887L0YvRMqOL2k8VU9M40mvPhEaD29w2283tu-O0HuR70pmGy9oOzcvKlLNr7UVra81eSOPOFMgrwbTEM9_EdQPS8_w7svsYk7coKbvB2Eij2W0Sg9HE7PPOqS0b3csg297dPxvIYbsDzkXBS9qACYPC-G8r10kHy8_SGsPOvaKL3Pqb-8aIx7vBlvED32VYM9Rq6APDgskr0pa6W8wO5PvNeK1j1wbfY7VIupuujuhLzHJXM96a4tOuQ7xjuM9wM-vyzIPA5sMD2g8ti6_yUGPFFwnL10A4q9s1-3PCxsPLy6oek9HDkYOy2PmjyGe8A8PRKrO_r8pDqX2ly9RtEBPNbBxj0jlAi8daBaOxamTz1QQyq9fywGO-nJZj2BsDM9nHU-O3FBkTuoV2W9jRHkO47M4z2Vgu49Xb3tunxhEj6j4G49302aO_ggH72DjBs9vPpCvChyUr10MDE9Pqn-uzJBKL0prJm9T4dCOynEqzsn66G9bAZ6O5t-vz0Ud_w89IgrOo0jezxV7zq8sJFBO3DqA700uR29WWaVuzm4xL2Qbh897xIDO9ablz3bzDc9Tbg6OSayRT2jzpw8LiVDOeFi4Lw4zYy8BmWluKkiprx1YkW8Q9HNuDXhKDw1lZq9qORHObmnmz2i3mK93IDMOCCYkz02gw274hrzOWKqzzxWMOi6qSNcOKdHybybE8W9AwKzOFWibDwiqNq9y4FTt_nzwj37XO29BrmDOEy8CL26UJG5MhlBuWa2lb0aVkw9N02GOcn3Vr2_FSS9ENvRuMK0ubxMip-9BmB2ODq6gLzhsq-7WTFfOHqOSD3K5E89XFOlOGoFXL1WvKw8xZrwtwdnlr12z_C8hj7Lt9_KTb2ynOS9DYO3OHqlrLvR9RM9h47gOLVwNDxhqgm-LbtGt4BlJTyC0sY96iyoOI3CBL3MVb07Rj9mt-THsbre-a896-6puBHmkb2w73k9IBGMuA2fujvPXFG9oUWutgVp5j0z6F88Ng8uOGsKmT1QzJW8Rxylt-NrDz6FTh49F3SuOHANpjvnvkE8Mc3SuAoGQb38JI29TLnoNn56Ij1pL2y7pVeeNiAAOBNACUhtUAEqcxAAGmAf6gBE_wbj3yccBu3rDy_t8r_dD-ZQ_y_HANAivdz5E8ns2D8AEugRB6YAAAATFgEswQD7d5z4A_nGICyBueL5_HENBi6v5f_gBvAiGScT3wn0LDsA9Qmk_Cn6sxoUF-IgAC2_Jxw7OBNACUhvUAIqrwYQDBqgBgAASMIAADxCAACAvwAAREIAAFDBAAAwwQAAvEIAAMBAAAAIwgAAiEEAAAAAAABcwgAAeMIAABjCAAAMQgAArsIAAAjCAABYwgAAgMAAAADBAABgQQAAHMIAAADBAAC4QQAAQMEAADBBAAAcwgAAAMIAAJBCAAAQwQAAuMEAAIDBAAC2wgAAuEIAAJjBAAAEwgAAWMIAAFBCAACAPwAAaEIAAEDBAACYQQAAkMEAAIDBAAAMwgAApMIAAMDBAABQwQAAAEEAAOhBAAAMwgAAIMEAACDBAAAAQAAAKEIAAOBAAACOwgAAAEAAAGBBAADwQQAAAEIAAEBAAABwwgAAxsIAAAxCAABIwgAAYEEAAKDBAACIwgAAEMIAAKJCAABwQQAA4EEAAKjBAAAIQgAAEMIAAHBBAACAwQAAgEEAALBBAABowgAAikIAAIBAAADIQQAA2MEAAEDAAAAoQgAAbEIAAGRCAADoQQAA0EEAAJhBAACCwgAAHMIAAEzCAAA0wgAAIEEAAKBAAADuQgAAwEAAAGDBAAAQQQAAREIAAABCAAAQwgAAoEAAAJjBAAAAQQAAwMAAADxCAACgQQAAAEEAACDCAACOQgAA0EEAAIjBAADAQAAAKMIAAMBBAAAgwQAA4MAAAMjBAADAQAAAksIAAMDAAABIQgAAhEIAADTCAAB4wgAAgEAAAEjCAAAEQgAAYMEAAOBBAAAwQQAA0EEAAGhCAACAwAAAGMIAACjCAABgQQAAIMIAAGBBAABwwQAAXEIAAMBAAABQwgAAmEEAAFhCAACWQgAAXMIAAJBBAADgQQAAkMIAAMDBAAAAwgAAFMIAADjCAAAwwQAA-EEAAMBAAACWQgAAqMEAABzCAAAQwQAAAEIAAIA_AABwQgAAMEIAABDBAADAwAAAjEIAAEBAAAA0wgAA6MEAAIDAAADgwAAAAMEAACxCAACaQgAARMIAAGBBAADYwQAAJEIAACRCAACQwQAAjsIAABDBAAAUQgAAHEIAABxCAAAAwAAAoMEAADTCAABQQQAAQEEAAIjCAACwwQAAQEAAAKDBIAA4E0AJSHVQASqPAhAAGoACAACqvgAAUD0AADw-AAAEvgAAEL0AAGQ-AAB8PgAAO78AAKi9AADYPQAAmL0AACy-AACovQAAqj4AADA9AADWvgAAEL0AAKi9AAC6PgAAAz8AAGs_AACoPQAAiL0AAGQ-AAD4vQAAPL4AAKY-AADGvgAAoj4AAJ4-AABAPAAAmD0AAKA8AAC4vQAARD4AALK-AACgvAAAoDwAAEA8AACovQAANL4AAFQ-AAAkPgAAor4AAPi9AAD4vQAAgLsAAJi9AABEvgAAdL4AAHA9AACAOwAALD4AAJa-AACIvQAAgLsAAH8_AADovQAAHD4AADA9AACAuwAAPD4AAHA9AAAsPiAAOBNACUh8UAEqjwIQARqAAgAAqL0AAEQ-AACIPQAAMb8AAKi9AAAcvgAAHL4AAHC9AAC4vQAAUD0AAIa-AADIvQAAoLwAALK-AADoPQAA6L0AAAy-AABDPwAAEL0AAIY-AAAMvgAApr4AAOA8AADIvQAAqL0AAFC9AACIvQAAML0AAPg9AABQPQAAoLwAAOg9AAAcvgAAEL0AABC9AACKPgAADD4AAHw-AAA8vgAAiL0AAKC8AADgvAAAFL4AAAQ-AACAuwAAMD0AAH-_AAAcvgAAVL4AAMg9AAAcPgAARL4AAJo-AACYPQAAVL4AAKC8AAAQPQAA2D0AAHy-AACYvQAA6D0AAGw-AAD4PQAAdL4gADgTQAlIfFABMAk4AUoAYABoAA,,\"}","related_url":"http://www.youtube.com/watch?v=y2RbdgGeWlI","parent-reqid":"1777079793875564-16103744211522117917-balancer-l7leveler-kubr-yp-vla-213-BAL","related_vfp":1,"relatedVideo":"yes"},"cwidth":1920,"cheight":1080,"cratio":1.77777,"dups":["14331877731486731533"],"episode":0,"season":0,"isEmbedOnly":false,"greenHost":"YouTube","hasTranslation":true,"contentTypeId":null,"censored":false,"censoredShock":false,"isShockDoc":false,"videoContentId":"1614006854"},"undefined":{"docid":"","description":"","preview":{"posterSrc":"undefined/564x318_1"},"target":"_blank","position":"3","reqid":"1777079793875564-16103744211522117917-balancer-l7leveler-kubr-yp-vla-213-BAL","isAdultDoc":false,"cwidth":null,"cheight":null,"cratio":null,"dups":[],"episode":null,"season":null,"isEmbedOnly":false,"hasTranslation":false,"contentTypeId":null,"censored":false,"censoredShock":false,"isShockDoc":false}},"dups":{"14331877731486731533":{"videoId":"14331877731486731533","title":"İki Excel Listesindeki Verileri Birleştirme - Kolay Anlatim.","cleanTitle":"İki Excel Listesindeki Verileri Birleştirme - Kolay Anlatim.","host":{"title":"YouTube","href":"http://www.youtube.com/live/y2RbdgGeWlI","playerUri":"\u003ciframe src=\"//www.youtube.com/embed/y2RbdgGeWlI?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":"d3d3LnlvdXR1YmUuY29tO1VDS3NYd0VQeElrRU10blA0WlJvMGlHdw==","name":"Technological Solution Videos.","isVerified":false,"subscribersCount":0,"url":"/video/search?text=Technological+Solution+Videos.","origUrl":"http://www.youtube.com/c/Teknolojik%C3%87%C3%B6z%C3%BCmVideolar%C4%B1","a11yText":"Technological Solution Videos.. "},"faviconUrl":"//favicon.yandex.net/favicon/v2/http%3A%2F%2Fyoutube.com?color=255%2C255%2C255%2C0&size=32&stub=1"},"duration":{"value":349,"text":"5:49","a11yText":"Süre 5 dakika 49 saniye","shortText":"5 dk."},"views":{"text":"39,1bin","a11yText":"39,1 bin izleme"},"date":"20 kas 2021","modifyTime":1637366400000,"isExternal":false,"player":{"embedUrl":"https://www.youtube.com/embed/y2RbdgGeWlI?autoplay=1&enablejsapi=1&wmode=opaque","playerId":"youtube","videoUrl":"http://www.youtube.com/watch?v=y2RbdgGeWlI","reqid":"1777079793875564-16103744211522117917-balancer-l7leveler-kubr-yp-vla-213-BAL","duration":349},"parentClipId":"14331877731486731533","href":"/preview/14331877731486731533?parent-reqid=1777079793875564-16103744211522117917-balancer-l7leveler-kubr-yp-vla-213-BAL","rawHref":"/video/preview/14331877731486731533?parent-reqid=1777079793875564-16103744211522117917-balancer-l7leveler-kubr-yp-vla-213-BAL","isEmbedOnly":false,"shouldPlayInstreamPreroll":false,"commentsDisabled":false}},"loadingStatus":"None"},"internal":{"videoId":"14331877731486731533","sandboxEventPrefix":"sandbox:","sandboxVersion":"0x906f9600bf4","isEmbedded":false,"from":"yavideo","service":"ya-video","hbPeriod":30,"table":"video_tech","isInstreamDisabled":true,"nonce":"1037442115221179177213","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":{"adult":{"default":"R-I-474674-135","mail":"R-A-13426421-23"},"regular":{"default":"R-I-48058-751","mail":"R-A-13411721-23"}},"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"}},"search-grid-inplace":{"adult":{"default":"R-I-474674-126","mail":"R-A-13426421-16"},"regular":{"default":"R-I-48058-742","mail":"R-A-13411721-16"}}},"shouldValidateSandbox":false,"sandboxInitTimeout":15000,"isSSROnlyMastheadEnabled":true,"queryUriEscaped":"videoid%3A14331877731486731533","filterMode":1,"isUserChild":false,"advInstreamConfig":{"regular":{"default":{"category":"2","impId":"7","partnerId":"2216089","vmapScenarioId":"119"}},"adult":{"default":{"category":"3","impId":"4","partnerId":"1988486","vmapScenarioId":"119"}}}},"playbackQueue":{"currentIndex":0,"items":[{"type":"VIDEO","videoId":"14331877731486731533","source":"serp","selectEvent":"click"}]},"related":{"items":[],"pages":[],"loadingStatus":"None","nextPageNum":0,"ncrnd":0},"playlist":{"items":{}},"delayedViews":{"ids":[],"loadingStatus":"None"}}}