{"id":1038,"date":"2018-10-22T12:56:58","date_gmt":"2018-10-22T01:56:58","guid":{"rendered":"https:\/\/www.dynamicwebtraining.com.au\/blog\/?p=1038"},"modified":"2026-02-18T15:21:10","modified_gmt":"2026-02-18T04:21:10","slug":"index-and-match-in-excel","status":"publish","type":"post","link":"https:\/\/www.dynamicwebtraining.com.au\/blog\/index-and-match-in-excel","title":{"rendered":"How to use Index and Match in Microsoft Excel?"},"content":{"rendered":"\n

Excel Lookups are great ways to search for a particular value using queries within a large data set. There are many types of Lookups available in MS Excel and each one is having a different use. Among them, Index and Match are considered the most common type of lookup which offers a powerful formula for looking up in excel sheets.<\/p>\n\n\n\n\n\n\n\n

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

Match in Microsoft Excel<\/h2>\n\n\n\n

The search mechanism is used in Index and Match is known as a two-way lookup which allows you to do a matrix lookup on the given dataset. This formula may seem a little complex than Vertical Lookup, but when you get to know about the three components and how these formulas are interacting with each other, you\u2019ll love to use it.<\/p>\n\n\n\n

When to use Index and Match?<\/h4>\n\n\n\n

The other name of Index and Match is Matrix Lookup. That means, Index and Match has one condition to work – your data needs to be in a Matrix format. Vertical Lookup and Horizontal Lookup needs to be present in your data. It is the cross-reference in your data for vertical and horizontal fields.<\/p>\n\n\n\n

Here is an example of data where you can use Index and Match \u2013<\/p>\n\n\n\n

\n
\"index-match-in-excel-01
Click image to enlarge <\/i><\/figcaption><\/figure>\n<\/div><\/div><\/div>\n\n\n\n

Difference between Vlookup and Index and Match?<\/h4>\n\n\n\n

Index and Match are considered better than Vlookup. But, why? Let\u2019s see with an example.<\/p>\n\n\n\n

\n
\"index-match-in-excel-02
Click image to enlarge <\/i><\/figcaption><\/figure>\n<\/div><\/div><\/div>\n\n\n\n

In this same example, classical V lookup is not going to work. To make Vlookup work here, the Applications<\/strong>, which are a unique set of data needed to be on the left<\/strong> most column and Section<\/strong>, which are not unique for each set of data needed to be on the right<\/strong> to the Applications column.<\/p>\n\n\n\n

So, Vlookup here will not be able to search the value you are looking for. For example, if I am looking for Profit against each unique Section for a selected Application, Vlookup is not good for that. It won’t work, as it is working with three components – Section, Profit, and Sales forming a matrix.
So, if the objective of the above chart is to pull the data like the Sales or the Profit of any particular application we desire. To do such an operation, vlookup will not be able to perform the function. Instead, Index and Match will perform perfectly here.<\/p>\n\n\n\n

How do Index and Match work?<\/h4>\n\n\n\n

With the Index and Match, now, let’s see how this is going to work here.<\/p>\n\n\n\n

Let’s say we have selected Application- \u2018Calixtnx<\/strong>\u2019 in the above example. To understand how Index and Match works, first, we must check out the formula or the syntax –<\/p>\n\n\n\n

= INDEX ( array , MATCH ( lookup_value , lookup_array , 0 ) , MATCH ( lookup_value , lookup_array , 0 ) )\n\n<\/pre>\n\n\n\n
So, there are three components in the formula, first, the array which is the base, 1st lookup array, and 2nd lookup array.<\/p>\n\n\n\n
Index Functions:<\/h4>\n\n\n\n
\n
\"index-match-in-excel-03
Click image to enlarge <\/i><\/figcaption><\/figure>\n<\/div><\/div><\/div>\n\n\n\n
First, we need to see how the index function works. In our example, let\u2019s use the index function in the Section.<\/p>\n\n\n\n
When we insert the Index function, we can see the three arguments in the Index function – array, row numbers and column numbers. The column is in square brackets. It means that is an optional argument.<\/p>\n\n\n\n
To understand Array<\/strong>, we can think of Index as a GPS function<\/strong> where we have to insert a map (arguments) to find our location. The map here is the array.<\/p>\n\n\n\n
First, we highlight<\/strong> the map in the example, which is the first column. We want to see on which section is Calixtnx<\/strong> located.<\/p>\n\n\n\n
\n
\"index-match-in-excel-04
Click image to enlarge <\/i><\/figcaption><\/figure>\n<\/div><\/div><\/div>\n\n\n\n
Here we are not looking at the exact answer, with Index function we are only defining the map or the region where our answer lies. It doesn\u2019t matter what you lookup problem is. In this case the answer lies in the Section column. Hence we select the region from B7 to B16.<\/p>\n\n\n\n
Now to the next arguments which are the row numbers and column numbers. Let us think of them as the Latitude and the Longitude.
The row numbers define the exact row in the array. Here let us input the row number with 3 in the \u2018row_num\u2019 argument and since the Column number is in Square bracket, let us ignore it for no and close the bracket without entering any column number.<\/p>\n\n\n\n
The answer it returns is the \u2018Health<\/strong>\u2019. Here we actually get a wrong answer as we manually entered row number as 3 instead of 9. But we know one thing for sure the index function is working.<\/p>\n\n\n\n
\n
\"index-match-in-excel-05
Click image to enlarge <\/i><\/figcaption><\/figure>\n<\/div><\/div><\/div>\n\n\n\n
It counts the header in the columns as row 0, as a matrix and then starts counting from 1 through the rows. Therefore, when we put row_num = 3, it gave us \u2018Health\u2019 as a result. If you put 9 , it will return with Activity as the Section.<\/p>\n\n\n\n
\n
\"index-match-in-excel-06
Click image to enlarge <\/i><\/figcaption><\/figure>\n<\/div><\/div><\/div>\n\n\n\n
Now, if we put column_num= 1, it still will give \u2018Health\u2019 in the Section, as Section is the column number 1. It takes that as a default value. But, if we put column_number = 2, it shows #Ref! in Section, as we are going out of the array (map) we have given to the index(GPS).<\/p>\n\n\n\n
\n
\"index-match-in-excel-08
Click image to enlarge <\/i><\/figcaption><\/figure>\n<\/div><\/div><\/div>\n\n\n\n
This is how the Index function works. But, we do not want to enter numbers directly into row_num and column_num arguments. We want to use the functions which return number value according to the logic of the search we want to put in. To do it without entering the row and column numbers manually, we need the Match<\/strong> function.<\/p>\n\n\n\n
The Match Function<\/h4>\n\n\n\n
We generally use the Match function, with Index function and these two work best together to search for a particular thing in a large dataset. Hence in the formula, Match always needs a lookup value.<\/p>\n\n\n\n
Syntax of the Match function is - =MATCH(lookup_value, lookup_array, [match_type]\n\n<\/pre>\n\n\n\n
\n
\"index-match-in-excel-09
Click image to enlarge <\/i><\/figcaption><\/figure>\n<\/div><\/div><\/div>\n\n\n\n
In the lookup_value argument, we enter the data we are looking up. In our example, we’ll enter \u201cCalixtnx<\/strong>\u201d.<\/p>\n\n\n\n
Next, we enter the array in which we are looking for \u2018Calixtnx<\/strong>\u2019, that is the column 2. In the argument, we’ll enter C7: C16<\/strong> where we kept our Applications.<\/p>\n\n\n\n
\n
\"index-match-in-excel-10
Click image to enlarge <\/i><\/figcaption><\/figure>\n<\/div><\/div><\/div>\n\n\n\n
Note: In case of Match function, we need to keep in mind that lookup_array should be linear. It cannot find values present in both directions, i.e., horizontally and vertically.<\/p>\n\n\n\n
\n
\"index-match-in-excel-11
Click image to enlarge <\/i><\/figcaption><\/figure>\n<\/div><\/div><\/div>\n\n\n\n
The next argument is \u2018match_type’, where we’ll use the Exact Match<\/strong> in the majority of the cases. Greater than or Less Than values are used in some special cases.<\/p>\n\n\n\n
So, our function now looks like this –<\/p>\n\n\n\n
\n
\"index-match-in-excel-12
Click image to enlarge <\/i><\/figcaption><\/figure>\n<\/div><\/div><\/div>\n\n\n\n
The result we get out of this function is 9. This means \u2018Calixtnx<\/strong>\u2019 is in the 9th position in the array. 9th position is C15, which is true.<\/p>\n\n\n\n
\n
\"index-match-in-excel-13
Click image to enlarge <\/i><\/figcaption><\/figure>\n<\/div><\/div><\/div>\n\n\n\n
Index and Match Together<\/h4>\n\n\n\n
Now, coming to the final stage, we\u2019ll be using both Index and Match functions together. Here we\u2019ll use Match as an argument in the Index function.<\/p>\n\n\n\n
In our example, we\u2019ll use the Section column as an array, i.e., the first argument in the Index function. Therefore, we\u2019ll write the function like =INDEX(B6:B17,…)<\/p>\n\n\n\n
\n
\"index-match-in-excel-14
Click image to enlarge <\/i><\/figcaption><\/figure>\n<\/div><\/div><\/div>\n\n\n\n
For the second argument \u2018row_num\u2019, we\u2019ll use Match function to look up for \u2018Calixtnx<\/strong>\u2019 in the Applications<\/strong> column. We\u2019ll write the function like – match (J6,C7:C16,0)<\/strong><\/p>\n\n\n\n
\n
\"index-match-in-excel-15
Click image to enlarge <\/i><\/figcaption><\/figure>\n<\/div><\/div><\/div>\n\n\n\n
\n
\"index-match-in-excel-16
Click image to enlarge <\/i><\/figcaption><\/figure>\n<\/div><\/div><\/div>\n\n\n\n
This will give the Section in which \u2018Calixtnx<\/strong>\u2019 Applications is used, that is \u2018Activity<\/strong>\u2019 as a result.<\/p>\n\n\n\n
\n
\"index-match-in-excel-17
Click image to enlarge <\/i><\/figcaption><\/figure>\n<\/div><\/div><\/div>\n\n\n\n
Note<\/strong>: For using Index and Match function, we need to keep in mind that array for both the functions should be of the same length.<\/em><\/p>\n\n\n\n
We\u2019ll follow the same technique to find the profit against Calixtnx like the following \u2013<\/p>\n\n\n\n
\n
\"index-match-in-excel-18
Click image to enlarge <\/i><\/figcaption><\/figure>\n<\/div><\/div><\/div>\n\n\n\n
\n
\"index-match-in-excel-19
Click image to enlarge <\/i><\/figcaption><\/figure>\n<\/div><\/div><\/div>\n\n\n\n
We get the Profit \u2013<\/p>\n\n\n\n
\n
\"index-match-in-excel-20
Click image to enlarge <\/i><\/figcaption><\/figure>\n<\/div><\/div><\/div>\n\n\n\n
Switch between two columns as a result<\/h4>\n\n\n\n
Till now we have seen a simple function in our example. Let\u2019s make it a little complex. Now, we want to switch between Sales and Profit using a dropdown and the value against it should also be changed.<\/p>\n\n\n\n
To do that first I am adding a Data Validation<\/strong> operation to create a dropdown which consists of Profit and Sales so that we can switch between them. Select the cell in this case and click Data Validation from the Data Tab.<\/p>\n\n\n\n
\n
\"index-match-in-excel-21
Click image to enlarge <\/i><\/figcaption><\/figure>\n<\/div><\/div><\/div>\n\n\n\n
The dialog box of Data validation looks like the picture shown below:<\/p>\n\n\n\n
\n
\"index-match-in-excel-22
Click image to enlarge <\/i><\/figcaption><\/figure>\n<\/div><\/div><\/div>\n\n\n\n
In the Allow Dropdown, Choose List and Select the Sales and Profit Headers as the Source.<\/p>\n\n\n\n
\n
\"index-match-in-excel-24
Click image to enlarge <\/i><\/figcaption><\/figure>\n<\/div><\/div><\/div>\n\n\n\n
So, we get a dropdown list like this –<\/p>\n\n\n\n
\n
\"index-match-in-excel-25
Click image to enlarge <\/i><\/figcaption><\/figure>\n<\/div><\/div><\/div>\n\n\n\n
Now, we want the value also gets changed against Profit or Sales, whatever we select. To achieve that, we need to use the Match function again, but now in the \u2018column_number\u2019 argument of the Index function, which we did not use in our previous example.<\/p>\n\n\n\n
First, we need to update our map that is the \u2018array\u2019 argument in the Index function, as now the data we are looking for can be in both Profit and Sales column. Therefore, we\u2019ll include both of them.<\/p>\n\n\n\n
\n
\"index-match-in-excel-26
Click image to enlarge <\/i><\/figcaption><\/figure>\n<\/div><\/div><\/div>\n\n\n\n
Now, we need to check out how many columns we are going to move in and the value depends on what we input. For that, we are going to use again the match function where the lookup_value is where \u2018Profit’ or \u2018Sales is.<\/p>\n\n\n\n
\n
\"index-match-in-excel-27
Click image to enlarge <\/i><\/figcaption><\/figure>\n<\/div><\/div><\/div>\n\n\n\n
Next thing we have to do is get the value for \u2018lookup_array’ argument of the Match function. Our array is in the columns Sales and Profit that starts with D6 and E6. Therefore, here we’ll enter D6: E6 in the argument to get the result.<\/p>\n\n\n\n
\n
\"index-match-in-excel-28
Click image to enlarge <\/i><\/figcaption><\/figure>\n<\/div><\/div><\/div>\n\n\n\n
Lastly, since we are looking for an exact match, we\u2019ll put 0 in the match_type argument as shown below.<\/p>\n\n\n\n
\n
\"index-match-in-excel-29
Click image to enlarge <\/i><\/figcaption><\/figure>\n<\/div><\/div><\/div>\n\n\n\n
What we get out of this? We can now change the Profit or Sales and we get the value for it-<\/p>\n\n\n\n
\n
\"index-match-in-excel-30
Click image to enlarge <\/i><\/figcaption><\/figure>\n<\/div><\/div><\/div>\n\n\n\n
\n
\"index-match-in-excel-31
Click image to enlarge <\/i><\/figcaption><\/figure>\n<\/div><\/div><\/div>\n\n\n\n
We can add a data validation similarly for the Select App, where we\u2019ll change the Application and we\u2019ll get Section and Profit\/ Sales for that Application. For example, we are now selecting \u2018Monito\u2019 Application. We\u2019ll see the value changing according to Monito Application.<\/p>\n\n\n\n
\n
\"index-match-in-excel-32
Click image to enlarge <\/i><\/figcaption><\/figure>\n<\/div><\/div><\/div>\n\n\n\n
\n
\"index-match-in-excel-33
Click image to enlarge <\/i><\/figcaption><\/figure>\n<\/div><\/div><\/div>\n\n\n\n
\n
\"index-match-in-excel-34
Click image to enlarge <\/i><\/figcaption><\/figure>\n<\/div><\/div><\/div>\n\n\n\n
\n
\"index-match-in-excel-35
Click image to enlarge <\/i><\/figcaption><\/figure>\n<\/div><\/div><\/div>\n\n\n\n
This is how you can use Index and Match functions in MS Excel for finding the correct value against multiple arguments in a huge number of data that is in a matrix format. They can be used to look up anything against very complex queries as well.<\/p>\n\n\n\n
To master the Index and Match and LookUp functions, we recommend our highly-rated Microsoft Excel Training Courses<\/a><\/strong> available in-person or online live.<\/p>\n","protected":false},"excerpt":{"rendered":"
Excel Lookups are great ways to search for a particular value using queries within a large data set. There are many types of Lookups available in MS Excel and each one is having a different use. Among them, Index and Match are considered the most common type of lookup which offers a powerful formula for…<\/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-1038","post","type-post","status-publish","format-standard","hentry","category-microsoft-excel"],"yoast_head":"How to Use Index and Match in Excel - Dynamic Web Training<\/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\" \/>\n<meta name=\"googlebot\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<meta name=\"bingbot\" 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\/index-and-match-in-excel\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Use Index and Match in Excel - Dynamic Web Training\" \/>\n<meta property=\"og:description\" content=\"Learn how to use index and match in Excel for finding the correct value against multiple arguments in a huge number of data that is in a matrix format.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dynamicwebtraining.com.au\/blog\/index-and-match-in-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-10-22T01:56:58+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-02-18T04:21:10+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2018\/10\/index-match.jpg\" \/>\n<meta name=\"twitter:card\" content=\"summary\" \/>\n<meta name=\"twitter:creator\" content=\"@dynamicwebtrain\" \/>\n<meta name=\"twitter:site\" content=\"@dynamicwebtrain\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/#organization\",\"name\":\"Dynamic Web Training\",\"url\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/\",\"sameAs\":[\"https:\/\/www.facebook.com\/DynamicWebTraining\/\",\"https:\/\/www.linkedin.com\/company\/dynamic-web-training\",\"https:\/\/twitter.com\/dynamicwebtrain\"],\"logo\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/#logo\",\"inLanguage\":\"en-US\",\"url\":\"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\/#logo\"}},{\"@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\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/?s={search_term_string}\",\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/index-and-match-in-excel#primaryimage\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2018\/10\/index-match.jpg\",\"width\":1200,\"height\":628},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/index-and-match-in-excel#webpage\",\"url\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/index-and-match-in-excel\",\"name\":\"How to Use Index and Match in Excel - Dynamic Web Training\",\"isPartOf\":{\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/index-and-match-in-excel#primaryimage\"},\"datePublished\":\"2018-10-22T01:56:58+00:00\",\"dateModified\":\"2026-02-18T04:21:10+00:00\",\"description\":\"Learn how to use index and match in Excel for finding the correct value against multiple arguments in a huge number of data that is in a matrix format.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/index-and-match-in-excel#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dynamicwebtraining.com.au\/blog\/index-and-match-in-excel\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/index-and-match-in-excel#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"item\":{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\",\"url\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\",\"name\":\"Training Blog\"}},{\"@type\":\"ListItem\",\"position\":2,\"item\":{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/category\/training\",\"url\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/category\/training\",\"name\":\"Training\"}},{\"@type\":\"ListItem\",\"position\":3,\"item\":{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/category\/training\/microsoft-excel\",\"url\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/category\/training\/microsoft-excel\",\"name\":\"Microsoft Excel\"}},{\"@type\":\"ListItem\",\"position\":4,\"item\":{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/index-and-match-in-excel\",\"url\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/index-and-match-in-excel\",\"name\":\"How to use Index and Match in Microsoft Excel?\"}}]},{\"@type\":\"Article\",\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/index-and-match-in-excel#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/index-and-match-in-excel#webpage\"},\"author\":{\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/#\/schema\/person\/c94653aed4a6decc8e357af0a1082233\"},\"headline\":\"How to use Index and Match in Microsoft Excel?\",\"datePublished\":\"2018-10-22T01:56:58+00:00\",\"dateModified\":\"2026-02-18T04:21:10+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/index-and-match-in-excel#webpage\"},\"publisher\":{\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/index-and-match-in-excel#primaryimage\"},\"articleSection\":\"Microsoft Excel\",\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/#\/schema\/person\/c94653aed4a6decc8e357af0a1082233\",\"name\":\"Dynamic Web Training\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/#personlogo\",\"inLanguage\":\"en-US\",\"url\":\"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.facebook.com\/DynamicWebTraining\/\",\"https:\/\/www.linkedin.com\/company\/dynamic-web-training\",\"https:\/\/twitter.com\/dynamicwebtrain\"]}]}<\/script>","_links":{"self":[{"href":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-json\/wp\/v2\/posts\/1038","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=1038"}],"version-history":[{"count":11,"href":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-json\/wp\/v2\/posts\/1038\/revisions"}],"predecessor-version":[{"id":2381,"href":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-json\/wp\/v2\/posts\/1038\/revisions\/2381"}],"wp:attachment":[{"href":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-json\/wp\/v2\/media?parent=1038"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-json\/wp\/v2\/categories?post=1038"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-json\/wp\/v2\/tags?post=1038"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}