{"id":571,"date":"2013-07-03T09:55:42","date_gmt":"2013-07-03T16:55:42","guid":{"rendered":"http:\/\/hellbach.us\/blog\/?p=571"},"modified":"2013-07-03T09:58:28","modified_gmt":"2013-07-03T16:58:28","slug":"vlookup-and-ms-excel","status":"publish","type":"post","link":"https:\/\/hellbach.us\/blog\/tech\/vlookup-and-ms-excel\/","title":{"rendered":"VLOOKUP and MS Excel"},"content":{"rendered":"<div class='__iawmlf-post-loop-links' style='display:none;' data-iawmlf-post-links='[{&quot;id&quot;:4747,&quot;href&quot;:&quot;http:\\\/\\\/www.businessinsider.com\\\/excel-tips-and-tricks-vlookup-2013-6&quot;,&quot;archived_href&quot;:&quot;http:\\\/\\\/web-wp.archive.org\\\/web\\\/20171011180656\\\/http:\\\/\\\/www.businessinsider.com\\\/excel-tips-and-tricks-vlookup-2013-6&quot;,&quot;redirect_href&quot;:&quot;&quot;,&quot;checks&quot;:[{&quot;date&quot;:&quot;2025-11-19 16:14:41&quot;,&quot;http_code&quot;:404}],&quot;broken&quot;:false,&quot;last_checked&quot;:{&quot;date&quot;:&quot;2025-11-19 16:14:41&quot;,&quot;http_code&quot;:404},&quot;process&quot;:&quot;done&quot;}]'><\/div>\n<h1>How To Use VLOOKUP, One Of The Best Data Searching Tricks In MS Excel<\/h1>\n<p>Microsoft Excel is one of the most useful programs ever developed in the history of computing. One function that anyone looking to master the spreadsheet program needs to know is VLOOKUP. It&#8217;s easily one of the handiest ways to sort through and understand large reams of data.<\/p>\n<p>Here, we break down an example of how to use VLOOKUP the right way: watch video on <a href=\"http:\/\/www.businessinsider.com\/excel-tips-and-tricks-vlookup-2013-6\" target=\"_blank\" rel=\"nofollow\">http:\/\/www.businessinsider.com\/excel-tips-and-tricks-vlookup-2013-6<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>How To Use VLOOKUP, One Of The Best Data Searching Tricks In MS Excel Microsoft Excel is one of the most useful programs ever developed in the history of computing. One function that anyone looking to master the spreadsheet program &hellip; <a href=\"https:\/\/hellbach.us\/blog\/tech\/vlookup-and-ms-excel\/\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[17,2],"tags":[],"class_list":["post-571","post","type-post","status-publish","format-standard","hentry","category-comp","category-tech"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.9 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>VLOOKUP and MS Excel - Hellbach blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/hellbach.us\/blog\/tech\/vlookup-and-ms-excel\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"VLOOKUP and MS Excel - Hellbach blog\" \/>\n<meta property=\"og:description\" content=\"How To Use VLOOKUP, One Of The Best Data Searching Tricks In MS Excel Microsoft Excel is one of the most useful programs ever developed in the history of computing. One function that anyone looking to master the spreadsheet program &hellip; Continue reading &rarr;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/hellbach.us\/blog\/tech\/vlookup-and-ms-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Hellbach blog\" \/>\n<meta property=\"article:published_time\" content=\"2013-07-03T16:55:42+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2013-07-03T16:58:28+00:00\" \/>\n<meta name=\"author\" content=\"alex\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"alex\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/hellbach.us\/blog\/tech\/vlookup-and-ms-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/hellbach.us\/blog\/tech\/vlookup-and-ms-excel\/\"},\"author\":{\"name\":\"alex\",\"@id\":\"https:\/\/hellbach.us\/blog\/#\/schema\/person\/9bf1a63e253268c42a6e9db64611c507\"},\"headline\":\"VLOOKUP and MS Excel\",\"datePublished\":\"2013-07-03T16:55:42+00:00\",\"dateModified\":\"2013-07-03T16:58:28+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/hellbach.us\/blog\/tech\/vlookup-and-ms-excel\/\"},\"wordCount\":89,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/hellbach.us\/blog\/#\/schema\/person\/9bf1a63e253268c42a6e9db64611c507\"},\"articleSection\":[\"Computer\",\"Technology\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/hellbach.us\/blog\/tech\/vlookup-and-ms-excel\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/hellbach.us\/blog\/tech\/vlookup-and-ms-excel\/\",\"url\":\"https:\/\/hellbach.us\/blog\/tech\/vlookup-and-ms-excel\/\",\"name\":\"VLOOKUP and MS Excel - Hellbach blog\",\"isPartOf\":{\"@id\":\"https:\/\/hellbach.us\/blog\/#website\"},\"datePublished\":\"2013-07-03T16:55:42+00:00\",\"dateModified\":\"2013-07-03T16:58:28+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/hellbach.us\/blog\/tech\/vlookup-and-ms-excel\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/hellbach.us\/blog\/tech\/vlookup-and-ms-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/hellbach.us\/blog\/tech\/vlookup-and-ms-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/hellbach.us\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"VLOOKUP and MS Excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/hellbach.us\/blog\/#website\",\"url\":\"https:\/\/hellbach.us\/blog\/\",\"name\":\"Hellbach blog\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/hellbach.us\/blog\/#\/schema\/person\/9bf1a63e253268c42a6e9db64611c507\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/hellbach.us\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/hellbach.us\/blog\/#\/schema\/person\/9bf1a63e253268c42a6e9db64611c507\",\"name\":\"alex\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/hellbach.us\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/9868a7f8fd709cd74cf51d978359a3ce66a47a17cd57185a9e1a4774d288e228?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/9868a7f8fd709cd74cf51d978359a3ce66a47a17cd57185a9e1a4774d288e228?s=96&d=mm&r=g\",\"caption\":\"alex\"},\"logo\":{\"@id\":\"https:\/\/hellbach.us\/blog\/#\/schema\/person\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"VLOOKUP and MS Excel - Hellbach blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/hellbach.us\/blog\/tech\/vlookup-and-ms-excel\/","og_locale":"en_US","og_type":"article","og_title":"VLOOKUP and MS Excel - Hellbach blog","og_description":"How To Use VLOOKUP, One Of The Best Data Searching Tricks In MS Excel Microsoft Excel is one of the most useful programs ever developed in the history of computing. One function that anyone looking to master the spreadsheet program &hellip; Continue reading &rarr;","og_url":"https:\/\/hellbach.us\/blog\/tech\/vlookup-and-ms-excel\/","og_site_name":"Hellbach blog","article_published_time":"2013-07-03T16:55:42+00:00","article_modified_time":"2013-07-03T16:58:28+00:00","author":"alex","twitter_card":"summary_large_image","twitter_misc":{"Written by":"alex"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/hellbach.us\/blog\/tech\/vlookup-and-ms-excel\/#article","isPartOf":{"@id":"https:\/\/hellbach.us\/blog\/tech\/vlookup-and-ms-excel\/"},"author":{"name":"alex","@id":"https:\/\/hellbach.us\/blog\/#\/schema\/person\/9bf1a63e253268c42a6e9db64611c507"},"headline":"VLOOKUP and MS Excel","datePublished":"2013-07-03T16:55:42+00:00","dateModified":"2013-07-03T16:58:28+00:00","mainEntityOfPage":{"@id":"https:\/\/hellbach.us\/blog\/tech\/vlookup-and-ms-excel\/"},"wordCount":89,"commentCount":0,"publisher":{"@id":"https:\/\/hellbach.us\/blog\/#\/schema\/person\/9bf1a63e253268c42a6e9db64611c507"},"articleSection":["Computer","Technology"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/hellbach.us\/blog\/tech\/vlookup-and-ms-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/hellbach.us\/blog\/tech\/vlookup-and-ms-excel\/","url":"https:\/\/hellbach.us\/blog\/tech\/vlookup-and-ms-excel\/","name":"VLOOKUP and MS Excel - Hellbach blog","isPartOf":{"@id":"https:\/\/hellbach.us\/blog\/#website"},"datePublished":"2013-07-03T16:55:42+00:00","dateModified":"2013-07-03T16:58:28+00:00","breadcrumb":{"@id":"https:\/\/hellbach.us\/blog\/tech\/vlookup-and-ms-excel\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/hellbach.us\/blog\/tech\/vlookup-and-ms-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/hellbach.us\/blog\/tech\/vlookup-and-ms-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/hellbach.us\/blog\/"},{"@type":"ListItem","position":2,"name":"VLOOKUP and MS Excel"}]},{"@type":"WebSite","@id":"https:\/\/hellbach.us\/blog\/#website","url":"https:\/\/hellbach.us\/blog\/","name":"Hellbach blog","description":"","publisher":{"@id":"https:\/\/hellbach.us\/blog\/#\/schema\/person\/9bf1a63e253268c42a6e9db64611c507"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/hellbach.us\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/hellbach.us\/blog\/#\/schema\/person\/9bf1a63e253268c42a6e9db64611c507","name":"alex","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/hellbach.us\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/9868a7f8fd709cd74cf51d978359a3ce66a47a17cd57185a9e1a4774d288e228?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/9868a7f8fd709cd74cf51d978359a3ce66a47a17cd57185a9e1a4774d288e228?s=96&d=mm&r=g","caption":"alex"},"logo":{"@id":"https:\/\/hellbach.us\/blog\/#\/schema\/person\/image\/"}}]}},"_links":{"self":[{"href":"https:\/\/hellbach.us\/blog\/wp-json\/wp\/v2\/posts\/571","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hellbach.us\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hellbach.us\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hellbach.us\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/hellbach.us\/blog\/wp-json\/wp\/v2\/comments?post=571"}],"version-history":[{"count":0,"href":"https:\/\/hellbach.us\/blog\/wp-json\/wp\/v2\/posts\/571\/revisions"}],"wp:attachment":[{"href":"https:\/\/hellbach.us\/blog\/wp-json\/wp\/v2\/media?parent=571"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hellbach.us\/blog\/wp-json\/wp\/v2\/categories?post=571"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hellbach.us\/blog\/wp-json\/wp\/v2\/tags?post=571"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}