{"id":186,"date":"2021-02-26T00:15:28","date_gmt":"2021-02-25T23:15:28","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=186"},"modified":"2024-03-22T18:52:43","modified_gmt":"2024-03-22T17:52:43","slug":"vlookup-example-with-drop-down-list","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/vlookup-example-with-drop-down-list\/","title":{"rendered":"VLOOKUP Example: Vlookup with a Drop Down List"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_57_1 counter-flat ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title \" >Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li><a href=\"#\" class=\"scroll-to-download\">Free Practice Workbook<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/vlookup-example-with-drop-down-list\/#VLOOKUP_Formula_Syntax\" title=\"VLOOKUP Formula Syntax\">VLOOKUP Formula Syntax<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/vlookup-example-with-drop-down-list\/#Vlookup_with_a_Drop_Down_List_Step-By-Step_Guide\" title=\"Vlookup with a Drop Down List Step-By-Step Guide\">Vlookup with a Drop Down List Step-By-Step Guide<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/vlookup-example-with-drop-down-list\/#Conclusion\" title=\"Conclusion\">Conclusion<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"VLOOKUP_Formula_Syntax\"><\/span><strong>VLOOKUP Formula Syntax<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><em><strong>What does it do?<\/strong><\/em><\/p>\n<p>Searches for a value in the first column of a table array and returns a value in the same row from another column (to the right) in the table array.<\/p>\n<p><em><strong>Formula breakdown:<\/strong><\/em><\/p>\n<p>=VLOOKUP(<span style=\"color: #0000ff;\">lookup_value<\/span>, <span style=\"color: #ff6600;\">table_array<\/span>, <span style=\"color: #008000;\">col_index_num<\/span>, <span style=\"color: #ff00ff;\">[range_lookup]<\/span>)<\/p>\n<p><em><strong>What it means:<\/strong><\/em><\/p>\n<p>=VLOOKUP(<span style=\"color: #0000ff;\">this value<\/span>, <span style=\"color: #ff6600;\">in this list<\/span>, <span style=\"color: #008000;\">and get me value in this column<\/span>, <span style=\"color: #ff00ff;\">Exact Match\/FALSE\/0]<\/span>)<\/p>\n<hr \/>\n<p>The <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-excel-formulas-function-examples-to-get-better-at-microsoft-excel\/\" target=\"_blank\" rel=\"noopener\">VLOOKUP function in Excel<\/a> can become interactive and more powerful when applying a\u00a0<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/drop-down-list-with-data-validation\/\" target=\"_blank\" rel=\"noopener noreferrer\"><strong>Data Validation <\/strong><\/a>(drop down menu\/list) as the <em>Lookup_Value.\u00a0 <\/em>So as you change your selection from the drop-down list, the <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/vlookup-in-an-excel-table\/\" target=\"_blank\" rel=\"noopener\">Excel VLOOKUP<\/a> value also changes.<\/p>\n<h3>See how easy it is to apply this with Excel dependent drop down list VLOOKUP example below&#8230;<\/h3>\n<style>.special-box a { color: #fff; } <\/style><div class=\"drop-shadow lifted special-box\" style=\"text-align: center; color: #fff; padding: 15px; background: var(--V4-primary-orange); border-radius: 6px;\">&#x1f449; <strong><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/100-43.html\" target=\"_blank\" rel=\"noopener noreferrer\">Click Here To Join Our Free Formulas &amp; Functions Webinar Training on VLOOKUP, IF, SUMIF &amp; INDEX\/MATCH &amp; Advance Your Excel Level!<\/a><\/strong><\/div>\n<p>Follow the<strong>\u00a0step-by-step tutorial<\/strong> on Excel dependent drop down list Vlookup and\u00a0<strong>download this Excel workbook<\/strong>\u00a0to practice along<\/p>\n<div class=\"after-post-box\">\n<p class=\"line-two\"><a class=\"IRPP_minimalist icon-download button small\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/Vlookup_Data-Validation2.xlsx\" target=\"_blank\" rel=\"noopener noreferrer\" data-leadbox=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/Vlookup_Data-Validation2.xlsx\" data-leadbox-id=\"147284833f72a2:12f08263ab46dc\"><span class=\"ctaText px-3 text-capitalize\"><strong> download excel workbook<\/strong> <i class=\"fa fa-download\"><\/i><\/span><span class=\"postTitle px-3\">Vlookup_Data-Validation2.xlsx<\/span><\/a><\/p>\n<\/div>\n<div class=\"jumbotron2\">\n<div class=\"meo-subcount-2\">\n<p><!--<script type=\"text\/javascript\" src=\"https:\/\/lead.myexcelonline.com\/app\/js\/api.min.js\" data-campaign=\"f2q8uijmbbmwc3oohwuo\" data-user=\"52704\" async><\/script>--><\/p>\n<\/div>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Vlookup_with_a_Drop_Down_List_Step-By-Step_Guide\"><\/span>Vlookup with a Drop Down List Step-By-Step Guide<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"color: #ff0000;\"><strong>STEP 1<\/strong>:<\/span>\u00a0Go to <strong>Data &gt; <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/index-function-with-data-validation\/\" target=\"_blank\" rel=\"noopener\">Data Validation<\/a>.\u00a0<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/vlookup-data-validation-01.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-4459\" title=\"VLOOKUP Example: Vlookup with a Drop Down List\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/vlookup-data-validation-01.png\" alt=\"VLOOKUP Example: Vlookup with a Drop Down List\" width=\"1011\" height=\"140\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/vlookup-data-validation-01.png 1011w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/vlookup-data-validation-01-300x42.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/vlookup-data-validation-01-768x106.png 768w\" sizes=\"(max-width: 1011px) 100vw, 1011px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 2<\/strong>:<\/span>\u00a0Select\u00a0<strong>List\u00a0<\/strong>in the\u00a0<strong>Allow dropdown<\/strong><strong>.\u00a0<\/strong><\/p>\n<p>For the\u00a0<strong>Source,\u00a0<\/strong>ensure that it has the 4 Stock List values selected. Click\u00a0<strong>OK.<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/vlookup-data-validation-02-1.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-5101\" title=\"VLOOKUP Example: Vlookup with a Drop Down List\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/vlookup-data-validation-02-1.png\" alt=\"VLOOKUP Example: Vlookup with a Drop Down List\" width=\"867\" height=\"329\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/vlookup-data-validation-02-1.png 867w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/vlookup-data-validation-02-1-300x114.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/vlookup-data-validation-02-1-768x291.png 768w\" sizes=\"(max-width: 867px) 100vw, 867px\" \/><\/a><\/p>\n<p>Your dropdown is ready.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/vlookup-data-validation-03.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-4461\" title=\"VLOOKUP Example: Vlookup with a Drop Down List\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/vlookup-data-validation-03.png\" alt=\"VLOOKUP Example: Vlookup with a Drop Down List\" width=\"440\" height=\"163\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/vlookup-data-validation-03.png 440w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/vlookup-data-validation-03-300x111.png 300w\" sizes=\"(max-width: 440px) 100vw, 440px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 3:<\/strong> <\/span>We need to <strong>enter the <i>Vlookup\u00a0<\/i>function<\/strong> in the Excel Vlookup example:<\/p>\n<h3 style=\"text-align: center;\"><span style=\"color: #0000ff;\">=VLOOKUP(<\/span><\/h3>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/vlookup-data-validation-04.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-4462\" title=\"VLOOKUP Example: Vlookup with a Drop Down List\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/vlookup-data-validation-04.png\" alt=\"VLOOKUP Example: Vlookup with a Drop Down List\" width=\"463\" height=\"219\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/vlookup-data-validation-04.png 463w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/vlookup-data-validation-04-300x142.png 300w\" sizes=\"(max-width: 463px) 100vw, 463px\" \/><\/a><\/p>\n<p>The Vlookup\u00a0arguments:<\/p>\n<h3><em><strong><span style=\"color: #0000ff;\">lookup_value<\/span><\/strong><\/em><\/h3>\n<p><strong>What are we looking for?<\/strong><\/p>\n<p><em>Reference the cell that contains the text or value:<\/em><\/p>\n<h3 style=\"text-align: center;\"><span style=\"color: #000000;\">=VLOOKUP<\/span><span style=\"color: #0000ff;\">(G15,<\/span><\/h3>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/vlookup-data-validation-05-1.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-5102\" title=\"VLOOKUP Example: Vlookup with a Drop Down List\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/vlookup-data-validation-05-1.png\" alt=\"VLOOKUP Example: Vlookup with a Drop Down List\" width=\"1005\" height=\"178\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/vlookup-data-validation-05-1.png 1005w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/vlookup-data-validation-05-1-300x53.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/vlookup-data-validation-05-1-768x136.png 768w\" sizes=\"(max-width: 1005px) 100vw, 1005px\" \/><\/a><\/p>\n<h3><span style=\"color: #0000ff;\"><i>table_array<\/i><\/span><\/h3>\n<p><strong>From which list are we doing a lookup on?<\/strong><\/p>\n<p><em>Place in the <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/combining-cell-ranges-in-excel\/\" target=\"_blank\" rel=\"noopener\">cell range<\/a> of the Stock List:<\/em><\/p>\n<h3 style=\"text-align: center;\"><span style=\"color: #000000;\">=VLOOKUP<\/span><span style=\"color: #0000ff;\"><span style=\"color: #000000;\">(G15,<\/span>\u00a0$B$14:$D$17,<\/span><\/h3>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/vlookup-data-validation-06-1.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-5103\" title=\"VLOOKUP Example: Vlookup with a Drop Down List\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/vlookup-data-validation-06-1.png\" alt=\"VLOOKUP Example: Vlookup with a Drop Down List\" width=\"1012\" height=\"227\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/vlookup-data-validation-06-1.png 1012w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/vlookup-data-validation-06-1-300x67.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/vlookup-data-validation-06-1-768x172.png 768w\" sizes=\"(max-width: 1012px) 100vw, 1012px\" \/><\/a><\/p>\n<h3><em><strong><span style=\"color: #0000ff;\">col_index_num<\/span><\/strong><\/em><\/h3>\n<p><strong>From which column do we want to retrieve the value?<\/strong><\/p>\n<p><em>We want to\u00a0retrieve the Price which is the SECOND\u00a0column from our table array:<\/em><\/p>\n<h3 style=\"text-align: center;\"><span style=\"color: #000000;\">=VLOOKUP<\/span><span style=\"color: #0000ff;\"><span style=\"color: #000000;\">(G15,<\/span> <span style=\"color: #000000;\">$B$14:$D$17,<\/span>\u00a02,<\/span><\/h3>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/vlookup-data-validation-07-1.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-5104\" title=\"VLOOKUP Example: Vlookup with a Drop Down List\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/vlookup-data-validation-07-1.png\" alt=\"VLOOKUP Example: Vlookup with a Drop Down List\" width=\"1018\" height=\"227\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/vlookup-data-validation-07-1.png 1018w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/vlookup-data-validation-07-1-300x67.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/vlookup-data-validation-07-1-768x171.png 768w\" sizes=\"(max-width: 1018px) 100vw, 1018px\" \/><\/a><\/p>\n<h3><em><strong><span style=\"color: #0000ff;\">[range_lookup]<\/span><\/strong><\/em><\/h3>\n<p><strong>Do we want an exact match?<\/strong><\/p>\n<p><em>Place in FALSE to signify that we want an exact match:<\/em><\/p>\n<h3 style=\"text-align: center;\"><span style=\"color: #000000;\">=VLOOKUP<\/span><span style=\"color: #0000ff;\"><span style=\"color: #000000;\">(G15,<\/span>\u00a0<span style=\"color: #000000;\">$B$14:$D$17,<\/span> <span style=\"color: #000000;\">2,<\/span>\u00a0FALSE)<\/span><\/h3>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/vlookup-data-validation-08-1.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-5105\" title=\"VLOOKUP Example: Vlookup with a Drop Down List\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/vlookup-data-validation-08-1.png\" alt=\"VLOOKUP Example: Vlookup with a Drop Down List\" width=\"1014\" height=\"224\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/vlookup-data-validation-08-1.png 1014w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/vlookup-data-validation-08-1-300x66.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/vlookup-data-validation-08-1-768x170.png 768w\" sizes=\"(max-width: 1014px) 100vw, 1014px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>The price now dynamically changes based on your selection:<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/vlookup-data-validation-09.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-4467 size-full\" title=\"VLOOKUP Example: Vlookup with a Drop Down List\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/vlookup-data-validation-09.png\" alt=\"VLOOKUP Example: Vlookup with a Drop Down List\" width=\"800\" height=\"279\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/vlookup-data-validation-09.png 800w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/vlookup-data-validation-09-300x105.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/vlookup-data-validation-09-768x268.png 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/a><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Conclusion\"><\/span>Conclusion<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>This is how to use <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/free-microsoft-excel-online-course\/\" target=\"_blank\" rel=\"noopener\">Vlookup with a Drop Down List<\/a>!<\/p>\n<p><strong>Further Learning:<\/strong><\/p>\n<ul>\n<li><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/excel-named-ranges-with-vlookup-formula-excel\/\" target=\"_blank\" rel=\"noopener\">Named Ranges with Vlookup Formula<\/a><\/li>\n<li><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/vlookup-multiple-columns\/\" target=\"_blank\" rel=\"noopener\">Excel VLOOKUP Multiple Columns<\/a><\/li>\n<li><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/xlookup-vs-vlookup\/\" target=\"_blank\" rel=\"noopener\">XLOOKUP vs VLOOKUP: Top 5 Comparison of Excel Lookup Functions<\/a><\/li>\n<\/ul>\n<style>.special-box a { color: #fff; } <\/style><div class=\"drop-shadow lifted special-box\" style=\"text-align: center; color: #fff; padding: 15px; background: var(--V4-primary-orange); border-radius: 6px;\">&#x1f449; <strong><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/100-43.html\" target=\"_blank\" rel=\"noopener noreferrer\">Click Here To Join Our Free Formulas &amp; Functions Webinar Training on VLOOKUP, IF, SUMIF &amp; INDEX\/MATCH &amp; Advance Your Excel Level!<\/a><\/strong><\/div>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>VLOOKUP Formula Syntax What does it do? Searches for a value in the first column of a table array and returns a value in the same row from another column (to the right) in the table array. Formula breakdown: =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]) What it means: =VLOOKUP(this value, in this list, and get me value [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":18777,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cos_headline_score":0,"cos_seo_score":0,"cos_headline_text":"","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[3,11,276],"tags":[43,44],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/186"}],"collection":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/comments?post=186"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/186\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/18777"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=186"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=186"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=186"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}