{"id":7435,"date":"2023-01-12T06:10:00","date_gmt":"2023-01-12T00:40:00","guid":{"rendered":"https:\/\/aiyoit.com\/tutorial\/?p=7435"},"modified":"2023-08-30T13:09:14","modified_gmt":"2023-08-30T07:39:14","slug":"lookup-formula-reference-in-excel","status":"publish","type":"post","link":"https:\/\/aiyoit.com\/tutorial\/lookup-formula-reference-in-excel\/","title":{"rendered":"Lookup Formula &#038; Reference in Excel"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"7435\" class=\"elementor elementor-7435\">\n\t\t\t\t\t\t\t\t\t<section data-particle_enable=\"false\" data-particle-mobile-disabled=\"false\" class=\"elementor-section elementor-top-section elementor-element elementor-element-312cffd4 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"312cffd4\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-4e503cf6\" data-id=\"4e503cf6\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-720e17d2 elementor-shape-circle elementor-grid-0 e-grid-align-center elementor-widget elementor-widget-social-icons\" data-id=\"720e17d2\" data-element_type=\"widget\" data-widget_type=\"social-icons.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.13.3 - 28-05-2023 *\/\n.elementor-widget-social-icons.elementor-grid-0 .elementor-widget-container,.elementor-widget-social-icons.elementor-grid-mobile-0 .elementor-widget-container,.elementor-widget-social-icons.elementor-grid-tablet-0 .elementor-widget-container{line-height:1;font-size:0}.elementor-widget-social-icons:not(.elementor-grid-0):not(.elementor-grid-tablet-0):not(.elementor-grid-mobile-0) .elementor-grid{display:inline-grid}.elementor-widget-social-icons .elementor-grid{grid-column-gap:var(--grid-column-gap,5px);grid-row-gap:var(--grid-row-gap,5px);grid-template-columns:var(--grid-template-columns);justify-content:var(--justify-content,center);justify-items:var(--justify-content,center)}.elementor-icon.elementor-social-icon{font-size:var(--icon-size,25px);line-height:var(--icon-size,25px);width:calc(var(--icon-size, 25px) + (2 * var(--icon-padding, .5em)));height:calc(var(--icon-size, 25px) + (2 * var(--icon-padding, .5em)))}.elementor-social-icon{--e-social-icon-icon-color:#fff;display:inline-flex;background-color:#69727d;align-items:center;justify-content:center;text-align:center;cursor:pointer}.elementor-social-icon i{color:var(--e-social-icon-icon-color)}.elementor-social-icon svg{fill:var(--e-social-icon-icon-color)}.elementor-social-icon:last-child{margin:0}.elementor-social-icon:hover{opacity:.9;color:#fff}.elementor-social-icon-android{background-color:#a4c639}.elementor-social-icon-apple{background-color:#999}.elementor-social-icon-behance{background-color:#1769ff}.elementor-social-icon-bitbucket{background-color:#205081}.elementor-social-icon-codepen{background-color:#000}.elementor-social-icon-delicious{background-color:#39f}.elementor-social-icon-deviantart{background-color:#05cc47}.elementor-social-icon-digg{background-color:#005be2}.elementor-social-icon-dribbble{background-color:#ea4c89}.elementor-social-icon-elementor{background-color:#d30c5c}.elementor-social-icon-envelope{background-color:#ea4335}.elementor-social-icon-facebook,.elementor-social-icon-facebook-f{background-color:#3b5998}.elementor-social-icon-flickr{background-color:#0063dc}.elementor-social-icon-foursquare{background-color:#2d5be3}.elementor-social-icon-free-code-camp,.elementor-social-icon-freecodecamp{background-color:#006400}.elementor-social-icon-github{background-color:#333}.elementor-social-icon-gitlab{background-color:#e24329}.elementor-social-icon-globe{background-color:#69727d}.elementor-social-icon-google-plus,.elementor-social-icon-google-plus-g{background-color:#dd4b39}.elementor-social-icon-houzz{background-color:#7ac142}.elementor-social-icon-instagram{background-color:#262626}.elementor-social-icon-jsfiddle{background-color:#487aa2}.elementor-social-icon-link{background-color:#818a91}.elementor-social-icon-linkedin,.elementor-social-icon-linkedin-in{background-color:#0077b5}.elementor-social-icon-medium{background-color:#00ab6b}.elementor-social-icon-meetup{background-color:#ec1c40}.elementor-social-icon-mixcloud{background-color:#273a4b}.elementor-social-icon-odnoklassniki{background-color:#f4731c}.elementor-social-icon-pinterest{background-color:#bd081c}.elementor-social-icon-product-hunt{background-color:#da552f}.elementor-social-icon-reddit{background-color:#ff4500}.elementor-social-icon-rss{background-color:#f26522}.elementor-social-icon-shopping-cart{background-color:#4caf50}.elementor-social-icon-skype{background-color:#00aff0}.elementor-social-icon-slideshare{background-color:#0077b5}.elementor-social-icon-snapchat{background-color:#fffc00}.elementor-social-icon-soundcloud{background-color:#f80}.elementor-social-icon-spotify{background-color:#2ebd59}.elementor-social-icon-stack-overflow{background-color:#fe7a15}.elementor-social-icon-steam{background-color:#00adee}.elementor-social-icon-stumbleupon{background-color:#eb4924}.elementor-social-icon-telegram{background-color:#2ca5e0}.elementor-social-icon-thumb-tack{background-color:#1aa1d8}.elementor-social-icon-tripadvisor{background-color:#589442}.elementor-social-icon-tumblr{background-color:#35465c}.elementor-social-icon-twitch{background-color:#6441a5}.elementor-social-icon-twitter{background-color:#1da1f2}.elementor-social-icon-viber{background-color:#665cac}.elementor-social-icon-vimeo{background-color:#1ab7ea}.elementor-social-icon-vk{background-color:#45668e}.elementor-social-icon-weibo{background-color:#dd2430}.elementor-social-icon-weixin{background-color:#31a918}.elementor-social-icon-whatsapp{background-color:#25d366}.elementor-social-icon-wordpress{background-color:#21759b}.elementor-social-icon-xing{background-color:#026466}.elementor-social-icon-yelp{background-color:#af0606}.elementor-social-icon-youtube{background-color:#cd201f}.elementor-social-icon-500px{background-color:#0099e5}.elementor-shape-rounded .elementor-icon.elementor-social-icon{border-radius:10%}.elementor-shape-circle .elementor-icon.elementor-social-icon{border-radius:50%}<\/style>\t\t<div class=\"elementor-social-icons-wrapper elementor-grid\">\n\t\t\t\t\t\t\t<span class=\"elementor-grid-item\">\n\t\t\t\t\t<a class=\"elementor-icon elementor-social-icon elementor-social-icon-facebook elementor-animation-buzz elementor-repeater-item-01b5564\" href=\"https:\/\/www.facebook.com\/aiyoit\" target=\"_blank\">\n\t\t\t\t\t\t<span class=\"elementor-screen-only\">Facebook<\/span>\n\t\t\t\t\t\t<i class=\"fab fa-facebook\"><\/i>\t\t\t\t\t<\/a>\n\t\t\t\t<\/span>\n\t\t\t\t\t\t\t<span class=\"elementor-grid-item\">\n\t\t\t\t\t<a class=\"elementor-icon elementor-social-icon elementor-social-icon-instagram elementor-animation-buzz elementor-repeater-item-8a90b95\" href=\"https:\/\/www.instagram.com\/aiyoitns\/\" target=\"_blank\">\n\t\t\t\t\t\t<span class=\"elementor-screen-only\">Instagram<\/span>\n\t\t\t\t\t\t<i class=\"fab fa-instagram\"><\/i>\t\t\t\t\t<\/a>\n\t\t\t\t<\/span>\n\t\t\t\t\t\t\t<span class=\"elementor-grid-item\">\n\t\t\t\t\t<a class=\"elementor-icon elementor-social-icon elementor-social-icon-youtube elementor-animation-buzz elementor-repeater-item-567c5bb\" href=\"https:\/\/www.youtube.com\/channel\/UCiagcH73PZUdTzRySS8Axig\" target=\"_blank\">\n\t\t\t\t\t\t<span class=\"elementor-screen-only\">Youtube<\/span>\n\t\t\t\t\t\t<i class=\"fab fa-youtube\"><\/i>\t\t\t\t\t<\/a>\n\t\t\t\t<\/span>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section data-particle_enable=\"false\" data-particle-mobile-disabled=\"false\" class=\"elementor-section elementor-top-section elementor-element elementor-element-370e685 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"370e685\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-c95a501\" data-id=\"c95a501\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-63704ae elementor-widget elementor-widget-text-editor\" data-id=\"63704ae\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.13.3 - 28-05-2023 *\/\n.elementor-widget-text-editor.elementor-drop-cap-view-stacked .elementor-drop-cap{background-color:#69727d;color:#fff}.elementor-widget-text-editor.elementor-drop-cap-view-framed .elementor-drop-cap{color:#69727d;border:3px solid;background-color:transparent}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap{margin-top:8px}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap-letter{width:1em;height:1em}.elementor-widget-text-editor .elementor-drop-cap{float:left;text-align:center;line-height:1;font-size:50px}.elementor-widget-text-editor .elementor-drop-cap-letter{display:inline-block}<\/style>\t\t\t\t<p>\u091c\u092c \u0906\u092a\u0915\u0947 \u092a\u093e\u0938 Excel Sheet \u092e\u0947\u0902 \u092c\u0939\u0941\u0924 \u0938\u093e\u0930\u093e Data \u0939\u094b\u0924\u093e \u0939\u0948 \u0914\u0930 \u0906\u092a\u0915\u094b \u0909\u0938 Data \u092e\u0947\u0902 \u0938\u0947 \u0915\u094b\u0908 Specific Value \u091a\u093e\u0939\u093f\u090f \u0939\u094b\u0924\u0940 \u0939\u0948 \u0924\u094b \u0924\u092c \u0906\u092a \u0907\u0938 Option \u0915\u093e \u0907\u0938\u094d\u0924\u0947\u092e\u093e\u0932 \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902\u0964 \u0907\u0938\u092e\u0947\u0902 \u0939\u092e\u0947\u0902\u00a0VLOOKUP\u00a0\u0914\u0930\u00a0HLOOKUP\u00a0\u091c\u0948\u0938\u0947 Formulas \u091c\u094b \u0915\u0940 Excel \u092e\u0947\u0902 \u092c\u0939\u0941\u0924 \u091c\u093e\u092f\u0926\u093e \u0907\u0938\u094d\u0924\u0947\u092e\u093e\u0932 \u0915\u093f\u090f \u091c\u093e\u0924\u0947 \u0939\u0948 \u0926\u0947\u0916\u0928\u0947 \u0915\u094b \u092e\u093f\u0932\u0924\u0947 \u0939\u0948\u0964<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-b305d69 elementor-toc--minimized-on-tablet elementor-widget elementor-widget-table-of-contents\" data-id=\"b305d69\" data-element_type=\"widget\" data-settings=\"{&quot;exclude_headings_by_selector&quot;:&quot;.comment-container , .smart-post&quot;,&quot;headings_by_tags&quot;:[&quot;h2&quot;,&quot;h3&quot;,&quot;h4&quot;,&quot;h5&quot;,&quot;h6&quot;],&quot;marker_view&quot;:&quot;numbers&quot;,&quot;minimize_box&quot;:&quot;yes&quot;,&quot;minimized_on&quot;:&quot;tablet&quot;,&quot;hierarchical_view&quot;:&quot;yes&quot;,&quot;min_height&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;size&quot;:&quot;&quot;,&quot;sizes&quot;:[]},&quot;min_height_tablet&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;size&quot;:&quot;&quot;,&quot;sizes&quot;:[]},&quot;min_height_mobile&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;size&quot;:&quot;&quot;,&quot;sizes&quot;:[]}}\" data-widget_type=\"table-of-contents.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor-pro - v3.10.1 - 09-01-2023 *\/\n.elementor-widget-table-of-contents .elementor-toc__header-title{color:var(--header-color)}.elementor-widget-table-of-contents.elementor-toc--collapsed .elementor-toc__toggle-button--collapse,.elementor-widget-table-of-contents:not(.elementor-toc--collapsed) .elementor-toc__toggle-button--expand{display:none}.elementor-widget-table-of-contents .elementor-widget-container{min-height:var(--box-min-height);border:var(--box-border-width,1px) solid var(--box-border-color,#a4afb7);border-radius:var(--box-border-radius,3px);background-color:var(--box-background-color);transition:min-height .4s;overflow:hidden}.elementor-toc__header{display:flex;align-items:center;justify-content:space-between;padding:var(--box-padding,20px);background-color:var(--header-background-color);border-bottom:var(--separator-width,1px) solid var(--box-border-color,#a4afb7)}.elementor-toc__header-title{font-size:18px;margin:0;color:var(--header-color)}.elementor-toc__toggle-button{cursor:pointer;display:inline-flex}.elementor-toc__toggle-button i{color:var(--toggle-button-color)}.elementor-toc__toggle-button svg{height:1em;width:1em;fill:var(--toggle-button-color)}.elementor-toc__spinner-container{text-align:center}.elementor-toc__spinner{font-size:2em}.elementor-toc__spinner.e-font-icon-svg{height:1em;width:1em}.elementor-toc__body{padding:var(--box-padding,20px);max-height:var(--toc-body-max-height);overflow-y:auto}.elementor-toc__body::-webkit-scrollbar{width:7px}.elementor-toc__body::-webkit-scrollbar-thumb{background-color:#c2cbd2;border-radius:10px}.elementor-toc__list-wrapper{list-style:none;padding:0}.elementor-toc__list-item{margin-bottom:.5em}.elementor-toc__list-item.elementor-item-active{font-weight:700}.elementor-toc__list-item .elementor-toc__list-wrapper{margin-top:.5em;margin-left:var(--nested-list-indent,1em)}.elementor-toc__list-item-text:hover{color:var(--item-text-hover-color);-webkit-text-decoration:var(--item-text-hover-decoration);text-decoration:var(--item-text-hover-decoration)}.elementor-toc__list-item-text.elementor-item-active{color:var(--item-text-active-color);-webkit-text-decoration:var(--item-text-active-decoration);text-decoration:var(--item-text-active-decoration)}.elementor-toc__list-item-text-wrapper{display:flex;align-items:center}.elementor-toc__list-item-text-wrapper:before,.elementor-toc__list-item-text-wrapper i{margin-right:8px;color:var(--marker-color)}.elementor-toc__list-item-text-wrapper svg{margin-right:8px;fill:var(--marker-color);height:var(--marker-size,.5em);width:var(--marker-size,.5em)}.elementor-toc__list-item-text-wrapper i{font-size:var(--marker-size,.5em)}.elementor-toc__list-item-text-wrapper:before{font-size:var(--marker-size,1em)}.elementor-toc--content-ellipsis .elementor-toc__list-item-text{white-space:nowrap;overflow:hidden;text-overflow:ellipsis}.elementor-toc__list-items--collapsible>.elementor-toc__list-wrapper>.elementor-toc__list-item>.elementor-toc__list-wrapper{display:none}.elementor-toc__heading-anchor{position:absolute}.elementor-toc__body .elementor-toc__list-item-text{color:var(--item-text-color);-webkit-text-decoration:var(--item-text-decoration);text-decoration:var(--item-text-decoration)}.elementor-toc__body .elementor-toc__list-item-text:hover{color:var(--item-text-hover-color);-webkit-text-decoration:var(--item-text-hover-decoration);text-decoration:var(--item-text-hover-decoration)}.elementor-toc__body .elementor-toc__list-item-text.elementor-item-active{color:var(--item-text-active-color);-webkit-text-decoration:var(--item-text-active-decoration);text-decoration:var(--item-text-active-decoration)}ol.elementor-toc__list-wrapper{counter-reset:item}ol.elementor-toc__list-wrapper .elementor-toc__list-item{counter-increment:item}ol.elementor-toc__list-wrapper .elementor-toc__list-item-text-wrapper:before{content:counters(item,\".\") \". \"}<\/style>\t\t<div class=\"elementor-toc__header\">\n\t\t\t<h4 class=\"elementor-toc__header-title\">\n\t\t\t\tTable of Contents\t\t\t<\/h4>\n\t\t\t\t\t\t\t<div class=\"elementor-toc__toggle-button elementor-toc__toggle-button--expand\"><i class=\"fas fa-chevron-down\"><\/i><\/div>\n\t\t\t\t<div class=\"elementor-toc__toggle-button elementor-toc__toggle-button--collapse\"><i class=\"fas fa-chevron-up\"><\/i><\/div>\n\t\t\t\t\t<\/div>\n\t\t<div class=\"elementor-toc__body\">\n\t\t\t<div class=\"elementor-toc__spinner-container\">\n\t\t\t\t<i class=\"elementor-toc__spinner eicon-animation-spin eicon-loading\" aria-hidden=\"true\"><\/i>\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7e90d4b elementor-widget elementor-widget-heading\" data-id=\"7e90d4b\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.13.3 - 28-05-2023 *\/\n.elementor-heading-title{padding:0;margin:0;line-height:1}.elementor-widget-heading .elementor-heading-title[class*=elementor-size-]>a{color:inherit;font-size:inherit;line-height:inherit}.elementor-widget-heading .elementor-heading-title.elementor-size-small{font-size:15px}.elementor-widget-heading .elementor-heading-title.elementor-size-medium{font-size:19px}.elementor-widget-heading .elementor-heading-title.elementor-size-large{font-size:29px}.elementor-widget-heading .elementor-heading-title.elementor-size-xl{font-size:39px}.elementor-widget-heading .elementor-heading-title.elementor-size-xxl{font-size:59px}<\/style><h2 class=\"elementor-heading-title elementor-size-default\">VLOOKUP<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-8e1f521 elementor-widget elementor-widget-text-editor\" data-id=\"8e1f521\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>VLOOKUP \u0915\u093e \u092e\u0924\u0932\u092c Vertical Lookup \u0939\u094b\u0924\u093e \u0939\u0948\u0964\u00a0Excel \u092e\u0947 VLOOKUP \u090f\u0915 \u0910\u0938\u093e function \u0939\u0948 \u091c\u094b Excel \u0915\u0947 \u090f\u0915 Column \u092e\u0947\u0902 \u090f\u0915 \u0928\u093f\u0936\u094d\u091a\u093f\u0924 \u0935\u0948\u0932\u094d\u092f\u0942 (Fixed Value) \u0915\u094b \u0922\u0942\u095d\u0924\u093e \u0939\u0948, \u0909\u0938\u0940 Row \u0915\u0947 \u0926\u0942\u0938\u0930\u0947 Column \u0938\u0947 Value \u0915\u094b \u0932\u093e\u0915\u0930 \u0926\u0947\u0924\u093e \u0939\u0948\u0964<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-74be885 elementor-widget elementor-widget-text-editor\" data-id=\"74be885\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><strong>Syntax : =Vlookup(lookup_value,table_array,column_index_num,[range_lookup])<\/strong><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-348a8dd elementor-widget elementor-widget-text-editor\" data-id=\"348a8dd\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<ul><li><strong>Lookup_value : <\/strong>\u092f\u0939 \u0935\u0939 Value \u0939\u094b\u0924\u093e \u0939\u0948 \u091c\u093f\u0938\u0915\u0947 Help \u0938\u0947 \u0906\u092a Range \u0938\u0947 \u0915\u094b\u0908 Value Find \u0915\u0930\u0947\u0902\u0917\u0947\u0964<\/li><li><strong>Table_array : <\/strong>\u091c\u093f\u0938\u0938\u0947 \u0906\u092a Value Find \u0915\u0930\u0928\u093e \u091a\u093e\u0939\u0924\u0947 \u0939\u0948\u0964<\/li><li><strong>Column_index_num : <\/strong>\u091c\u093f\u0938 Column \u0938\u0947 \u0906\u092a\u0915\u094b Value Find \u0915\u0930\u0928\u0940 \u0939\u0948\u0964<\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f086d7c elementor-widget elementor-widget-image\" data-id=\"f086d7c\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.13.3 - 28-05-2023 *\/\n.elementor-widget-image{text-align:center}.elementor-widget-image a{display:inline-block}.elementor-widget-image a img[src$=\".svg\"]{width:48px}.elementor-widget-image img{vertical-align:middle;display:inline-block}<\/style>\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"707\" height=\"252\" src=\"https:\/\/aiyoit.com\/tutorial\/wp-content\/uploads\/2023\/08\/VLOOKUP-Formula.png\" class=\"attachment-large size-large wp-image-7526\" alt=\"VLOOKUP Formula in Excel\" loading=\"lazy\" srcset=\"https:\/\/aiyoit.com\/tutorial\/wp-content\/uploads\/2023\/08\/VLOOKUP-Formula.png 707w, https:\/\/aiyoit.com\/tutorial\/wp-content\/uploads\/2023\/08\/VLOOKUP-Formula-300x107.png 300w, https:\/\/aiyoit.com\/tutorial\/wp-content\/uploads\/2023\/08\/VLOOKUP-Formula-150x53.png 150w\" sizes=\"(max-width: 707px) 100vw, 707px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-db21963 elementor-widget elementor-widget-heading\" data-id=\"db21963\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">HLOOKUP<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-e181e8f elementor-widget elementor-widget-text-editor\" data-id=\"e181e8f\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>HLOOKUP \u0915\u093e \u092e\u0924\u0932\u092c Horizontal Lookup \u0939\u094b\u0924\u093e \u0939\u0948\u0964 Excel \u092e\u0947 HLOOKUP \u090f\u0915 \u0910\u0938\u093e Formula \u092f\u093e Function \u0939\u0948 \u091c\u094b Excel \u0915\u0947 Horizontal Table \u0915\u0947 Column\u00a0\u092e\u0947\u0902 \u090f\u0915 Fixed Value (Lookup Value) \u0915\u094b \u0922\u0942\u0922\u093c\u0924\u093e \u0939\u0948, \u0909\u0938\u0940 Column \u0915\u0947 \u0926\u0942\u0938\u0930\u0947 Row (\u091c\u094b Row Number Formula \u092e\u0947 User \u0926\u094d\u0935\u093e\u0930\u093e \u0926\u093f\u092f\u093e \u091c\u093e\u0924\u093e \u0939\u0948) \u0938\u0947 Value \u0915\u094b \u0932\u093e\u0915\u0930 \u0926\u0947\u0924\u093e \u0939\u0948\u0964<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-95f79c4 elementor-widget elementor-widget-text-editor\" data-id=\"95f79c4\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><strong>Syntax : =Hlookup(lookup_value,table_array,row_index_num,[range_lookup])<\/strong><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-6e99ab8 elementor-widget elementor-widget-text-editor\" data-id=\"6e99ab8\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<ul><li><strong>Lookup_value : <\/strong>\u092f\u0939 \u0935\u0939 Value \u0939\u094b\u0924\u093e \u0939\u0948 \u091c\u093f\u0938\u0915\u0947 Help \u0938\u0947 \u0906\u092a Range \u0938\u0947 \u0915\u094b\u0908 Value Find \u0915\u0930\u0947\u0902\u0917\u0947\u0964<\/li><li><strong>Table_array : <\/strong>\u091c\u093f\u0938\u0938\u0947 \u0906\u092a Value Find \u0915\u0930\u0928\u093e \u091a\u093e\u0939\u0924\u0947 \u0939\u0948\u0964<\/li><li><strong>Row_index_num : <\/strong>\u091c\u093f\u0938 Row \u0938\u0947 \u0906\u092a\u0915\u094b Value Find \u0915\u0930\u0928\u0940 \u0939\u0948\u0964<\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-3cb064a elementor-widget elementor-widget-image\" data-id=\"3cb064a\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"700\" height=\"255\" src=\"https:\/\/aiyoit.com\/tutorial\/wp-content\/uploads\/2023\/08\/HLOOKUP-Formula.png\" class=\"attachment-large size-large wp-image-7525\" alt=\"HLOOKUP Formula in Excel\" loading=\"lazy\" srcset=\"https:\/\/aiyoit.com\/tutorial\/wp-content\/uploads\/2023\/08\/HLOOKUP-Formula.png 700w, https:\/\/aiyoit.com\/tutorial\/wp-content\/uploads\/2023\/08\/HLOOKUP-Formula-300x109.png 300w, https:\/\/aiyoit.com\/tutorial\/wp-content\/uploads\/2023\/08\/HLOOKUP-Formula-150x55.png 150w\" sizes=\"(max-width: 700px) 100vw, 700px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-77b9107 elementor-widget elementor-widget-heading\" data-id=\"77b9107\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">XLOOKUP<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-4a5f68b elementor-widget elementor-widget-text-editor\" data-id=\"4a5f68b\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>XLOOKUP Function \u0915\u093f\u0938\u0940 Range or Array \u0915\u094b Find \u0915\u0930\u0924\u093e \u0939\u0948, \u0914\u0930 \u092b\u093f\u0930 \u0909\u0938\u0915\u0947 \u0926\u094d\u0935\u093e\u0930\u093e \u0916\u094b\u091c\u0947 \u0917\u090f \u092a\u0939\u0932\u0947 Match \u0915\u0947 According Item Return \u0915\u0930\u0924\u093e \u0939\u0948\u0964 \u092f\u0926\u093f \u0915\u094b\u0908 Match Exists \u0928\u0939\u0940\u0902 \u0939\u0948, \u0924\u094b XLOOKUP \u0928\u093f\u0915\u091f\u0924\u092e (Approximate) Match Returns \u0915\u0930 \u0938\u0915\u0924\u093e \u0939\u0948\u0964<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-b002d98 elementor-widget elementor-widget-text-editor\" data-id=\"b002d98\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><strong>Syntax : =Xlookup(lookup_value,\u00a0lookup_array,\u00a0return_array,\u00a0[if_not_found],[match_mode],\u00a0[search_mode])<\/strong><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-e2b6854 elementor-widget elementor-widget-text-editor\" data-id=\"e2b6854\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<ul><li><strong>Lookup_array : <\/strong>The array or range to search<\/li><li><strong style=\"font-size: 16px;\">Return_array :<\/strong><span style=\"font-size: 16px;\"> The array or range to return<\/span><\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-3766f02 elementor-widget elementor-widget-image\" data-id=\"3766f02\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"712\" height=\"298\" src=\"https:\/\/aiyoit.com\/tutorial\/wp-content\/uploads\/2023\/08\/XLOOKUP-Formula.png\" class=\"attachment-large size-large wp-image-7527\" alt=\"XLOOKUP Formula in Excel\" loading=\"lazy\" srcset=\"https:\/\/aiyoit.com\/tutorial\/wp-content\/uploads\/2023\/08\/XLOOKUP-Formula.png 712w, https:\/\/aiyoit.com\/tutorial\/wp-content\/uploads\/2023\/08\/XLOOKUP-Formula-300x126.png 300w, https:\/\/aiyoit.com\/tutorial\/wp-content\/uploads\/2023\/08\/XLOOKUP-Formula-150x63.png 150w\" sizes=\"(max-width: 712px) 100vw, 712px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-5752737 elementor-widget elementor-widget-heading\" data-id=\"5752737\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">FILTER<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-1c8402c elementor-widget elementor-widget-text-editor\" data-id=\"1c8402c\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Filter Formula \u0938\u0947 \u0939\u092e \u0915\u093f\u0938\u0940 Database \u0938\u0947 Criteria \u0915\u0947 Base \u092a\u0930 Range \u0915\u094b Filter \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0964<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-5023e70 elementor-widget elementor-widget-text-editor\" data-id=\"5023e70\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><strong>Syntax : =Filter(array, include, [if_empty])<\/strong><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-9c1e683 elementor-widget elementor-widget-text-editor\" data-id=\"9c1e683\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<ul><li><strong>Array : <\/strong>Range or array to filter.<\/li><li><strong>include\u00a0:<\/strong> \u092f\u0939 \u090f\u0915 \u092a\u094d\u0930\u0915\u093e\u0930 \u0915\u093e Criteria \u0939\u094b\u0924\u093e \u0939\u0948 \u091c\u093f\u0938\u0915\u0947 Base \u092a\u0930 \u0939\u092e Range \u0915\u094b Filter \u0915\u0930\u0924\u0947 \u0939\u0948\u0964<\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d23da0f elementor-widget elementor-widget-image\" data-id=\"d23da0f\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"1024\" height=\"543\" src=\"https:\/\/aiyoit.com\/tutorial\/wp-content\/uploads\/2023\/08\/Filter-Formula-1024x543.png\" class=\"attachment-large size-large wp-image-7524\" alt=\"Filter Formula in Excel\" loading=\"lazy\" srcset=\"https:\/\/aiyoit.com\/tutorial\/wp-content\/uploads\/2023\/08\/Filter-Formula-1024x543.png 1024w, https:\/\/aiyoit.com\/tutorial\/wp-content\/uploads\/2023\/08\/Filter-Formula-300x159.png 300w, https:\/\/aiyoit.com\/tutorial\/wp-content\/uploads\/2023\/08\/Filter-Formula-150x80.png 150w, https:\/\/aiyoit.com\/tutorial\/wp-content\/uploads\/2023\/08\/Filter-Formula-768x407.png 768w, https:\/\/aiyoit.com\/tutorial\/wp-content\/uploads\/2023\/08\/Filter-Formula-1536x815.png 1536w, https:\/\/aiyoit.com\/tutorial\/wp-content\/uploads\/2023\/08\/Filter-Formula-2048x1087.png 2048w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section data-particle_enable=\"false\" data-particle-mobile-disabled=\"false\" class=\"elementor-section elementor-top-section elementor-element elementor-element-4981f47a elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"4981f47a\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-67ae1396\" data-id=\"67ae1396\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-35855ae2 elementor-widget elementor-widget-text-editor\" data-id=\"35855ae2\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>\u0907\u0928\u094d\u0939\u0947 \u092d\u0940 \u092a\u095d\u0947 &#8212;-<br \/>&gt;<a href=\"https:\/\/aiyoit.com\/tutorial\/financial-formula-in-ms-excel\/\" target=\"_blank\" rel=\"noopener\">Financial Formula in Excel<\/a><br \/><a style=\"font-size: 1rem;\" href=\"https:\/\/aiyoit.com\/tutorial\/logical-function-and-formula-in-ms-excel\/\" target=\"_blank\" rel=\"noopener\">&gt;Logical Function in Excel<\/a><br \/><a style=\"font-size: 1rem;\" href=\"https:\/\/aiyoit.com\/tutorial\/the-text-formula-in-ms-excel\/\" target=\"_blank\" rel=\"noopener\">&gt;Text Function in Excel<\/a><br \/><a style=\"font-size: 1rem;\" href=\"https:\/\/aiyoit.com\/tutorial\/lookup-formula-reference-in-excel\/\" target=\"_blank\" rel=\"noopener\">&gt;Lookup and Reference Formula in Excel<\/a><br \/><a href=\"https:\/\/aiyoit.com\/tutorial\/ms-excel-formulas-tab-in-hindi\/\" target=\"_blank\" rel=\"noopener\">&gt;Formula Tab in Excel In Hindi<\/a><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section data-particle_enable=\"false\" data-particle-mobile-disabled=\"false\" class=\"elementor-section elementor-top-section elementor-element elementor-element-54ef15db elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"54ef15db\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-8502edf\" data-id=\"8502edf\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-1c041571 elementor-widget elementor-widget-text-editor\" data-id=\"1c041571\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p class=\"has-background\"><em>\u0906\u0936\u093e \u0915\u0930\u0924\u093e \u0939\u0942\u0901 \u0915\u0940 \u0907\u0938 Article \u0938\u0947 \u0906\u092a\u0915\u094b Lookup and Reference Formula \u0938\u0947 \u091c\u0941\u0921\u093c\u0940 \u091c\u093e\u0928\u0915\u093e\u0930\u0940 \u092e\u093f\u0932\u0940 \u0939\u094b\u0917\u0940, \u0905\u0917\u0930 \u0906\u092a \u0915\u094b Excel \u0915\u0947 \u092c\u093e\u0930\u0947 \u092e\u0947\u0902 \u0915\u0941\u091b \u0938\u092e\u091d \u092e\u0947\u0902 \u0906\u092f\u093e \u0939\u094b \u0924\u094b \u0905\u092a\u0928\u0947 \u0926\u094b\u0938\u094d\u0924\u094b\u0902 \u0915\u0947 \u092a\u093e\u0938 \u091c\u0930\u0942\u0930 Share \u0915\u0930\u0947 \u0924\u093e\u0915\u093f \u0909\u0928\u0915\u094b \u092d\u0940\u00a0 Excel \u0915\u0947 \u092c\u093e\u0930\u0947 \u092e\u0947\u0902 knowledge \u092e\u093f\u0932 \u0938\u0915\u0947\u0964 \u0905\u0927\u093f\u0915 \u091c\u093e\u0928\u0915\u093e\u0930\u0940 \u0915\u0947 \u0932\u093f\u090f \u0939\u092e\u093e\u0930\u0947 <strong><a href=\"https:\/\/www.facebook.com\/aiyoit\" target=\"_blank\" rel=\"noreferrer noopener\">Facebook Page<\/a>\u00a0<\/strong>\u0915\u094b Follow \u0914\u0930\u00a0<strong><a href=\"https:\/\/www.youtube.com\/@aiyoit5339\/featured\" target=\"_blank\" rel=\"noreferrer noopener\">Youtube channel<\/a>\u00a0<\/strong>\u0915\u094b subscribe \u091c\u0930\u0942\u0930 \u0915\u0930\u0947 \u0905\u0917\u0930 \u0906\u092a \u0915\u093e \u0915\u094b\u0908 \u0938\u0935\u093e\u0932 \u0939\u094b \u0924\u094b comment box \u092e\u0947\u0902 \u091c\u0930\u0942\u0930 \u092c\u0924\u093e\u092f\u0947\u0964<\/em><\/p><p><strong>Thank You !<\/strong><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section data-particle_enable=\"false\" data-particle-mobile-disabled=\"false\" class=\"elementor-section elementor-top-section elementor-element elementor-element-4482c04c elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"4482c04c\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-34a692e3\" data-id=\"34a692e3\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-5206b594 elementor-widget elementor-widget-eael-content-ticker\" data-id=\"5206b594\" data-element_type=\"widget\" data-widget_type=\"eael-content-ticker.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<div class=\"eael-ticker-wrap\" id=\"eael-ticker-wrap-5206b594\"><div class=\"ticker-badge\">\n                    <span>Trending Today<\/span>\n                <\/div><div class=\"swiper-container-wrap eael-ticker\">\n                <div class=\"swiper-container eael-content-ticker swiper-container-5206b594\" data-pagination=\".swiper-pagination-5206b594\" data-arrow-next=\".swiper-button-next-5206b594\" data-arrow-prev=\".swiper-button-prev-5206b594\" data-effect=\"slide\" data-speed=\"400\" data-autoplay=\"2000\" data-loop=\"1\" data-arrows=\"1\">\n                    <div class=\"swiper-wrapper\"><div class=\"swiper-slide\">\n        <div class=\"ticker-content\">\n            <a href=\"https:\/\/aiyoit.com\/tutorial\/introduction-to-tally-prime\/\" class=\"ticker-content-link\">Introduction to Tally Prime<\/a>\n        <\/div>\n    <\/div><div class=\"swiper-slide\">\n        <div class=\"ticker-content\">\n            <a href=\"https:\/\/aiyoit.com\/tutorial\/medium-quize\/\" class=\"ticker-content-link\">Medium &#8211; Quize<\/a>\n        <\/div>\n    <\/div><div class=\"swiper-slide\">\n        <div class=\"ticker-content\">\n            <a href=\"https:\/\/aiyoit.com\/tutorial\/advanced-quize\/\" class=\"ticker-content-link\">Advanced &#8211; Quize<\/a>\n        <\/div>\n    <\/div><div class=\"swiper-slide\">\n        <div class=\"ticker-content\">\n            <a href=\"https:\/\/aiyoit.com\/tutorial\/basic-quize\/\" class=\"ticker-content-link\">Basic &#8211; Quize<\/a>\n        <\/div>\n    <\/div><\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"content-ticker-pagination\"><div class=\"swiper-button-next swiper-button-next-5206b594\"><i class=\"fas fa-angle-right\"><\/i><\/div><div class=\"swiper-button-prev swiper-button-prev-5206b594\"><i class=\"fas fa-angle-left\"><\/i><\/div><\/div>\n\t\t\t<\/div>\n\t\t<\/div>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section data-particle_enable=\"false\" data-particle-mobile-disabled=\"false\" class=\"elementor-section elementor-top-section elementor-element elementor-element-294f0b1 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"294f0b1\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-7c96425f\" data-id=\"7c96425f\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-2bed9dd2 elementor-share-buttons--view-icon-text elementor-share-buttons--skin-gradient elementor-share-buttons--shape-square elementor-grid-0 elementor-share-buttons--color-official elementor-widget elementor-widget-share-buttons\" data-id=\"2bed9dd2\" data-element_type=\"widget\" data-widget_type=\"share-buttons.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<link rel=\"stylesheet\" href=\"https:\/\/aiyoit.com\/tutorial\/wp-content\/plugins\/elementor-pro\/assets\/css\/widget-share-buttons.min.css\">\t\t<div class=\"elementor-grid\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-grid-item\">\n\t\t\t\t\t\t<div\n\t\t\t\t\t\t\tclass=\"elementor-share-btn elementor-share-btn_facebook\"\n\t\t\t\t\t\t\trole=\"button\"\n\t\t\t\t\t\t\ttabindex=\"0\"\n\t\t\t\t\t\t\taria-label=\"Share on facebook\"\n\t\t\t\t\t\t>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__icon\">\n\t\t\t\t\t\t\t\t<i class=\"fab fa-facebook\" aria-hidden=\"true\"><\/i>\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"elementor-share-btn__text\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__title\">\n\t\t\t\t\t\t\t\t\t\tFacebook\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t<div class=\"elementor-grid-item\">\n\t\t\t\t\t\t<div\n\t\t\t\t\t\t\tclass=\"elementor-share-btn elementor-share-btn_pinterest\"\n\t\t\t\t\t\t\trole=\"button\"\n\t\t\t\t\t\t\ttabindex=\"0\"\n\t\t\t\t\t\t\taria-label=\"Share on pinterest\"\n\t\t\t\t\t\t>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__icon\">\n\t\t\t\t\t\t\t\t<i class=\"fab fa-pinterest\" aria-hidden=\"true\"><\/i>\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"elementor-share-btn__text\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__title\">\n\t\t\t\t\t\t\t\t\t\tPinterest\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t<div class=\"elementor-grid-item\">\n\t\t\t\t\t\t<div\n\t\t\t\t\t\t\tclass=\"elementor-share-btn elementor-share-btn_linkedin\"\n\t\t\t\t\t\t\trole=\"button\"\n\t\t\t\t\t\t\ttabindex=\"0\"\n\t\t\t\t\t\t\taria-label=\"Share on linkedin\"\n\t\t\t\t\t\t>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__icon\">\n\t\t\t\t\t\t\t\t<i class=\"fab fa-linkedin\" aria-hidden=\"true\"><\/i>\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"elementor-share-btn__text\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__title\">\n\t\t\t\t\t\t\t\t\t\tLinkedIn\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t<div class=\"elementor-grid-item\">\n\t\t\t\t\t\t<div\n\t\t\t\t\t\t\tclass=\"elementor-share-btn elementor-share-btn_whatsapp\"\n\t\t\t\t\t\t\trole=\"button\"\n\t\t\t\t\t\t\ttabindex=\"0\"\n\t\t\t\t\t\t\taria-label=\"Share on whatsapp\"\n\t\t\t\t\t\t>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__icon\">\n\t\t\t\t\t\t\t\t<i class=\"fab fa-whatsapp\" aria-hidden=\"true\"><\/i>\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"elementor-share-btn__text\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__title\">\n\t\t\t\t\t\t\t\t\t\tWhatsApp\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>VLOOKUP \u0915\u093e \u092e\u0924\u0932\u092c Vertical Lookup \u0939\u094b\u0924\u093e \u0939\u0948\u0964 Excel \u092e\u0947 VLOOKUP \u090f\u0915 \u0910\u0938\u093e function \u0939\u0948 \u091c\u094b Excel \u0915\u0947 \u090f\u0915 Column \u092e\u0947\u0902 \u090f\u0915 \u0928\u093f\u0936\u094d\u091a\u093f\u0924 \u0935\u0948\u0932\u094d\u092f\u0942 (Fixed Value) \u0915\u094b \u0922\u0942\u095d\u0924\u093e \u0939\u0948&#8230;<\/p>\n","protected":false},"author":6,"featured_media":7462,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"content-type":"","site-sidebar-layout":"default","site-content-layout":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":""},"categories":[44],"tags":[1758,1765,1764,1766,1770,1768,1761,1767,1762,1757,1759,1763,1760,1753],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/aiyoit.com\/tutorial\/wp-json\/wp\/v2\/posts\/7435"}],"collection":[{"href":"https:\/\/aiyoit.com\/tutorial\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/aiyoit.com\/tutorial\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/aiyoit.com\/tutorial\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/aiyoit.com\/tutorial\/wp-json\/wp\/v2\/comments?post=7435"}],"version-history":[{"count":22,"href":"https:\/\/aiyoit.com\/tutorial\/wp-json\/wp\/v2\/posts\/7435\/revisions"}],"predecessor-version":[{"id":7627,"href":"https:\/\/aiyoit.com\/tutorial\/wp-json\/wp\/v2\/posts\/7435\/revisions\/7627"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/aiyoit.com\/tutorial\/wp-json\/wp\/v2\/media\/7462"}],"wp:attachment":[{"href":"https:\/\/aiyoit.com\/tutorial\/wp-json\/wp\/v2\/media?parent=7435"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/aiyoit.com\/tutorial\/wp-json\/wp\/v2\/categories?post=7435"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/aiyoit.com\/tutorial\/wp-json\/wp\/v2\/tags?post=7435"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}