{"id":890,"date":"2018-08-10T17:09:53","date_gmt":"2018-08-10T07:09:53","guid":{"rendered":"https:\/\/www.dynamicwebtraining.com.au\/blog\/?p=890"},"modified":"2024-11-14T13:43:46","modified_gmt":"2024-11-14T02:43:46","slug":"how-to-do-vlookup-and-hlookup-in-microsoft-excel","status":"publish","type":"post","link":"https:\/\/www.dynamicwebtraining.com.au\/blog\/how-to-do-vlookup-and-hlookup-in-microsoft-excel","title":{"rendered":"How To Do VLOOKUP and HLOOKUP In Microsoft Excel"},"content":{"rendered":"\n

Finance professionals or those handling student databases are often faced with the challenge of searching through a vast data pool, to find the data of their choice. If you too get goosebumps when asked to look for a specific data, from an overwhelming amount of data stored on an excel sheet, then here\u2019s a secret treat for you.<\/p>\n\n\n\n\n\n\n\n

\n
\"How
Click image to enlarge <\/i><\/figcaption><\/figure>\n<\/div><\/div><\/div>\n\n\n\n

VLOOKUP and HLOOKUP<\/h2>\n\n\n\n

VLOOKUP<\/strong> and HLOOKUP<\/strong> are two powerful functions in Microsoft Excel that allow you to use a specific section of your excel spreadsheet, to search for the correct data. These functions let you search through the excel table containing data, based on user\u2019s requirement and extract the appropriate result from the table.<\/p>\n\n\n\n

In simple words, consider an excel sheet with names of 100 employees in column one and their corresponding details like ID, department, designation, etc. in the next 10 columns. Now, imagine a situation where you have been asked to prepare a sheet of 30 random employees out of 100 employees and are required to display their corresponding values from only 4 out of the 10 employee detail columns present in the excel sheet.<\/p>\n\n\n\n

You can either choose to take the tedious way and manually search through the sheet for every employee name & then search for the required corresponding values in respective columns or use VLOOKUP<\/em> or HLOOKUP<\/em> function.<\/p>\n\n\n\n

\n
\"How
Click image to enlarge <\/i><\/figcaption><\/figure>\n<\/div><\/div><\/div>\n\n\n\n

Before we can go into the formation and actual usage of these two powerful functions in excel, let\u2019s get a basic understanding of these two powerful functions first:<\/p>\n\n\n\n

VLOOKUP<\/h4>\n\n\n\n

As the name suggests, the \u201cVLOOKUP\u201d (where V means vertical) function in excel is used to look across a set of values placed vertically or in columns in an excel worksheet. It means that each column is responsible for one unique kind of data.<\/p>\n\n\n\n

For Eg<\/strong>: Consider a simple table containing student details like \u2013 Student Enrollment Number, Student Name, and Percentage. Here, there would be a separate dedicated column for only student enrollment numbers, one column for student names and so on.<\/p>\n\n\n\n

\n
\"How
Click image to enlarge <\/i><\/figcaption><\/figure>\n<\/div><\/div><\/div>\n\n\n\n

HLOOKUP<\/h4>\n\n\n\n

As the name suggests, the \u201cHLOOKUP\u201d (where H means horizontal) function in excel is used to look across a set of values placed horizontally or in rows in an excel worksheet. It denotes that each row is responsible for one unique kind of data.<\/p>\n\n\n\n

Consider the same above example, with the data now formatted by rows instead of columns.<\/p>\n\n\n\n

\n
\"How
Click image to enlarge <\/i><\/figcaption><\/figure>\n<\/div><\/div><\/div>\n\n\n\n

Applying VLOOKUP and HLOOKUP Functions<\/h4>\n\n\n\n

Consider a situation where you have an excel sheet containing 50 rows (each row corresponding with a student detail) and 10 columns (each column containing specific data type). The first column is the student enrollment number, and the rest of the 9 columns have different data types like student name, percentage, etc.<\/p>\n\n\n\n

Now imagine that you are required to prepare a report for 5 random students (whose enrollment numbers are provided to you) and you are required to display the names of each of those 5 students. You can either search through the sheet containing 50 rows and 10 columns manually, for every student\u2019s enrollment number & their corresponding names in the respective column or use VLOOKUP<\/strong> function.<\/p>\n\n\n\n

Refer Figure: 2<\/strong> as the source sheet for this example.<\/p>\n\n\n\n

Start by creating a new excel sheet. The first column will be the student enrollment number (with student enrollment number populated) followed by the column for student name for which we need data. It is the column where we shall be applying the VLOOKUP<\/em> function.<\/p>\n\n\n\n

Start by creating a new excel sheet. The first column will be the student enrollment number (with student enrollment number populated) followed by the column for \u2018student name\u2019 for which we need data. It is the column where we shall be applying the VLOOKUP<\/em> function.<\/p>\n\n\n\n

Applying VLOOKUP Function<\/h4>\n\n\n\n

VLOOKUP is represented by the general formula:<\/p>\n\n\n\n

=VLOOKUP(lookup_value, table array, col_index_num, [range_lookup])<\/pre>\n\n\n\n
\n
lookup_value<\/span><\/p>\n<\/td>
\n
Will be the cell reference of the cell in which student enrollment number ‘1001’ resides, in the new result\/report sheet (A3 in this example).<\/p>\n<\/td><\/tr>
\n
table_array<\/span><\/p>\n<\/td>
\n
The source of data where you are trying to find the corresponding value (Student name, in this case). In this case, it will be the entire source sheet with 100 rows and 19 columns.<\/p>\n<\/td><\/tr>
\n
col_index<\/span><\/p>\n<\/td>
This is the most important parameter of the formula. This value is the COLUMN NUMBER from the SOURCE SHEET, where the desired value resides (desired value, in this case, is Student name). Assume that the student name column is the 3rd column in the source sheet, then the col_index_num value will be 3.<\/td><\/tr>
\n
range_lookup<\/span><\/p>\n<\/td>
\n
This value is either 1 (True, Approximate match) or 0 (False, Exact match). It is most advisable to select 0, as you would surely not be interested in approximate value, especially when it comes to critical records.<\/p>\n<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
Thus, the resulting formula for this particular example would be:<\/p>\n\n\n\n
=VLOOKUP(A3,Sheet2!$A$3:$D$7,3,0)<\/pre>\n\n\n\n
\n
\"How
Click image to enlarge <\/i><\/figcaption><\/figure>\n<\/div><\/div><\/div>\n\n\n\n
The corresponding name for student enrollment number 1001 will be shown in the desired column as below.<\/p>\n\n\n\n
\n
\"How
Click image to enlarge <\/i><\/figcaption><\/figure>\n<\/div><\/div><\/div>\n\n\n\n
Applying HLOOKUP Function<\/h4>\n\n\n\n
The HLOOKUP function has almost the same syntax as VLOOKUP. The only exception is that, in HLOOKUP function, these lookup occurs horizontally and thus, you need to specify a row index number instead of column index like in VLOOKUP.<\/p>\n\n\n\n
=HLOOKUP(lookup_value,table_array,row_index_num, [range_lookup])<\/pre>\n\n\n\n
\n
row_index<\/span><\/p>\n<\/td>
This value is the ROW NUMBER from the SOURCE SHEET, where the desired value resides (desired value, in this case, is Student name). Assume that the student name row is the 3rd row in the source sheet, then the row_index_num value will be 3.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
Now consider the same above example, where this time, the data is in rows instead of columns. Thus, now you have an excel sheet containing 50 columns (each column corresponding with a student detail) and 10 rows (each row containing specific data type).<\/p>\n\n\n\n
Refer Figure: 3 as the source sheet for this example.<\/em><\/p>\n\n\n\n
Assume that the first value in front of student enrolment number row is 1001 (reference cell B1). Now, in the second row, we wish to display the name of a student, and so, we will apply HLOOKUP<\/em> in this row, i.e. \u2018Student Name\u2019 rows.<\/p>\n\n\n\n
Thus, the resulting formula for this particular example would be:<\/p>\n\n\n\n
=HLOOKUP(B1,Sheet1!$B$1:$F$5,3,0)<\/pre>\n\n\n\n
\n
\"How
Click image to enlarge <\/i><\/figcaption><\/figure>\n<\/div><\/div><\/div>\n\n\n\n
The corresponding name for student enrolment number 1001 will be displayed in the desired row as below.<\/p>\n\n\n\n
\n
\"How
Click image to enlarge <\/i><\/figcaption><\/figure>\n<\/div><\/div><\/div>\n","protected":false},"excerpt":{"rendered":"
Finance professionals or those handling student databases are often faced with the challenge of searching through a vast data pool, to find the data of their choice. If you too get goosebumps when asked to look for a specific data, from an overwhelming amount of data stored on an excel sheet, then here\u2019s a secret…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-890","post","type-post","status-publish","format-standard","hentry","category-microsoft-excel"],"yoast_head":"Use VLOOKUP and HLOOKUP In Microsoft Excel to find the data<\/title>\n<meta name=\"description\" content=\"View and Share Dynamic Web Training Blog Archives. This is a great source of articles and posts on Computer and IT training, tutorials and insights\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dynamicwebtraining.com.au\/blog\/how-to-do-vlookup-and-hlookup-in-microsoft-excel\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How To Do VLOOKUP and HLOOKUP In Microsoft Excel\" \/>\n<meta property=\"og:description\" content=\"VLOOKUP and HLOOKUP are two powerful functions in Excel which let you search through the excel table containing data and extract the appropriate result.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dynamicwebtraining.com.au\/blog\/how-to-do-vlookup-and-hlookup-in-microsoft-excel\" \/>\n<meta property=\"og:site_name\" content=\"Dynamic Web Training Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/DynamicWebTraining\/\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/DynamicWebTraining\/\" \/>\n<meta property=\"article:published_time\" content=\"2018-08-10T07:09:53+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-11-14T02:43:46+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2018\/08\/how-to-do-vlookup-and-hlookup.jpg\" \/>\n<meta name=\"author\" content=\"Dynamic Web Training\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@dynamicwebtrain\" \/>\n<meta name=\"twitter:site\" content=\"@dynamicwebtrain\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Dynamic Web Training\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/how-to-do-vlookup-and-hlookup-in-microsoft-excel#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/how-to-do-vlookup-and-hlookup-in-microsoft-excel\"},\"author\":{\"name\":\"Dynamic Web Training\",\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/#\\\/schema\\\/person\\\/c94653aed4a6decc8e357af0a1082233\"},\"headline\":\"How To Do VLOOKUP and HLOOKUP In Microsoft Excel\",\"datePublished\":\"2018-08-10T07:09:53+00:00\",\"dateModified\":\"2024-11-14T02:43:46+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/how-to-do-vlookup-and-hlookup-in-microsoft-excel\"},\"wordCount\":1053,\"publisher\":{\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/how-to-do-vlookup-and-hlookup-in-microsoft-excel#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/wp-content\\\/uploads\\\/2018\\\/08\\\/how-to-do-vlookup-and-hlookup.jpg\",\"articleSection\":[\"Microsoft Excel\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/how-to-do-vlookup-and-hlookup-in-microsoft-excel\",\"url\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/how-to-do-vlookup-and-hlookup-in-microsoft-excel\",\"name\":\"Use VLOOKUP and HLOOKUP In Microsoft Excel to find the data\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/how-to-do-vlookup-and-hlookup-in-microsoft-excel#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/how-to-do-vlookup-and-hlookup-in-microsoft-excel#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/wp-content\\\/uploads\\\/2018\\\/08\\\/how-to-do-vlookup-and-hlookup.jpg\",\"datePublished\":\"2018-08-10T07:09:53+00:00\",\"dateModified\":\"2024-11-14T02:43:46+00:00\",\"description\":\"VLOOKUP and HLOOKUP are two powerful functions in Excel which let you search through the excel table containing data and extract the appropriate result.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/how-to-do-vlookup-and-hlookup-in-microsoft-excel#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/how-to-do-vlookup-and-hlookup-in-microsoft-excel\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/how-to-do-vlookup-and-hlookup-in-microsoft-excel#primaryimage\",\"url\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/wp-content\\\/uploads\\\/2018\\\/08\\\/how-to-do-vlookup-and-hlookup.jpg\",\"contentUrl\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/wp-content\\\/uploads\\\/2018\\\/08\\\/how-to-do-vlookup-and-hlookup.jpg\",\"width\":1200,\"height\":628},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/how-to-do-vlookup-and-hlookup-in-microsoft-excel#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Training Blog\",\"item\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Training\",\"item\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/category\\\/training\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Microsoft Excel\",\"item\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/category\\\/training\\\/microsoft-excel\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"How To Do VLOOKUP and HLOOKUP In Microsoft Excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/\",\"name\":\"Dynamic Web Training Blog\",\"description\":\"The Ultimate Training Experience.\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/#organization\",\"name\":\"Dynamic Web Training\",\"url\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/wp-content\\\/uploads\\\/2016\\\/02\\\/logo.png\",\"contentUrl\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/wp-content\\\/uploads\\\/2016\\\/02\\\/logo.png\",\"width\":361,\"height\":109,\"caption\":\"Dynamic Web Training\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/DynamicWebTraining\\\/\",\"https:\\\/\\\/x.com\\\/dynamicwebtrain\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\\\/blog\\\/#\\\/schema\\\/person\\\/c94653aed4a6decc8e357af0a1082233\",\"name\":\"Dynamic Web Training\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/0a14e92e62ad4eee0843f5cf7da3a00e1df4c9763922d4d20ba3ed2402a6896d?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/0a14e92e62ad4eee0843f5cf7da3a00e1df4c9763922d4d20ba3ed2402a6896d?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/0a14e92e62ad4eee0843f5cf7da3a00e1df4c9763922d4d20ba3ed2402a6896d?s=96&d=mm&r=g\",\"caption\":\"Dynamic Web Training\"},\"description\":\"Dynamic Web Training is Australia's leading provider of instructor led software training. We offer training courses in Adobe, Web Design, Graphic Design, Photoshop, InDesign, Dreamweaver and many more.\",\"sameAs\":[\"https:\\\/\\\/www.dynamicwebtraining.com.au\",\"https:\\\/\\\/www.facebook.com\\\/DynamicWebTraining\\\/\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/dynamic-web-training\",\"https:\\\/\\\/x.com\\\/dynamicwebtrain\"],\"url\":\"https:\\\/\\\/www.dynamicwebtraining.com.au\"}]}<\/script>","yoast_head_json":{"title":"Use VLOOKUP and HLOOKUP In Microsoft Excel to find the data","description":"View and Share Dynamic Web Training Blog Archives. This is a great source of articles and posts on Computer and IT training, tutorials and insights","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:\/\/www.dynamicwebtraining.com.au\/blog\/how-to-do-vlookup-and-hlookup-in-microsoft-excel","og_locale":"en_US","og_type":"article","og_title":"How To Do VLOOKUP and HLOOKUP In Microsoft Excel","og_description":"VLOOKUP and HLOOKUP are two powerful functions in Excel which let you search through the excel table containing data and extract the appropriate result.","og_url":"https:\/\/www.dynamicwebtraining.com.au\/blog\/how-to-do-vlookup-and-hlookup-in-microsoft-excel","og_site_name":"Dynamic Web Training Blog","article_publisher":"https:\/\/www.facebook.com\/DynamicWebTraining\/","article_author":"https:\/\/www.facebook.com\/DynamicWebTraining\/","article_published_time":"2018-08-10T07:09:53+00:00","article_modified_time":"2024-11-14T02:43:46+00:00","og_image":[{"url":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2018\/08\/how-to-do-vlookup-and-hlookup.jpg","type":"","width":"","height":""}],"author":"Dynamic Web Training","twitter_card":"summary_large_image","twitter_creator":"@dynamicwebtrain","twitter_site":"@dynamicwebtrain","twitter_misc":{"Written by":"Dynamic Web Training","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/how-to-do-vlookup-and-hlookup-in-microsoft-excel#article","isPartOf":{"@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/how-to-do-vlookup-and-hlookup-in-microsoft-excel"},"author":{"name":"Dynamic Web Training","@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/#\/schema\/person\/c94653aed4a6decc8e357af0a1082233"},"headline":"How To Do VLOOKUP and HLOOKUP In Microsoft Excel","datePublished":"2018-08-10T07:09:53+00:00","dateModified":"2024-11-14T02:43:46+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/how-to-do-vlookup-and-hlookup-in-microsoft-excel"},"wordCount":1053,"publisher":{"@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/#organization"},"image":{"@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/how-to-do-vlookup-and-hlookup-in-microsoft-excel#primaryimage"},"thumbnailUrl":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2018\/08\/how-to-do-vlookup-and-hlookup.jpg","articleSection":["Microsoft Excel"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/how-to-do-vlookup-and-hlookup-in-microsoft-excel","url":"https:\/\/www.dynamicwebtraining.com.au\/blog\/how-to-do-vlookup-and-hlookup-in-microsoft-excel","name":"Use VLOOKUP and HLOOKUP In Microsoft Excel to find the data","isPartOf":{"@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/how-to-do-vlookup-and-hlookup-in-microsoft-excel#primaryimage"},"image":{"@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/how-to-do-vlookup-and-hlookup-in-microsoft-excel#primaryimage"},"thumbnailUrl":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2018\/08\/how-to-do-vlookup-and-hlookup.jpg","datePublished":"2018-08-10T07:09:53+00:00","dateModified":"2024-11-14T02:43:46+00:00","description":"VLOOKUP and HLOOKUP are two powerful functions in Excel which let you search through the excel table containing data and extract the appropriate result.","breadcrumb":{"@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/how-to-do-vlookup-and-hlookup-in-microsoft-excel#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dynamicwebtraining.com.au\/blog\/how-to-do-vlookup-and-hlookup-in-microsoft-excel"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/how-to-do-vlookup-and-hlookup-in-microsoft-excel#primaryimage","url":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2018\/08\/how-to-do-vlookup-and-hlookup.jpg","contentUrl":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2018\/08\/how-to-do-vlookup-and-hlookup.jpg","width":1200,"height":628},{"@type":"BreadcrumbList","@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/how-to-do-vlookup-and-hlookup-in-microsoft-excel#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Training Blog","item":"https:\/\/www.dynamicwebtraining.com.au\/blog\/"},{"@type":"ListItem","position":2,"name":"Training","item":"https:\/\/www.dynamicwebtraining.com.au\/blog\/category\/training"},{"@type":"ListItem","position":3,"name":"Microsoft Excel","item":"https:\/\/www.dynamicwebtraining.com.au\/blog\/category\/training\/microsoft-excel"},{"@type":"ListItem","position":4,"name":"How To Do VLOOKUP and HLOOKUP In Microsoft Excel"}]},{"@type":"WebSite","@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/#website","url":"https:\/\/www.dynamicwebtraining.com.au\/blog\/","name":"Dynamic Web Training Blog","description":"The Ultimate Training Experience.","publisher":{"@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dynamicwebtraining.com.au\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/#organization","name":"Dynamic Web Training","url":"https:\/\/www.dynamicwebtraining.com.au\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2016\/02\/logo.png","contentUrl":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2016\/02\/logo.png","width":361,"height":109,"caption":"Dynamic Web Training"},"image":{"@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/DynamicWebTraining\/","https:\/\/x.com\/dynamicwebtrain"]},{"@type":"Person","@id":"https:\/\/www.dynamicwebtraining.com.au\/blog\/#\/schema\/person\/c94653aed4a6decc8e357af0a1082233","name":"Dynamic Web Training","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/0a14e92e62ad4eee0843f5cf7da3a00e1df4c9763922d4d20ba3ed2402a6896d?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/0a14e92e62ad4eee0843f5cf7da3a00e1df4c9763922d4d20ba3ed2402a6896d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/0a14e92e62ad4eee0843f5cf7da3a00e1df4c9763922d4d20ba3ed2402a6896d?s=96&d=mm&r=g","caption":"Dynamic Web Training"},"description":"Dynamic Web Training is Australia's leading provider of instructor led software training. We offer training courses in Adobe, Web Design, Graphic Design, Photoshop, InDesign, Dreamweaver and many more.","sameAs":["https:\/\/www.dynamicwebtraining.com.au","https:\/\/www.facebook.com\/DynamicWebTraining\/","https:\/\/www.linkedin.com\/company\/dynamic-web-training","https:\/\/x.com\/dynamicwebtrain"],"url":"https:\/\/www.dynamicwebtraining.com.au"}]}},"_links":{"self":[{"href":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-json\/wp\/v2\/posts\/890","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-json\/wp\/v2\/comments?post=890"}],"version-history":[{"count":15,"href":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-json\/wp\/v2\/posts\/890\/revisions"}],"predecessor-version":[{"id":1936,"href":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-json\/wp\/v2\/posts\/890\/revisions\/1936"}],"wp:attachment":[{"href":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-json\/wp\/v2\/media?parent=890"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-json\/wp\/v2\/categories?post=890"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-json\/wp\/v2\/tags?post=890"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}