{"id":486,"date":"2023-03-07T23:22:43","date_gmt":"2023-03-07T15:22:43","guid":{"rendered":"https:\/\/hk.sor-site.com\/?p=486"},"modified":"2024-04-21T21:53:18","modified_gmt":"2024-04-21T13:53:18","slug":"function-formula-vlookup_and_indexmatch","status":"publish","type":"post","link":"https:\/\/hk.sor-site.com\/index.php\/excel\/function-formula-vlookup_and_indexmatch\/","title":{"rendered":"Excel\u4ea4\u6d41\u5206\u4eab &#8211; Vlookup &amp; Index+Match"},"content":{"rendered":"\n<div style=\"height:30px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n<div class=\"svp_block_free_existing alignfull\" style=\"text-align:left;\"><div class=\"align wp-block-svp-video-player\" id='svpVideoPlayer-1' data-attributes='{&quot;align&quot;:&quot;&quot;,&quot;options&quot;:{&quot;controls&quot;:{&quot;play-large&quot;:true,&quot;restart&quot;:true,&quot;rewind&quot;:true,&quot;play&quot;:true,&quot;fast-forward&quot;:true,&quot;progress&quot;:true,&quot;current-time&quot;:true,&quot;mute&quot;:true,&quot;volume&quot;:true,&quot;captions&quot;:true,&quot;settings&quot;:true,&quot;pip&quot;:true,&quot;download&quot;:true,&quot;fullscreen&quot;:true},&quot;autoPlay&quot;:true,&quot;clickToPlay&quot;:true,&quot;muted&quot;:true,&quot;volume&quot;:0.5,&quot;seekTime&quot;:10,&quot;repeat&quot;:false,&quot;isAutoNextVideo&quot;:false,&quot;toolTip&quot;:true,&quot;isControl&quot;:true,&quot;shadowControl&quot;:true},&quot;videos&quot;:[{&quot;src&quot;:&quot;https:\\\/\\\/hk.sor-site.com\\\/wp-content\\\/uploads\\\/2024\\\/04\\\/Vlookup_and_IndexMatch.mp4&quot;,&quot;title&quot;:&quot;type your video title here&quot;,&quot;poster&quot;:&quot;&quot;,&quot;description&quot;:&quot;Don\\u2019t forget to like, comment, and subscribe for more fun episodes!&quot;,&quot;customDownloadButton&quot;:false,&quot;isCustomTitle&quot;:false,&quot;customDownloadUrl&quot;:&quot;&quot;,&quot;qualities&quot;:[],&quot;captions&quot;:[]}],&quot;videoSize&quot;:{&quot;width&quot;:{&quot;desktop&quot;:&quot;100%&quot;,&quot;tablet&quot;:&quot;100%&quot;,&quot;mobile&quot;:&quot;100%&quot;},&quot;height&quot;:{&quot;desktop&quot;:&quot;&quot;,&quot;tablet&quot;:&quot;&quot;,&quot;mobile&quot;:&quot;&quot;}},&quot;thumbnailSize&quot;:{&quot;width&quot;:{&quot;desktop&quot;:&quot;100%&quot;,&quot;tablet&quot;:&quot;100%&quot;,&quot;mobile&quot;:&quot;100%&quot;},&quot;height&quot;:{&quot;desktop&quot;:&quot;82px&quot;,&quot;tablet&quot;:&quot;&quot;,&quot;mobile&quot;:&quot;&quot;}},&quot;playlist&quot;:false,&quot;themes&quot;:{&quot;theme&quot;:&quot;default&quot;},&quot;tabStyles&quot;:{&quot;activeBg&quot;:&quot;#334155&quot;,&quot;activeTitleColor&quot;:&quot;#fff&quot;,&quot;activeDesColor&quot;:&quot;#fff&quot;,&quot;inactiveBg&quot;:&quot;#F0F5FA&quot;,&quot;inactiveTitleColor&quot;:&quot;#3D8D7A&quot;,&quot;inactiveDesColor&quot;:&quot;#585a5c&quot;,&quot;durationTimeColor&quot;:&quot;#fff&quot;,&quot;durationBg&quot;:&quot;#000&quot;},&quot;captionstyles&quot;:{&quot;color&quot;:&quot;#ffffff&quot;,&quot;bg&quot;:&quot;rgba(0,0,0,0.7)&quot;},&quot;captionTypo&quot;:{&quot;fontSize&quot;:{&quot;desktop&quot;:&quot;18px&quot;,&quot;tablet&quot;:&quot;18px&quot;,&quot;mobile&quot;:&quot;18px&quot;},&quot;fontFamily&quot;:&quot;inherit&quot;,&quot;lineHeight&quot;:&quot;1.4&quot;,&quot;fontWeight&quot;:&quot;400&quot;,&quot;textTransform&quot;:&quot;none&quot;},&quot;titleTypo&quot;:{&quot;fontSize&quot;:{&quot;desktop&quot;:15,&quot;tablet&quot;:13,&quot;mobile&quot;:12}},&quot;descriptionTypo&quot;:{&quot;fontSize&quot;:{&quot;desktop&quot;:14,&quot;tablet&quot;:12,&quot;mobile&quot;:10}},&quot;durationTypo&quot;:{&quot;fontSize&quot;:{&quot;desktop&quot;:14,&quot;tablet&quot;:12,&quot;mobile&quot;:10}},&quot;viewersTypo&quot;:{&quot;fontSize&quot;:{&quot;desktop&quot;:14,&quot;tablet&quot;:12,&quot;mobile&quot;:10}},&quot;alignment&quot;:&quot;center&quot;,&quot;textAlign&quot;:&quot;center&quot;,&quot;background&quot;:{&quot;color&quot;:&quot;#0000&quot;},&quot;scrollBg&quot;:&quot;#3D8D7A&quot;,&quot;content&quot;:&quot;Content of the block&quot;,&quot;typography&quot;:{&quot;fontSize&quot;:20},&quot;color&quot;:&quot;#333&quot;,&quot;colors&quot;:{&quot;color&quot;:&quot;#333&quot;,&quot;bg&quot;:&quot;#fff&quot;},&quot;img&quot;:{&quot;id&quot;:null,&quot;url&quot;:&quot;&quot;,&quot;alt&quot;:&quot;&quot;,&quot;title&quot;:&quot;&quot;},&quot;padding&quot;:{&quot;top&quot;:&quot;15px&quot;,&quot;right&quot;:&quot;30px&quot;,&quot;bottom&quot;:&quot;15px&quot;,&quot;left&quot;:&quot;30px&quot;},&quot;margin&quot;:{&quot;top&quot;:&quot;0px&quot;,&quot;right&quot;:&quot;0px&quot;,&quot;bottom&quot;:&quot;15px&quot;,&quot;left&quot;:&quot;0px&quot;},&quot;border&quot;:{&quot;width&quot;:&quot;0px&quot;,&quot;style&quot;:&quot;solid&quot;,&quot;color&quot;:&quot;#000000&quot;,&quot;radius&quot;:&quot;0px&quot;},&quot;shadow&quot;:[],&quot;layout&quot;:&quot;vertical&quot;}'><\/div><\/div>\n\n\n<div style=\"height:30px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"has-text-align-center has-medium-font-size\"><a href=\"https:\/\/hk.sor-site.com\/wp-content\/uploads\/2024\/04\/Vlookup_and_IndexMatch_Function.xlsx\"><strong>Example Excel File Download<\/strong><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Example Excel File Download<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[21],"tags":[],"class_list":["post-486","post","type-post","status-publish","format-standard","hentry","category-excel"],"_links":{"self":[{"href":"https:\/\/hk.sor-site.com\/index.php\/wp-json\/wp\/v2\/posts\/486","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hk.sor-site.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hk.sor-site.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hk.sor-site.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/hk.sor-site.com\/index.php\/wp-json\/wp\/v2\/comments?post=486"}],"version-history":[{"count":6,"href":"https:\/\/hk.sor-site.com\/index.php\/wp-json\/wp\/v2\/posts\/486\/revisions"}],"predecessor-version":[{"id":1018,"href":"https:\/\/hk.sor-site.com\/index.php\/wp-json\/wp\/v2\/posts\/486\/revisions\/1018"}],"wp:attachment":[{"href":"https:\/\/hk.sor-site.com\/index.php\/wp-json\/wp\/v2\/media?parent=486"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hk.sor-site.com\/index.php\/wp-json\/wp\/v2\/categories?post=486"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hk.sor-site.com\/index.php\/wp-json\/wp\/v2\/tags?post=486"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}