{"id":42840,"date":"2024-04-18T18:47:39","date_gmt":"2024-04-18T16:47:39","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=42840"},"modified":"2024-06-11T21:26:47","modified_gmt":"2024-06-11T19:26:47","slug":"ifna-function","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/ifna-function\/","title":{"rendered":"Excel IFNA Function: Your Ultimate Tool for Error Handling"},"content":{"rendered":"<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/04\/Ifna-function.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-43269 size-large\" title=\"Ifna function\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/04\/Ifna-function-1024x576.png\" alt=\"Ifna function\" width=\"640\" height=\"360\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/04\/Ifna-function-1024x576.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/04\/Ifna-function-300x169.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/04\/Ifna-function-768x432.png 768w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/04\/Ifna-function-180x100.png 180w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/04\/Ifna-function.png 1280w\" sizes=\"(max-width: 640px) 100vw, 640px\" \/><\/a><br \/>\n<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/free-excel-templates-and-spreadsheets\/\" target=\"_blank\" rel=\"noopener\">Microsoft Excel<\/a>&#8216;s IFNA function acts as a strategic safety net within its suite of error-handling tools, ensuring that your data analysis remains unscathed when confronted with the common #N\/A error. It provides a seamless way to substitute a more meaningful or neutral value in place of errors, maintaining the integrity and clarity of your datasets.<\/p>\n<p><strong>Key Takeaways:<\/strong><\/p>\n<ul>\n<li>Targeted Error Handling: IFNA specifically addresses #N\/A errors, allowing for precise error management in formulas.<\/li>\n<li>Syntax Simplicity: Use IFNA by specifying the value to check and the replacement for an #N\/A error using IFNA(value, value_if_na).<\/li>\n<li>Integration with VLOOKUP: Pair IFNA with VLOOKUP to handle missing data gracefully, replacing potential #N\/A errors with a predefined alternative.<\/li>\n<li>Comparison with IFERROR: Choose IFNA for #N\/A errors for specificity or IFERROR for a broader error catchment, depending on your needs.<\/li>\n<li>Alternatives for Broader Errors: Explore other functions like ISERROR or ISERR when expecting a range of error types, allowing for more tailored error handling strategies.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<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\/ifna-function\/#Introduction_to_IFNA_in_Excel\" title=\"Introduction to IFNA in Excel\">Introduction to IFNA in Excel<\/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\/ifna-function\/#The_Anatomy_of_the_IFNA_Function\" title=\"The Anatomy of the IFNA Function\">The Anatomy of the IFNA Function<\/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\/ifna-function\/#Practical_IFNA_Applications\" title=\"Practical IFNA Applications\">Practical IFNA Applications<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/ifna-function\/#Comparing_IFNA_with_Its_Cousins\" title=\"Comparing IFNA with Its Cousins\">Comparing IFNA with Its Cousins<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/ifna-function\/#Frequently_Asked_Questions_FAQs\" title=\"Frequently Asked Questions (FAQs)\">Frequently Asked Questions (FAQs)<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"Introduction_to_IFNA_in_Excel\"><\/span>Introduction to IFNA in Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3>Navigating Through Excel&#8217;s Error Handling Functions<\/h3>\n<p>Diving into Excel&#8217;s vast functionality, you&#8217;ll discover a suite of error-handling tools designed to make your data analysis as smooth as sailing. They\u2019ve put a safety net under your data circus, ensuring that if your formulas walk the tightrope and fall, there\u2019s a way to catch them gracefully.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"IFNA in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/04\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia640852162024-04-14T123A083A31.668744_Excel_Tricks_IFNA_Function_Simplified_for_Beginners_-13.png\" alt=\"IFNA in Excel\" width=\"768\" height=\"311\" \/><\/p>\n<h3>What is IFNA function?<\/h3>\n<p>The IFNA function is like having a plan B in place, standing ready for those moments when Excel stumbles upon the notorious #N\/A error\u2014a signal that a value is not available. It&#8217;s a clever way to ensure that, instead of an error message that could throw your <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/category\/analysis\/\" target=\"_blank\" rel=\"noopener\">data analysis<\/a> off-track, you get a predefined substitute that keeps everything on the right path. Introduce IFNA into your spreadsheet, and you\u2019ll find it a reliable ally in maintaining data integrity and clarity.<\/p>\n<h2><\/h2>\n<h2><span class=\"ez-toc-section\" id=\"The_Anatomy_of_the_IFNA_Function\"><\/span>The Anatomy of the IFNA Function<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3>Understanding the IFNA Syntax<\/h3>\n<p>Getting to grips with the IFNA function syntax is like learning a simple magic spell for your data woes. The formula follows a straightforward structure: <code>IFNA(value, value_if_na)<\/code>.<\/p>\n<p>You cast this spell by specifying two things \u2013 the value you\u2019re scrutinizing <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/run-time-error-1004-in-excel\/\" target=\"_blank\" rel=\"noopener\">for the sneaky #N\/A error<\/a> and the value you wish to summon in its place if that error arises. It&#8217;s as if you&#8217;re saying to Excel, \u201cIf this turns out to be an error, here\u2019s what I\u2019d like you to do instead.\u201d<\/p>\n<h3>Parameters Explained for Clarity<\/h3>\n<p>The IFNA function smoothly operates with just two simple components under its hood:<\/p>\n<ul>\n<li><code>value<\/code>: This is the formula you need evaluated \u2013 the trick you&#8217;re undertaking that might end in an #N\/A error. Think of it as the conjuring part of a magic act, where something might just disappear.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"IFNA in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/04\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia640852162024-04-14T123A083A55.075328_Excel_Tricks_IFNA_Function_Simplified_for_Beginners_-14.png\" alt=\"IFNA in Excel\" width=\"770\" height=\"334\" \/><\/p>\n<ul>\n<li><code>value_if_na<\/code>: This is your safety net \u2013 the alternative result you want Excel to pull from its hat if the <code>value<\/code> turns out to be #N\/A. It\u2019s the comforting presence that ensures your performance never falters.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"IFNA in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/04\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia640852162024-04-14T123A093A15.182722_Excel_Tricks_IFNA_Function_Simplified_for_Beginners_-15.png\" alt=\"IFNA in Excel\" width=\"767\" height=\"332\" \/><\/p>\n<p>Think of these parameters as partners in a dance, where one takes a bold step and the other gracefully follows if the first one stumbles.<\/p>\n<h2><\/h2>\n<h2><span class=\"ez-toc-section\" id=\"Practical_IFNA_Applications\"><\/span>Practical IFNA Applications<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3>Combining IFNA with VLOOKUP for Seamless Lookups<\/h3>\n<p>Integrating IFNA with VLOOKUP is like equipping your lookup missions with a safety harness. When your usual <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/category\/formulas\/lookup\/vlookup\/\" target=\"_blank\" rel=\"noopener\">VLOOKUP formula<\/a> is sent out to match data across tables, wrap it in the embrace of an IFNA. This two-step combo ensures that if VLOOKUP draws a blank and #N\/A appears, IFNA will cover for it, presenting a cleaner, alternative result of your choice instead of an error.<\/p>\n<p>Let&#8217;s say you have a dataset in Excel with two columns: A for Product Names and B for their corresponding Prices. You want to look up the price of a product, but if the product is not found in the list, you want Excel to return &#8220;Product not found&#8221; instead of showing the #N\/A error. Here&#8217;s how to use it with a dataset of product names and prices:<\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 1:<\/span> <\/strong>Select a Cell: Choose where you want the result.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"IFNA in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/04\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia640852162024-04-14T103A573A39.180920_Excel_Tricks_IFNA_Function_Simplified_for_Beginners_-2.png\" alt=\"IFNA in Excel\" width=\"847\" height=\"354\" \/><\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 2: <\/strong><\/span>Enter Formula: Type &#8220;=IFNA(&#8221; and insert a formula, like VLOOKUP or INDEX\/MATCH, referencing your dataset: &#8220;=VLOOKUP(A2, A:B, 2, FALSE)&#8221;.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"IFNA in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/04\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia640852162024-04-14T103A573A55.271486_Excel_Tricks_IFNA_Function_Simplified_for_Beginners_-3.png\" alt=\"IFNA in Excel\" width=\"803\" height=\"703\" \/><\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 3: <\/strong><\/span>Close Formula: Add &#8220;, &#8221; then specify a value to display if the formula returns #N\/A, like &#8220;Product not found&#8221;. Close the formula with &#8220;)&#8221; and press Enter.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"IFNA in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/04\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia640852162024-04-14T103A583A05.285103_Excel_Tricks_IFNA_Function_Simplified_for_Beginners_-4.png\" alt=\"IFNA in Excel\" width=\"941\" height=\"387\" \/><\/p>\n<p>Not only does this partnership maintain the aesthetic of your data, but it also can navigate sequential or chained lookups across different sheets, working like a relay race where IFNA hands off the search to the next VLOOKUP, until there are no more lookups or, voila, a match is found!<\/p>\n<h2><\/h2>\n<h2><span class=\"ez-toc-section\" id=\"Comparing_IFNA_with_Its_Cousins\"><\/span>Comparing IFNA with Its Cousins<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3>IFNA vs. IFERROR: Choosing the Right Tool<\/h3>\n<p>Imagine you\u2019re choosing tools from a toolbox \u2013 IFNA and <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/excel-iferror-function\/\" target=\"_blank\" rel=\"noopener\">IFERROR <\/a>each have their specific uses. Choose IFNA when you want to deal exclusively with the #N\/A error, giving you the precision akin to using a scalpel\u2014ideal for fine-tuning your data when you&#8217;re certain that #N\/A is the only hiccup possible.<\/p>\n<p>On the other hand, IFERROR is the Swiss Army knife, catching <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/highlight-all-errors-using-macros-in-excel\/\" target=\"_blank\" rel=\"noopener\">all types of errors<\/a> without discrimination. This could be perfect when you want to cast a wider safety net, especially when various errors could pop up, and you\u2019d rather have a general fix ready.<\/p>\n<p>Let\u2019s take an example when calculating the cost-per-item and anticipating potential division errors due to items not being shipped, IFERROR can be employed to gracefully manage these situations. Unlike IFNA, which specifically targets the #N\/A error, IFERROR handles any type of error, including division errors. By incorporating IFERROR into the formula, such as &#8220;=IFERROR(Cost\/Items, &#8220;Pending&#8221;)&#8221;, Excel will display &#8220;Pending&#8221; whenever a division error occurs, effectively mitigating the risk of encountering disruptive errors in the cost-per-item calculation.<\/p>\n<p><span style=\"color: #ff0000\"><strong>CASE 1:<\/strong><\/span> The IFNA function can only handle NA errors and not any other types of errors like <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/div-error-in-excel\/\" target=\"_blank\" rel=\"noopener\">#DIV\/0!<\/a>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"IFNA in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/04\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia640852162024-04-14T103A583A26.095149_Excel_Tricks_IFNA_Function_Simplified_for_Beginners_-7.png\" alt=\"IFNA in Excel\" width=\"766\" height=\"352\" \/><\/p>\n<p><strong><span style=\"color: #ff0000\">CASE 2:<\/span> <\/strong>The below shows how the division error can be mitigated by using IFERROR function.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"IFNA in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/04\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia640852162024-04-14T103A583A54.398639_Excel_Tricks_IFNA_Function_Simplified_for_Beginners_-8.png\" alt=\"IFNA in Excel\" width=\"1079\" height=\"408\" \/><\/p>\n<p>Deciding between the two hinges on the particular errors you&#8217;re expecting to encounter. If you\u2019re looking for a focused solution, IFNA is your go-to, whereas, for a more all-encompassing approach, IFERROR stands out.<\/p>\n<h3><\/h3>\n<h3>Alternatives to IFNA for Different Situations<\/h3>\n<p>If IFNA doesn&#8217;t quite fit your scenario, fret not \u2013 Excel offers a smorgasbord of alternatives for different error-handling appetites. For pre-2013 Excel enthusiasts, knitting together IF with ISNA mimics IFNA&#8217;s functionality, catching those #N\/A errors with a homemade feel. When your data forecast predicts a broader range of errors, IFERROR might be the umbrella you need.<\/p>\n<p>In the context of the cost-per-item calculation where division errors might occur due to items not being shipped, utilizing the <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/iserror-formula-in-excel\/\" target=\"_blank\" rel=\"noopener\">ISERROR<\/a> or ISERR functions provides more precise control over error handling. Unlike IFERROR, which handles any type of error generically, ISERROR and ISERR allow for specific identification and treatment of division errors. Here&#8217;s how they could be integrated into the formula:<\/p>\n<p>=IF(ISERROR(Cost\/Items), &#8220;Pending&#8221;, Cost\/Items)<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"IFNA in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/04\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia640852162024-04-14T103A593A11.055705_Excel_Tricks_IFNA_Function_Simplified_for_Beginners_-9.png\" alt=\"IFNA in Excel\" width=\"950\" height=\"387\" \/><\/p>\n<p>Alternatively,<\/p>\n<p>=IF(ISERR(Cost\/Items), &#8220;Pending&#8221;, Cost\/Items)<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"IFNA in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/04\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia640852162024-04-14T103A593A25.384252_Excel_Tricks_IFNA_Function_Simplified_for_Beginners_-10.png\" alt=\"IFNA in Excel\" width=\"1060\" height=\"381\" \/><\/p>\n<p>This formula checks if the division operation results in an error. If it does, &#8220;Pending&#8221; is displayed; otherwise, the cost-per-item is calculated and shown. ISERR can also be used similarly, but it&#8217;s slightly less inclusive than ISERROR, excluding some less critical errors.<\/p>\n<p>For more granular control, tapping into ISERROR or ISERR could be akin to choosing the manual gears over an automatic transmission, giving you the chance to address specific error types individually.<\/p>\n<p>And for the lovers of pristine data who prefer warnings over substitutions, <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/category\/analysis\/conditional-formatting\/\" target=\"_blank\" rel=\"noopener\">conditional formatting<\/a> offers a visual flare that highlights rather than hides errors.<\/p>\n<p>Every tool has its moment to shine &#8211; it&#8217;s all about having the wisdom to choose the appropriate one for the task at hand.<\/p>\n<h2><\/h2>\n<h2><span class=\"ez-toc-section\" id=\"Frequently_Asked_Questions_FAQs\"><\/span>Frequently Asked Questions (FAQs)<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3>Q: What is the difference between ISNA and IFNA?<\/h3>\n<p>A: ISNA detects the #N\/A error in Excel and returns &#8220;TRUE&#8221; if found, otherwise it&#8217;s &#8220;FALSE&#8221;. IFNA catches the same error but lets you replace it with a value you choose, for clearer data presentation. ISNA is the lookout, while IFNA is both the lookout and the problem solver.<\/p>\n<h3>Q: How to use IFNA with VLOOKUP?<\/h3>\n<p>A: To use IFNA with VLOOKUP, nest your VLOOKUP formula inside an IFNA function like this: <code>=IFNA(VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]), \"Custom Error Message\")<\/code>. This way, if VLOOKUP returns #N\/A, IFNA will show your custom message instead.<\/p>\n<h3>How do I use the IFNA function in Excel?<\/h3>\n<p>A: Use the <a href=\"https:\/\/support.microsoft.com\/en-gb\/office\/ifna-function-6626c961-a569-42fc-a49d-79b4951fd461\" target=\"_blank\" rel=\"nofollow noopener\">IFNA function<\/a> in Excel by writing <code>=IFNA(value, value_if_na)<\/code> in a cell, where <code>value<\/code> is the expression you&#8217;re examining, and <code>value_if_na<\/code> is what you want to show if Excel finds an #N\/A error in <code>value<\/code>.<\/p>\n<h3>How do I use Vlookup and IFNA together?<\/h3>\n<p>A: Combine VLOOKUP and IFNA by enclosing the VLOOKUP function inside IFNA: <code>=IFNA(VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]), \"Alternate Value\")<\/code>. This provides an error-free result if VLOOKUP encounters an #N\/A error.<\/p>\n<h3>What if IFNA is an empty cell in Excel?<\/h3>\n<p>A: If the <code>value<\/code> or <code>value_if_na<\/code> in an IFNA function is an empty cell, Excel treats it as an empty string (&#8220;&#8221;). So, <code>=IFNA(A1, B1)<\/code> would return an empty string if A1 or B1 are empty and A1 has an #N\/A error.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Unlock Excel proficiency with IFNA! Learn to handle errors like a pro with our tips on IFNA function, VLOOKUP integration, and best practices.<\/p>\n","protected":false},"author":1,"featured_media":43269,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cos_headline_score":0,"cos_seo_score":0,"cos_headline_text":"Excel IFNA Function: Your Ultimate Tool for Error Handling","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[10],"tags":[2407,2406,2404,2405],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/42840"}],"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=42840"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/42840\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/43269"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=42840"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=42840"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=42840"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}