MATCH<\/h4>\n
Firstly, let’s take a look at the MATCH function and how it works in Google Sheets.<\/p>\n
Remember that MATCH returns a position<\/strong> but not a value, so if you want to return a value itself, use INDEX<\/a>, HLOOKUP<\/a>, or VLOOKUP<\/a>.<\/p>\n In the snapshot below you can see that the position of Evan<\/strong> is 5<\/strong> within the range of cells A1 to A6<\/strong>.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2020\/11\/Match-image-1.png” alt=”match-function-google-sheets-1″ title_text=”Match image 1″ align=”center” module_class=”sheetgo-post-no-shadow-img” _builder_version=”4.22.2″ width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n What if you place the cells as shown in the snapshot below (B4 to B9)?<\/p>\n The relative position of Evan<\/strong>\u00a0still remains\u00a05<\/strong>.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2020\/11\/Match-image-2.png” alt=”match-function-google-sheets-2″ title_text=”Match image 2″ align=”center” module_class=”sheetgo-post-no-shadow-img” _builder_version=”4.22.2″ width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n That is exactly what the MATCH function is designed to do \u2013 return the relative position of an item (\u2018Evan\u2019) in a range of cells (A1:A6 or B4:B9).<\/p>\n [\/et_pb_text][et_pb_text module_class=”spreadsheet-function” _builder_version=”4.16″ border_width_left=”4px” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n =MATCH(search_key, range, search_type)<\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Take a look at the screenshot below. In column A, I have a set of data in ascending order (e.g. smallest to largest). I\u2019ve tried out a few variations of the MATCH function on this data.<\/p>\n In the first example, in row 2, I\u2019ve asked the MATCH function to search for ID #1400 by typing =Match(1400,A2:A15,1).<\/p>\n The second formula, in row 3, does the same as the first, and both tell me that ID #1400 is in the 7th row.<\/p>\n The difference is that in the first example, I used search_type 1, which is used when the data is in ascending order (which it is).<\/p>\n The second time, I used search_type 0, which is used when the data is not sorted, or when you only want an exact match. Because the data was sorted, and there was an exact match for 1400, both functions gave me the same result.<\/p>\n In the third example, in row 4, I ask the MATCH function to find me ID #1300 by typing =Match(1300,A2:A15,0). I use search_type 0 to specify that I want an exact match. Because there is no ID #1300, I get an error.<\/p>\n In the fourth example in row 5, however, I ask the same thing but use search_type 1. Here, the function does give me a result, indicating that the answer is in row 4.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2020\/11\/Match-image-3.png” alt=”match-function-google-sheets-3″ title_text=”Match image 3″ align=”center” module_class=”sheetgo-post-no-shadow-img” _builder_version=”4.22.2″ width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n One thing to remember is that the MATCH function won\u2019t necessarily give you the closest answer \u2014 as you can see, row 4 corresponds to ID #1125.<\/p>\n The next row, ID #1313, is much closer to the ID #1300 I was asking for. However, when searching data in ascending order, the function returns the closest value that is no larger than the search_key. Because of this, it returns row 4 as the result, not row 5.<\/p>\n In the last pair of examples, in row 6 and 7, instead of typing in the search_key<\/strong> directly, I indicate a reference cell which contains the search_key<\/strong>. I do this with the function =Match(D2,A2:A15,1)<\/strong>.<\/p>\n In the next example, I\u2019ll show the data sorted in descending order.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2020\/11\/Match-image-4.png” alt=”match-function-google-sheets-4″ title_text=”Match image 4″ align=”center” module_class=”sheetgo-post-no-shadow-img” _builder_version=”4.22.2″ width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n The examples here are the same as in the first image, except I am now using a search_key of <\/strong>-1 instead of 1 to reflect the fact that the data is sorted in descending order.<\/p>\n Notice the example of searching for ID #1300 \u2013 this time, the function gives a result of row 10, which corresponds to ID #1313, much closer to 1300 than when the same thing was done with the data sorted in ascending order.<\/p>\n The examples have shown have been with numeric values. How about using the MATCH function with text values?<\/p>\n Since you can\u2019t exactly define the \u2018less than\u2019 and \u2018greater than\u2019 values for text forms, I usually go with the search_type 0<\/strong>, which tells Google Sheets to search for an exact match. Here are a few examples:<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2020\/11\/Match-image-5.png” alt=”match-function-google-sheet-.5″ title_text=”Match image 5″ align=”center” module_class=”sheetgo-post-no-shadow-img” _builder_version=”4.22.2″ width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Notice how the search_key<\/strong> needs to be in quotation marks when it is a text string, like in the first example: =Match(“Eric”,A2:A14,0)<\/strong>. Another thing to remember is that when using search_key 0<\/strong> to search for an exact match, if there is no exact match the function will give an error (like in the first example above).<\/p>\n I\u2019ve been using the MATCH function in a vertical layout because that\u2019s most common. But there are certainly times when you might want to use it for a horizontal data set. In the example below, I\u2019ve done just that.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/05\/MATCH-FORMULA-GOOGLE-SHEETS-RANGE-WITH-TEXT-2.png” alt=”MATCH FORMULA GOOGLE SHEETS MATCH WITH TEXT 2″ title_text=”MATCH FORMULA GOOGLE SHEETS MATCH WITH TEXT 2″ module_class=”sheetgo-post-no-shadow-img” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text module_id=”index-match-function” _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Here, the MATCH function tells you the number of the column that contains the search_key<\/strong>.<\/p>\n Perhaps the most powerful use of MATCH in Google Sheets is when you use it in combination with the INDEX function, in order to look up values. But there’s already a VLOOKUP function in Google Sheets for that purpose, right?<\/p>\n True\u00a0\u2014 but the combination of MATCH and INDEX can solve several problems that arise when using VLOOKUP.<\/p>\n Take a look at the VLOOKUP example below:<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2020\/11\/Match-image-7.png” alt=”match-function-google-sheets-7″ title_text=”Match image 7″ align=”center” module_class=”sheetgo-post-no-shadow-img” _builder_version=”4.22.2″ width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n The VLOOKUP function in D2 looks up 161 in the \u2018Emp ID #\u2019 column (as it\u2019s the leftmost in the range A2:B11), and from the row where it finds the value 161, it fetches the value located in the second column (i.e. column B), while assuming the data is not sorted. So far, so good. But there are two critical problems when using VLOOKUP in Google Sheets.<\/p>\n What happens when you insert a new column between the first and second columns? Let\u2019s try that.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/05\/MATCH-FORMULA-GOOGLE-SHEETS-STATIC-CELL-REFERENCING.png” alt=”MATCH FORMULA GOOGLE SHEETS STATIC CELL REFERENCINGMATCH FORMULA GOOGLE SHEETS STATIC CELL REFERENCING” title_text=”MATCH FORMULA GOOGLE SHEETS STATIC CELL REFERENCING” align=”center” module_class=”sheetgo-post-no-shadow-img” _builder_version=”4.22.2″ width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n You\u2019ll notice the returned value is not Ethan<\/strong>\u00a0anymore. This is because VLOOKUP is a semi-static function.<\/p>\n Google Sheets updated the second parameter to reflect the new range, but it did not accordingly change the column index (third parameter) when a new column was added before the Salesperson<\/strong> column.<\/p>\n You might find yourself in a situation where you have to look up values from a column (Emp ID #) that is not the leftmost, as shown below.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/05\/MATCH-FORMULA-GOOGLE-SHEETS-PROBLEM-2.png” alt=”MATCH FORMULA GOOGLE SHEETS PROBLEM 2″ title_text=”MATCH FORMULA GOOGLE SHEETS PROBLEM 2″ align=”center” module_class=”sheetgo-post-no-shadow-img” _builder_version=”4.22.2″ width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n In this case, moving the Emp ID # column to make it the leftmost would work. But that isn\u2019t an ideal approach \u2013 there can be data layout or presentation specifications that do not allow you to re-arrange columns. In that situation, what can you do? The MATCH and INDEX function combination comes to the rescue. Here\u2019s the combination syntax, followed by a few examples.<\/p>\n The key to this combination is that both the ranges selected for the INDEX and MATCH functions, respectively, need to be a single column. You are essentially using a VLOOKUP function, but specifying the column to look in, and the column to return the value from, in separate ranges within the MATCH and INDEX functions. As you\u2019ll see, this methodology helps you avoid the errors that can occur using VLOOKUP.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/05\/MATCH-FORMULA-GOOGLE-SHEETS-INDEX.png” alt=”MATCH FORMULA GOOGLE SHEETS INDEX” title_text=”MATCH FORMULA GOOGLE SHEETS INDEX” align=”center” module_class=”sheetgo-post-no-shadow-img” _builder_version=”4.22.2″ width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n In the above example, I\u2019ve used the MATCH function to tell me which row contains Emp ID #161 within column C. The function returns a number that tells the INDEX function which row in column A to look for the Salesperson. The result is that the two functions combine to tell me the correct name (Ethan) for Emp ID #161. The function I used to do this is =INDEX(A2:A11,MATCH(161,C2:C11,0))<\/strong>.<\/p>\n As you can see, unlike VLOOKUP, the combination works even if the lookup column is not the leftmost (see the first three examples in the above screenshot). Not surprisingly, it also works like VLOOKUP, when the lookup column is the leftmost.<\/p>\n Let\u2019s also see whether the functions hold up when you introduce a new column in between.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/05\/MATCH-FORMULA-GOOGLE-SHEETS-INDEX-2.png” alt=”MATCH FORMULA GOOGLE SHEETS INDEX 2″ title_text=”MATCH FORMULA GOOGLE SHEETS INDEX 2″ align=”center” module_class=”sheetgo-post-no-shadow-img” _builder_version=”4.22.2″ width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.20.2″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Thankfully, they still work. As soon as I introduced a new column (State), Google Sheets updated the references automatically to accommodate this change.<\/p>\n As you\u2019ve seen above, the MATCH and INDEX function combination is much more flexible and versatile than the already popular and powerful VLOOKUP function. But the combination of these functions can be even more powerful when you use two MATCH functions instead of just one.<\/p>\n [\/et_pb_text][et_pb_text admin_label=”Connections T – One tool – Horizontal” module_class=”sheetgo-post-no-shadow-img md2-contained-button vertical-banner-container” _builder_version=”4.27.4″ _module_preset=”default” background_color=”#f2f7ff” max_width=”700px” module_alignment=”center” max_height=”300px” custom_margin=”20px|0px|20px|0px|true|true” custom_padding=”25px|25px|25px|25px|true|true” sticky_limit_bottom=”section” border_radii=”on|20px|20px|20px|20px” border_width_all=”1px” border_color_all=”#d9e7ff” global_colors_info=”{}” global_module=”255434″ theme_builder_area=”post_content”]<\/p>\n One tool to merge, split, and filter all your spreadsheet data<\/span><\/p>\n Find out how<\/a><\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.20.2″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n You\u2019ve now seen how useful the INDEX and MATCH combination can be. But what if you have a bi-dimensional array from which you want to get a value? In this case, you can use the MATCH function twice within the INDEX function, as shown in the example below.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/05\/MATCH-FORMULA-GOOGLE-SHEETS-INDEX-3.png” alt=”MATCH FORMULA GOOGLE SHEETS INDEX 3″ title_text=”MATCH FORMULA GOOGLE SHEETS INDEX 3″ align=”center” module_class=”sheetgo-post-no-shadow-img” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n In this example, you can see data on the average temperature in each month, for the years 2015-2020. If you want to pull the average temperature of a specific month of a specific year out of this array, you can use the INDEX and MATCH combination to accomplish this. The function used here is: As you can see, I am using the MATCH function to give me the location of the row for the year I am looking for (in this case it\u2019s 2018, which is in the 4th row of data) as well as the column for the month I am looking for (September, in the 9th column of data). The INDEX function then takes these co-ordinates and returns the average temperature for September 2018.<\/p>\n By using the INDEX and MATCH functions, you can not only get a search function that is more versatile than VLOOKUP, but you can also search bi-dimensional arrays. To learn more about the INDEX function and its use, check out the following blog post: How to use the INDEX function in Google Sheets.<\/a><\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.22.2″ background_color=”#f9f9ff” custom_margin=”40px||40px||false|false” custom_padding=”15px|25px|15px|25px|true|true” border_width_left=”3px” border_color_left=”#808e95″ saved_tabs=”all” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Editor\u2019s note<\/strong>: This is a revised version of a previous post that has been updated for accuracy and comprehensiveness.<\/em><\/p>\n [\/et_pb_text][et_pb_code _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_code][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":" In Google Sheets, the MATCH function gives you the relative position of an item within a range of cells. Basically, if you want to know the position of a specific value within a range or array, MATCH will tell you where it’s located.\u00a0MATCH is handy but fairly basic, but when you combine it with INDEX, […]<\/p>\n","protected":false},"author":40,"featured_media":27672,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"In Google Sheets, the MATCH<\/a> formula gives us the relative position of an item in a range of cells. To understand this, please see the snapshot below. The position of 'Evan<\/strong>' is 5 within the range of cells A1 through A6.\n\nSyntax<\/h3>\n
<\/h3>\n
\n
\n
How to use MATCH in Google Sheets<\/h4>\n
Note about MATCH<\/h4>\n
Using MATCH with text<\/h4>\n
How to use the INDEX MATCH function combination
<\/strong><\/h3>\nProblem 1: Static cell referencing<\/h4>\n
Problem 2: Lookup column is always the leftmost<\/h4>\n
INDEX(reference, MATCH(search_key, range, search_type))<\/h4>\n
![\"\"](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/09\/connections-top-processors-main.webp\")
<\/p>\n![\"39\"](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/09\/Recommended-for-Google-Workspace-badge.webp\"){kind=icon}
<\/p>\nHow to use INDEX function with 2 MATCH functions<\/h3>\n
=INDEX(B2:M7, Match(B11, A2:A7, false), Match(B10, B1:M1, false))<\/p>\n![\"MATCH](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/11\/match1.png\")
\n\nWhat if we place the cells as shown in the below snapshot (B4 through B9)? The relative position of \"Evan\" would still remain 5.\n\n![\"MATCH](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/11\/match2.png\")
\n\nThat is exactly what the MATCH formula is set out to do - return the relative position of an item<\/strong> ('Evan<\/strong>') in a range<\/strong> of cells (A1:A6<\/strong> or B4:B9<\/strong>).\nSyntax<\/h3>\nMATCH(search_key, range, search_type)<\/strong><\/span>\n
\n \t
\n \t
Examples<\/h3>\nWithin column A, I have a test data in ascending order, on which I\u2019ve tried a few variations of the MATCH formula.\n\n
![\"MATCH](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/11\/match3.png\")
\n\nWhat do we see in column C, if we sort data in column A in descending order? Let\u2019s find out.\n\n![\"MATCH](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/11\/match4.png\")
\n\nThat was with the numeric values. How about using the MATCH formula with text values? Since we can\u2019t exactly define the 'less than' and 'greater than' values for text forms, we usually go with the search_type<\/strong><\/span> option 0<\/strong>, that tells Google Sheets to go for an exact match. Following are a few examples.\n\n![\"MATCH](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/11\/match5.png\")
\nUse case: INDEX & MATCH formula combination\n<\/strong><\/h3>\nPerhaps the most powerful use of MATCH formula in Google Sheets<\/a> is when we use it along with the INDEX<\/a> formula, in order to lookup values. But we already have VLOOKUP<\/a> formula in Google Sheets for this purpose, don't we? We have an example below:\n\n
![\"MATCH](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/11\/match6.png\")
\n\nThe VLOOKUP formula in D2 looks up 1432 in the ID column (as it the left most in the range A2:B15), and from the row where it finds 1432, it fetches the value located in the second column (i.e. column B), while assuming the data is not sorted. So far, so good. But we have two critical problems with using VLOOKUP in Google Sheets.\nProblem # 1<\/strong>: Static cell referencing.<\/h5>\nWhat happens when we insert a new column between the first and second columns? Let\u2019s try that.\n\n
![\"MATCH](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/11\/match7.png\")
\n\nYou\u2019ll notice the returned value is not \u2018Charlie<\/strong>\u2019 anymore. Because, it was a semi-static formula. Google Sheets updated the second parameter to reflect the new range, but it did not accordingly change the column index (third parameter) when we added a new column before the 'Name<\/strong>' column.\nProblem # 2<\/strong>: Lookup column is always the left most<\/h5>\nSituations may arise where the we might have to lookup values from a column (ID) that is not the left most, as shown below.\n\n
![\"MATCH](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/11\/match8.png\")
\n\nWhat if we move the ID column to make it the left most? Good idea. But, that isn\u2019t an ideal approach. Because, there can be data layout or presentation specifications that do not allow us to re-arrange columns. What, in such a situation, is the solution? The INDEX and MATCH formula combination comes to our rescue. Here\u2019s the combination syntax, followed by a few examples.\n\nINDEX(reference, MATCH(search_key, range, search_type))<\/strong><\/span>\n\n![\"MATCH](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/11\/match9.png\")
\n\nAs we can see, unlike VLOOKUP, the combination works even if the lookup column is not the left most (first three examples). Not surprisingly, it also works like VLOOKUP, when the lookup column is the left most.\n\nAlso, let\u2019s see whether the formulas still hold good, if we introduce a new column in between.\n\n![\"MATCH](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/11\/match10.png\")
\n\nThankfully, yes, they hold good. As soon as we introduced a new column (State), Google Sheets updated the references automatically to accommodate this change. Therefore, the INDEX & MATCH formula combination is much more flexible and versatile than the already popular and powerful VLOOKUP formula.","_et_gb_content_width":"","footnotes":""},"categories":[54],"tags":[39,28],"class_list":["post-2394","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-google-sheets-formulas","tag-connections-t","tag-spreadsheets"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts\/2394","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/users\/40"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/comments?post=2394"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts\/2394\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/media\/27672"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/media?parent=2394"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/categories?post=2394"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/tags?post=2394"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}