{"id":5857,"date":"2025-07-04T07:50:44","date_gmt":"2025-07-04T07:50:44","guid":{"rendered":"https:\/\/www.repairmsexcel.com\/blog\/?p=5857"},"modified":"2025-07-08T15:30:55","modified_gmt":"2025-07-08T15:30:55","slug":"vlookup-not-working","status":"publish","type":"post","link":"https:\/\/www.repairmsexcel.com\/blog\/vlookup-not-working","title":{"rendered":"Why is VLOOKUP Not Working in Excel? Get Fixes Here!"},"content":{"rendered":"<div class=\"1898181a2aebca931198b7f41678d855\" data-index=\"1\" style=\"float: none; margin:0px 0 0px 0; text-align:center;\">\n<style>\r\n.leaderboard { width: 320px; height: 100px; }\r\n@media(min-width: 500px) { .leaderboard { width: 468px; height: 60px; } }\r\n@media(min-width: 800px) { .leaderboard { width: 728px; height: 90px; } }\r\n<\/style>\r\n<script async src=\"https:\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js?client=ca-pub-8329139124199643\" crossorigin=\"anonymous\"><\/script>\r\n<ins class=\"adsbygoogle leaderboard\"\r\n     style=\"display:inline-block\"\r\n\t data-full-width-responsive=\"true\"\r\n     data-ad-client=\"ca-pub-8329139124199643\"\r\n     data-ad-slot=\"1972481166\"><\/ins>\r\n<script>\r\n     (adsbygoogle = window.adsbygoogle || []).push({});\r\n<\/script>\n<\/div>\n<p style=\"text-align: justify;\"><strong>VLOOKUP<\/strong> (Vertical Lookup) is an excellent function that searches for an exact value in a first column of the table &amp; returns a corresponding value from another column in a same row. But sometimes, you may face a situation where this function fails to work. In such a case, fixing this problem for a seamless spreadsheet experience is important. Well, this blog explores the most common reasons <strong>why VLOOKUP not working <\/strong>and how to fix it quickly.<\/p>\n<p style=\"text-align: justify;\"><!--more--><\/p>\n<div style='margin: 8px 0; clear: both;'><div style='background: #eafdeb; padding: 12px;'><p><strong style='font-size: 18px;'>To recover lost Excel data, we recommend this tool:<\/strong><\/p><p style='font-size: 17px;'>This software will prevent Excel workbook data such as BI data, financial reports & other analytical information from corruption and data loss. With this software you can rebuild corrupt Excel files and restore every single visual representation & dataset to its original, intact state in 3 easy steps:<\/p><div><ol style='font-size: 17px; margin-top: 4px;'><li><strong><a href='https:\/\/www.repairmsexcel.com\/blog\/free-download-now' target='_blank'>Try Excel File Repair Tool<\/a><\/strong> rated <i>Excellent<\/i> by Softpedia, Softonic & CNET.<\/li><li>Select the corrupt Excel file (XLS, XLSX) & click <b>Repair<\/b> to initiate the repair process.<\/li><li>Preview the repaired files and click <b>Save File<\/b> to save the files at desired location.<\/li><\/ol><\/div><\/div><\/div><br>\n<h2 style=\"text-align: justify;\"><strong>Why Is My VLOOKUP Not Working?<\/strong><\/h2>\n<p style=\"text-align: justify;\">In this section, you will get an answer to this very important question why is VLookup not working. So, check out the 7 most common reasons for VLOOKUP not working in Excel 2007\/2010\/2013\/2016\/2019.<\/p>\n<p style=\"text-align: justify;\">Have a look&#8230;<\/p>\n<ul style=\"text-align: justify;\">\n<li><strong><a href=\"#a1\">VLOOKUP Can\u2019t Find Value<\/a><\/strong><\/li>\n<li><strong><a href=\"#a2\">Table Reference Is Locked<\/a><\/strong><\/li>\n<li><strong><a href=\"#a3\">Column Insertion<\/a><\/strong><\/li>\n<li><strong><a href=\"#a4\">Oversized Table<\/a><\/strong><\/li>\n<li><strong><a href=\"#a5\">VLOOKUP Cannot Look To Its Left<\/a><\/strong><\/li>\n<li><strong><a href=\"#a6\">Not Getting The Exact Match<\/a><\/strong><\/li>\n<li><strong><a href=\"#a7\">Excel Table Has Duplicate Values<\/a><\/strong><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><a name=\"a1\"><\/a><\/p>\n<h3 style=\"text-align: justify;\"><strong>Reason 1# VLOOKUP Can\u2019t Find Value<\/strong><\/h3>\n<p style=\"text-align: justify;\">Excel user who all are using <strong>VLOOKUP, MATCH,<\/strong>\u00a0or <strong>HLOOKUP<\/strong> functions every now and then encountered some unexpected #<strong>N\/A error.<\/strong><\/p>\n<p style=\"text-align: justify;\">Usually, this error encounters when anyone tries to match the Excel lookup value within the array. It\u2019s a clear sign that your Excel function has been failed to fetch lookup value from the lookup array.<\/p>\n<p style=\"text-align: justify;\">What will you do if you will see that the exact matching value is there in the lookup array but your excel application is unable to find that value?<\/p>\n<p style=\"text-align: justify;\">Suppose: if in the shown Excel spreadsheet, lookup function is applied. You want to look up the value<strong> &#8220;1110004&#8221;<\/strong> of the cell to get a match with the value <strong>&#8220;1110004&#8221;<\/strong> present in cell E6.<\/p>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-2896 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/01\/fail_to_match_values.png\" alt=\"N\/A - Lookup Failure Error\" width=\"421\" height=\"187\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/01\/fail_to_match_values.png 421w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/01\/fail_to_match_values-300x133.png 300w\" sizes=\"auto, (max-width: 421px) 100vw, 421px\" \/><\/p>\n<p style=\"text-align: justify;\">In this case, if the Excel function fails to fetch the match or showing error #N\/A error. The VLOOKUP function is a popular lookup and reference function of Excel. It will show a tricky and dreaded #N\/A error message. It may happen because Excel is not considering the two values exactly the same.<\/p>\n<p style=\"text-align: justify;\"><a name=\"a2\"><\/a><\/p>\n<h3 style=\"text-align: justify;\"><strong>Reason 2# <\/strong><strong>Table Reference Is Locked<\/strong><\/h3>\n<p style=\"text-align: justify;\">If you are using multiple VLOOKUPs in excel to catch different information about any particular record. or if in case you are willing to copy off your VLOOKUP to several of your cells then you have to check your table.<\/p>\n<p style=\"text-align: justify;\">The below-shown image shows that the VLOOKUP entered over here is incorrect. The incorrect cell ranges are referenced for the <em>lookup_value<\/em>\u00a0and table array.<\/p>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-552\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/01\/unlocked_table_resized2.png\" alt=\"unlocked_table_resized2\" width=\"640\" height=\"202\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/01\/unlocked_table_resized2.png 640w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/01\/unlocked_table_resized2-300x95.png 300w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/><\/p>\n<h4 style=\"text-align: justify;\"><strong>Solution<\/strong><\/h4>\n<p style=\"text-align: justify;\">The table which is used by VLOOKUP function actually searches for and gives information is called as<em>table_array<\/em>. This is required to get referenced completely in order to copy your VLOOKUP.<\/p>\n<p style=\"text-align: justify;\">So, click on the references which are right inside the formula and after then press the F4 key on your keyboard to modify the reference from <strong>relative to absolute<\/strong>. So,\u00a0 enter the formula\u00a0 as=<strong>VLOOKUP($H$3,$B$3:$F$11,4,FALSE)<\/strong>.<\/p>\n<p style=\"text-align: justify;\">In this example, both the <em>lookup_value<\/em>\u00a0and\u00a0<em>table_array<\/em> references made were absolute. Basically, it may be the <em>table_array that needs locking.<\/em><\/p>\n<blockquote>\n<p style=\"text-align: left;\"><strong><span style=\"color: #ff0000;\">Also Read<\/span>: <\/strong><strong><a href=\"https:\/\/www.repairmsexcel.com\/blog\/end-mode-excel-not-working\">Why Does End Mode Excel Not Working? \u2013 Get Fixes Here!<\/a><\/strong><\/p>\n<\/blockquote>\n<p style=\"text-align: justify;\"><a name=\"a3\"><\/a><\/p>\n<h3 style=\"text-align: justify;\"><strong>Reason 3# <\/strong><strong>Column Insertion<\/strong><\/h3>\n<p style=\"text-align: justify;\">The column index number or <em>col_index_num<\/em> is used by the VLOOKUP function in order to enter information to return a record.<\/p>\n<p style=\"text-align: justify;\">Because this is entered as an index number, and it is not that durable. If a column is put down in the table, then <strong>vlookup is not working<\/strong> as this stops VLOOKUP from working. Here is the image is shown below for a scenario.<\/p>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-550\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/01\/inserted_column_resized3.png\" alt=\"inserted column resized3\" width=\"640\" height=\"275\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/01\/inserted_column_resized3.png 640w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/01\/inserted_column_resized3-300x129.png 300w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/><\/p>\n<p style=\"text-align: justify;\">The whole content is in column 3, but after the insertion of the new column, it became column 4. \u00a0However, the VLOOKUP has not automatically updated.<\/p>\n<h4 style=\"text-align: justify;\"><strong>Solution<\/strong> 1<\/h4>\n<p style=\"text-align: justify;\">One solution you can try to save your worksheet so any other user can\u2019t insert columns. If the user requires to do so, then it&#8217;s not a valid solution.<\/p>\n<h4 style=\"text-align: justify;\"><strong>Solution<\/strong> 2<\/h4>\n<p style=\"text-align: justify;\">Another option is to insert the <strong>MATCH<\/strong> function within the <strong><em>col_index_num<\/em>\u00a0argument<\/strong> of VLOOKUP.<\/p>\n<p style=\"text-align: justify;\">The <strong>MATCH<\/strong> function can be used to search for something or returning the required column number. This will; makes the <em>col_index_num dynamic so that the inserted <\/em>columns won&#8217;t affect the VLOOKUP.<\/p>\n<p style=\"text-align: justify;\">The formula given below needs to be entered within this example to avoid the above-mentioned problem.<\/p>\n<p style=\"text-align: justify;\"><a name=\"a4\"><\/a><\/p>\n<h3 style=\"text-align: justify;\"><strong>Reason 4# <\/strong><strong>Oversized Table<\/strong><\/h3>\n<p style=\"text-align: justify;\">When more rows get added to the table, VLookup requires to get updated. Below given image shows that VLookup doesn\u2019t check complete table fruit items.<\/p>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-554\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/01\/increased_range_resized4.png\" alt=\"increased range resized4\" width=\"640\" height=\"215\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/01\/increased_range_resized4.png 640w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/01\/increased_range_resized4-300x101.png 300w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/><\/p>\n<h4 style=\"text-align: justify;\"><strong>Solution<\/strong><\/h4>\n<p style=\"text-align: justify;\">You can consider the formatting range as a dynamic range name or table (Excel 2007+). This process ensures that VLookup will look over the complete of your table.<\/p>\n<p style=\"text-align: justify;\">In order to format the range as a table, choose the cell range that you want to use for <em>table_array. After then<\/em> tap to the\u00a0<strong>Home\u00a0<\/strong>&gt;\u00a0<strong>Format as Table\u00a0<\/strong>and choose any one style from the gallery section. Tap to the <strong>Design\u00a0<\/strong>tab\u00a0<strong>present within\u00a0Table\u00a0Tools\u00a0and then change\u00a0the table\u00a0name\u00a0in the given box.<\/strong><\/p>\n<p style=\"text-align: justify;\">The VLOOKUP below shows a table named\u00a0<em>FruitList\u00a0<\/em>being used.<\/p>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-553\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/01\/using_table_resized5.png\" alt=\"using table resized5\" width=\"640\" height=\"249\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/01\/using_table_resized5.png 640w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/01\/using_table_resized5-300x117.png 300w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/><\/p>\n<p style=\"text-align: justify;\"><a name=\"a5\"><\/a><\/p>\n<h3 style=\"text-align: justify;\"><strong>Reason 5# VLOOKUP Can&#8217;t Look On It&#8217;s Left<\/strong><\/h3>\n<p style=\"text-align: justify;\">The limitation of the VLOOKUP function is that it can\u2019t look at its left. This will appear at the left-most column of a table and return information from the right.<\/p>\n<h4 style=\"text-align: justify;\"><strong>Solution<\/strong><\/h4>\n<p style=\"text-align: justify;\">The solution to fix the VLOOKUP not working issue is not to use VLOOKUP at all. You can use the combination of\u00a0 <strong>INDEX<\/strong> and <strong>MATCH <\/strong>Excel function as an alternative for VLOOKUP.<\/p>\n<p style=\"text-align: justify;\">The below given example is to show what information is returned to the left of the column you are looking in.<\/p>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-549\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/01\/index_and_match_resized6.png\" alt=\"index and match resized6\" width=\"640\" height=\"340\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/01\/index_and_match_resized6.png 640w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/01\/index_and_match_resized6-300x159.png 300w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/><\/p>\n<p style=\"text-align: justify;\"><a name=\"a6\"><\/a><\/p>\n<h3 style=\"text-align: justify;\"><strong>Reason 6# <\/strong><strong>Not Getting The Exact Match<\/strong><\/h3>\n<p style=\"text-align: justify;\">In the ending argument of VLOOKUP function, well known as <em>range_lookup<\/em>, you can search for the approximate or an exact match.<\/p>\n<p style=\"text-align: justify;\">In most cases, users look for a particular product order, employee or customer and therefore require and an exact match. if you are searching for any unique value, enter <strong>FALSE<\/strong> for the <em>range_lookup<\/em>\u00a0argument.<\/p>\n<p style=\"text-align: justify;\">This one is optional, but if it is left unfilled then the <strong>TRUE<\/strong> value must be used.\u00a0 The TRUE value relies on your data is sorted in order to work.<\/p>\n<p style=\"text-align: justify;\">The Below shown figure will show a VLOOKUP with the range_lookup argument omitted and the incorrect value being returned.<\/p>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-551\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/01\/no_false_resized1.png\" alt=\"no false resized1\" width=\"640\" height=\"343\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/01\/no_false_resized1.png 640w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/01\/no_false_resized1-300x161.png 300w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/><\/p>\n<h4 style=\"text-align: justify;\"><strong>Solution<\/strong><\/h4>\n<p style=\"text-align: justify;\">If looking for some unique value then enter <strong>FALSE<\/strong> value for the ending argument. The VLOOKUP must be entered like <strong>=VLOOKUP(H3,B3: F11,2,FALSE)<\/strong>.<\/p>\n<p style=\"text-align: justify;\">This is the first reason behind the<strong> VLookup not working <\/strong>in Excel.<\/p>\n<p style=\"text-align: justify;\"><a name=\"a7\"><\/a><\/p>\n<h3 style=\"text-align: justify;\"><strong>Reason 7# Excel Table Has Duplicate Values<\/strong><\/h3>\n<p style=\"text-align: justify;\">Excel VLOOKUP function is limited to return only one record. \u00a0It gives 1<sup>st<\/sup> record that matches the value you are searching for.<\/p>\n<p style=\"text-align: justify;\">If your Excel table is having some duplicates then VLOOKUP fails to perform this task.<\/p>\n<p style=\"text-align: justify;\"><strong>Solution<\/strong><\/p>\n<p style=\"text-align: justify;\">In the shown list some duplicates values are present. In this case, VLOOKUP is not the right choice to use. PivotTable is the perfect option to choose the value and then listing out the result.<\/p>\n<p style=\"text-align: justify;\">Below shown table is to shows a list of orders. Suppose you are willing to return the entire order of any specific fruit.<\/p>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-5850 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/01\/excel-vlookup-not-working.png\" alt=\"excel vlookup not working\" width=\"589\" height=\"349\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/01\/excel-vlookup-not-working.png 589w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/01\/excel-vlookup-not-working-300x178.png 300w\" sizes=\"auto, (max-width: 589px) 100vw, 589px\" \/><\/p>\n<p style=\"text-align: justify;\">PivotTable allows you to choose the Fruit ID from the report filter and the list of all orders starts appearing.<\/p>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-5849 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/01\/excel-vlookup-not-working-1.png\" alt=\"excel vlookup not working 1\" width=\"605\" height=\"448\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/01\/excel-vlookup-not-working-1.png 605w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/01\/excel-vlookup-not-working-1-300x222.png 300w\" sizes=\"auto, (max-width: 605px) 100vw, 605px\" \/><\/p>\n<h2 style=\"text-align: left;\"><strong>Automatic Solution: MS Excel Repair Tool<\/strong><\/h2>\n<p style=\"text-align: justify;\">The given manual solution will surely fix your Excel file issues and errors. But if in case you are caught in any other corruption glitches or damaged file issues, then make use of the <strong><a href=\"https:\/\/www.repairmsexcel.com\/download-excel-repair.php\" target=\"_blank\" rel=\"noopener\">MS Excel Repair Tool<\/a>. <\/strong>It is the best-suited software for restoring the corrupt Excel files and also for the retrieval of data from Excel worksheets like cell comments, charts, worksheet properties, and other stuff. It&#8217;s a professionally designed program that easily <strong><a href=\"https:\/\/www.repairmsexcel.com\/blog\/13-ways-to-repair-corrupt-excel-file\">repairs .xls and .xlsx files<\/a>.<\/strong><\/p>\n<p style=\"text-align: justify;\"><center><div style='margin: 5px 15px 15px 0;'><a style='background: #3bc949; border-radius: 25px; color: #ffffff; cursor: pointer; display: inline-block; font-size: 20px; font-weight: 500; padding: 2px 20px; height: 40px; line-height: 40px; vertical-align: middle; white-space: nowrap; text-decoration: none; border: none;' href='https:\/\/www.repairmsexcel.com\/blog\/free-download-now' target='_blank'><span style='color: #ffffff;'><i class='fab fa-windows'><\/i><\/span> Try Now<\/a> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<a style='background: #FAB152; border-radius: 25px; color: #ffffff; cursor: pointer; display: inline-block; font-size: 20px; font-weight: 500; padding: 2px 20px; height: 40px; line-height: 40px; vertical-align: middle; white-space: nowrap; text-decoration: none; border: none;' href='https:\/\/www.repairmsexcel.com\/blog\/buy-now' target='_blank'><span style='color: #ffffff;'><i class='fas fa-cart-plus'><\/i><\/span> Buy Now<\/a><\/div><div style='margin: 5px 0 10px 0; font-size: 13px;'><font color='red'>*<\/font> Free version of the product only previews recoverable data.<\/div><\/center>\n<h3 style=\"text-align: left;\"><strong>Steps to Utilize MS Excel Repair Tool:<\/strong><\/h3>\n<p style=\"text-align: justify;\">\n<blockquote>\n<p style=\"text-align: left;\"><strong><span style=\"color: #ff0000;\">Also Read<\/span>: <\/strong><strong><a href=\"https:\/\/www.repairmsexcel.com\/blog\/repair-microsoft-excel-2016-autosave-not-working\">AutoSave Not Working in Excel? 7 Ways to Fix It!<\/a><\/strong><\/p>\n<\/blockquote>\n<h2 style=\"text-align: left;\"><strong>Best Practices to Avoid VLOOKUP Issues<\/strong><\/h2>\n<p>Follow these precautionary measures to evade trouble in the future.<\/p>\n<ol>\n<li>Use exact match unless necessary.<\/li>\n<li>Always clean your data before applying formulas.<\/li>\n<li>Validate column index numbers regularly.<\/li>\n<li>Test your formulas with known values.<\/li>\n<li>Lock your table array with $ signs.<\/li>\n<\/ol>\n<h2 style=\"text-align: left;\"><strong>Related FAQs:<\/strong><\/h2>\n        <section class=\"sc_fs_faq sc_card \">\n            <div>\n\t\t\t\t<h3>Why Does My VLOOKUP Show NA When Value Exists?<\/h3>                <div>\n\t\t\t\t\t                    <p>\n\t\t\t\t\t\tIf your lookup column holds text values but your search query is formatted as numeric values, VLOOKUP show #N\/A error.                    <\/p>\n                <\/div>\n            <\/div>\n        <\/section>\n\t\t        <section class=\"sc_fs_faq sc_card \">\n            <div>\n\t\t\t\t<h3>How Do I Enable VLOOKUP In Excel?<\/h3>                <div>\n\t\t\t\t\t                    <p>\n\t\t\t\t\t\tTo enable VLOOKUP in Excel, follow the below steps: <ul><li>Click the cell(s) where you need Excel to return a data you are looking for. <\/li><li>Then, <strong>enter =VLOOKUP<\/strong>(lookup value,table array,column index number,range lookup). <\/li><li>Lastly, press <strong>Enter<\/strong>.                     <\/p>\n                <\/div>\n            <\/div>\n        <\/section>\n\t\t        <section class=\"sc_fs_faq sc_card \">\n            <div>\n\t\t\t\t<h3>What Is the Alternative To VLOOKUP?<\/h3>                <div>\n\t\t\t\t\t                    <p>\n\t\t\t\t\t\tXLOOKUP and INDEX\/MATCH are the two recommended alternatives to VLOOKUP.                     <\/p>\n                <\/div>\n            <\/div>\n        <\/section>\n\t\t        <section class=\"sc_fs_faq sc_card \">\n            <div>\n\t\t\t\t<h3>Why Isn&#039;t My VLOOKUP Working #Value?<\/h3>                <div>\n\t\t\t\t\t                    <p>\n\t\t\t\t\t\tVLOOKUP not working #value due to a typo in the col_index_num argument or unintentionally specifying a number less than 1 as the index value                    <\/p>\n                <\/div>\n            <\/div>\n        <\/section>\n\t\t        <section class=\"sc_fs_faq sc_card \">\n            <div>\n\t\t\t\t<h3>How to Make VLOOKUP Work?<\/h3>                <div>\n\t\t\t\t\t                    <p>\n\t\t\t\t\t\tTo make VLOOKUP function working again, follow the below steps. <ul><li>Select a cell ( H4 ) <\/li><li>Then, type =VLOOKUP. <\/li><li>After that, double-click the VLOOKUP command. <\/li><li>Select the cell(s) where search value will be entered ( H3 ) <\/li><li>Type ( , ) <\/li><li>Mark table range ( A2:E21 ) <\/li><li>Type ( , ) <\/li><li>Type the number of the column, counted from the left ( 2 ).                     <\/p>\n                <\/div>\n            <\/div>\n        <\/section>\n\t\t\n<script type=\"application\/ld+json\">\n    {\n\t\t\"@context\": \"https:\/\/schema.org\",\n\t\t\"@type\": \"FAQPage\",\n\t\t\"mainEntity\": [\n\t\t\t\t{\n\t\t\t\t\"@type\": \"Question\",\n\t\t\t\t\"name\": \"Why Does My VLOOKUP Show NA When Value Exists?\",\n\t\t\t\t\"acceptedAnswer\": {\n\t\t\t\t\t\"@type\": \"Answer\",\n\t\t\t\t\t\"text\": \"If your lookup column holds text values but your search query is formatted as numeric values, VLOOKUP show #N\/A error.\"\n\t\t\t\t\t\t\t\t\t}\n\t\t\t}\n\t\t\t,\t\t\t\t{\n\t\t\t\t\"@type\": \"Question\",\n\t\t\t\t\"name\": \"How Do I Enable VLOOKUP In Excel?\",\n\t\t\t\t\"acceptedAnswer\": {\n\t\t\t\t\t\"@type\": \"Answer\",\n\t\t\t\t\t\"text\": \"To enable VLOOKUP in Excel, follow the below steps: &lt;ul&gt;&lt;li&gt;Click the cell(s) where you need Excel to return a data you are looking for. &lt;\/li&gt;&lt;li&gt;Then, <strong>enter =VLOOKUP<\/strong>(lookup value,table array,column index number,range lookup). &lt;\/li&gt;&lt;li&gt;Lastly, press <strong>Enter<\/strong>.\"\n\t\t\t\t\t\t\t\t\t}\n\t\t\t}\n\t\t\t,\t\t\t\t{\n\t\t\t\t\"@type\": \"Question\",\n\t\t\t\t\"name\": \"What Is the Alternative To VLOOKUP?\",\n\t\t\t\t\"acceptedAnswer\": {\n\t\t\t\t\t\"@type\": \"Answer\",\n\t\t\t\t\t\"text\": \"XLOOKUP and INDEX\/MATCH are the two recommended alternatives to VLOOKUP.\"\n\t\t\t\t\t\t\t\t\t}\n\t\t\t}\n\t\t\t,\t\t\t\t{\n\t\t\t\t\"@type\": \"Question\",\n\t\t\t\t\"name\": \"Why Isn't My VLOOKUP Working #Value?\",\n\t\t\t\t\"acceptedAnswer\": {\n\t\t\t\t\t\"@type\": \"Answer\",\n\t\t\t\t\t\"text\": \"VLOOKUP not working #value due to a typo in the col_index_num argument or unintentionally specifying a number less than 1 as the index value\"\n\t\t\t\t\t\t\t\t\t}\n\t\t\t}\n\t\t\t,\t\t\t\t{\n\t\t\t\t\"@type\": \"Question\",\n\t\t\t\t\"name\": \"How to Make VLOOKUP Work?\",\n\t\t\t\t\"acceptedAnswer\": {\n\t\t\t\t\t\"@type\": \"Answer\",\n\t\t\t\t\t\"text\": \"To make VLOOKUP function working again, follow the below steps. &lt;ul&gt;&lt;li&gt;Select a cell ( H4 ) &lt;\/li&gt;&lt;li&gt;Then, type =VLOOKUP. &lt;\/li&gt;&lt;li&gt;After that, double-click the VLOOKUP command. &lt;\/li&gt;&lt;li&gt;Select the cell(s) where search value will be entered ( H3 ) &lt;\/li&gt;&lt;li&gt;Type ( , ) &lt;\/li&gt;&lt;li&gt;Mark table range ( A2:E21 ) &lt;\/li&gt;&lt;li&gt;Type ( , ) &lt;\/li&gt;&lt;li&gt;Type the number of the column, counted from the left ( 2 ).\"\n\t\t\t\t\t\t\t\t\t}\n\t\t\t}\n\t\t\t\t    ]\n}\n<\/script>\n\n<h2 style=\"text-align: left;\"><strong>Final Verdict<\/strong><\/h2>\n<p style=\"text-align: justify;\"><strong>VLOOKUP not working in Microsoft Excel<\/strong> is a frustrating issue, but solvable. However, by identifying the exact cause and applying the targeted fixes specified above, you can fix errors quickly. Clean your data, use exact match, and consider modern alternatives for better results.<\/p>\n<p>Let your spreadsheets work smarter, not harder. I hope, you enjoyed reading this post.<\/p>\n<div class=\"su-note\"  style=\"border-color:#dad9d9;border-radius:2px;-moz-border-radius:2px;-webkit-border-radius:2px;\"><div class=\"su-note-inner su-u-clearfix su-u-trim\" style=\"background-color:#f4f3f3;border-color:#ffffff;color:#333333;border-radius:2px;-moz-border-radius:2px;-webkit-border-radius:2px;\">\n<p style=\"text-align: justify;\"><strong>External References:<\/strong><\/p>\n<ul>\n<li><a href=\"https:\/\/answers.microsoft.com\/en-us\/msoffice\/forum\/all\/vlookup-not-working\/352dcdc3-017e-4a41-ba59-97dd693a7067\" target=\"_blank\" rel=\"noopener\">https:\/\/answers.microsoft.com\/en-us\/msoffice\/forum\/all\/vlookup-not-working\/352dcdc3-017e-4a41-ba59-97dd693a7067<\/a><\/li>\n<\/ul>\n<\/div><\/div>\n<p style=\"text-align: justify;\"><br><center><a href='https:\/\/www.repairmsexcel.com\/blog\/free-download-now' title='Try Excel Repair Now'><img src='https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/08\/729x120-en.png' \/><\/a><\/center><br>\n\n<div style=\"font-size: 0px; height: 0px; line-height: 0px; margin: 0; padding: 0; clear: both;\"><\/div>","protected":false},"excerpt":{"rendered":"<p>VLOOKUP (Vertical Lookup) is an excellent function that searches for an exact value in a first column of the table &#8230; <\/p>\n<p class=\"read-more-container\"><a title=\"Why is VLOOKUP Not Working in Excel? Get Fixes Here!\" class=\"read-more button\" href=\"https:\/\/www.repairmsexcel.com\/blog\/vlookup-not-working#more-5857\" aria-label=\"Read more about Why is VLOOKUP Not Working in Excel? Get Fixes Here!\">Read more<\/a><\/p>\n","protected":false},"author":5,"featured_media":5863,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[42],"tags":[249,1282,1283],"class_list":["post-5857","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-errors","tag-excel-vlookup-not-working","tag-vlookup-not-working-in-excel","tag-why-vlookup-is-not-working","resize-featured-image"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.2 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Why is VLOOKUP Not Working in Excel? Get Fixes Here!<\/title>\n<meta name=\"description\" content=\"Experiencing VLOOKUP not working in Excel? Discover expert tips to troubleshoot the issue fast. Get back into the work hassle-free!\" \/>\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.repairmsexcel.com\/blog\/vlookup-not-working\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Why is VLOOKUP Not Working in Excel? Get Fixes Here!\" \/>\n<meta property=\"og:description\" content=\"Experiencing VLOOKUP not working in Excel? Discover expert tips to troubleshoot the issue fast. Get back into the work hassle-free!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.repairmsexcel.com\/blog\/vlookup-not-working\" \/>\n<meta property=\"og:site_name\" content=\"Excel File Repair Blog\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-04T07:50:44+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-07-08T15:30:55+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/09\/Why-VLOOKUP-Not-Working-in-excel.png\" \/>\n\t<meta property=\"og:image:width\" content=\"550\" \/>\n\t<meta property=\"og:image:height\" content=\"300\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Priyanka Sahu\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Priyanka Sahu\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"9 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/vlookup-not-working#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/vlookup-not-working\"},\"author\":{\"name\":\"Priyanka Sahu\",\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/#\/schema\/person\/ab2250dcc6b25c12e617748b1fc166e3\"},\"headline\":\"Why is VLOOKUP Not Working in Excel? Get Fixes Here!\",\"datePublished\":\"2025-07-04T07:50:44+00:00\",\"dateModified\":\"2025-07-08T15:30:55+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/vlookup-not-working\"},\"wordCount\":1724,\"publisher\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/vlookup-not-working#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/09\/Why-VLOOKUP-Not-Working-in-excel.png\",\"keywords\":[\"Excel VLOOKUP Not Working\",\"vlookup not working in excel\",\"why vlookup is not working\"],\"articleSection\":[\"Excel Errors\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/vlookup-not-working\",\"url\":\"https:\/\/www.repairmsexcel.com\/blog\/vlookup-not-working\",\"name\":\"Why is VLOOKUP Not Working in Excel? Get Fixes Here!\",\"isPartOf\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/vlookup-not-working#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/vlookup-not-working#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/09\/Why-VLOOKUP-Not-Working-in-excel.png\",\"datePublished\":\"2025-07-04T07:50:44+00:00\",\"dateModified\":\"2025-07-08T15:30:55+00:00\",\"description\":\"Experiencing VLOOKUP not working in Excel? Discover expert tips to troubleshoot the issue fast. Get back into the work hassle-free!\",\"breadcrumb\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/vlookup-not-working#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.repairmsexcel.com\/blog\/vlookup-not-working\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/vlookup-not-working#primaryimage\",\"url\":\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/09\/Why-VLOOKUP-Not-Working-in-excel.png\",\"contentUrl\":\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/09\/Why-VLOOKUP-Not-Working-in-excel.png\",\"width\":550,\"height\":300,\"caption\":\"Why VLOOKUP Not Working in excel\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/vlookup-not-working#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.repairmsexcel.com\/blog\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Why is VLOOKUP Not Working in Excel? Get Fixes Here!\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/#website\",\"url\":\"https:\/\/www.repairmsexcel.com\/blog\/\",\"name\":\"Repair MS Excel\",\"description\":\"Get Tips, Tricks and Fixes of MS Excel Issues\",\"publisher\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.repairmsexcel.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/#organization\",\"name\":\"Repair MS Excel\",\"url\":\"https:\/\/www.repairmsexcel.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/06\/repairmsexcel.com-logo.png\",\"contentUrl\":\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/06\/repairmsexcel.com-logo.png\",\"width\":350,\"height\":70,\"caption\":\"Repair MS Excel\"},\"image\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/#\/schema\/person\/ab2250dcc6b25c12e617748b1fc166e3\",\"name\":\"Priyanka Sahu\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/7e53e98dbd92755427e57013018cbed29ee3ae27e0a21f434dbd1ee1ce867558?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/7e53e98dbd92755427e57013018cbed29ee3ae27e0a21f434dbd1ee1ce867558?s=96&d=mm&r=g\",\"caption\":\"Priyanka Sahu\"},\"description\":\"Priyanka is a content marketing expert. She writes tech blogs and has expertise in MS Office, Excel, and other tech subjects. Her distinctive art of presenting tech information in the easy-to-understand language is very impressive. When not writing, she loves unplanned travels.\",\"sameAs\":[\"https:\/\/www.repairmsexcel.com\/\",\"https:\/\/www.linkedin.com\/in\/priyanka-sahu-2794a1242\"],\"url\":\"https:\/\/www.repairmsexcel.com\/blog\/author\/priyanka\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Why is VLOOKUP Not Working in Excel? Get Fixes Here!","description":"Experiencing VLOOKUP not working in Excel? Discover expert tips to troubleshoot the issue fast. Get back into the work hassle-free!","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.repairmsexcel.com\/blog\/vlookup-not-working","og_locale":"en_US","og_type":"article","og_title":"Why is VLOOKUP Not Working in Excel? Get Fixes Here!","og_description":"Experiencing VLOOKUP not working in Excel? Discover expert tips to troubleshoot the issue fast. Get back into the work hassle-free!","og_url":"https:\/\/www.repairmsexcel.com\/blog\/vlookup-not-working","og_site_name":"Excel File Repair Blog","article_published_time":"2025-07-04T07:50:44+00:00","article_modified_time":"2025-07-08T15:30:55+00:00","og_image":[{"width":550,"height":300,"url":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/09\/Why-VLOOKUP-Not-Working-in-excel.png","type":"image\/png"}],"author":"Priyanka Sahu","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Priyanka Sahu","Est. reading time":"9 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.repairmsexcel.com\/blog\/vlookup-not-working#article","isPartOf":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/vlookup-not-working"},"author":{"name":"Priyanka Sahu","@id":"https:\/\/www.repairmsexcel.com\/blog\/#\/schema\/person\/ab2250dcc6b25c12e617748b1fc166e3"},"headline":"Why is VLOOKUP Not Working in Excel? Get Fixes Here!","datePublished":"2025-07-04T07:50:44+00:00","dateModified":"2025-07-08T15:30:55+00:00","mainEntityOfPage":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/vlookup-not-working"},"wordCount":1724,"publisher":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/vlookup-not-working#primaryimage"},"thumbnailUrl":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/09\/Why-VLOOKUP-Not-Working-in-excel.png","keywords":["Excel VLOOKUP Not Working","vlookup not working in excel","why vlookup is not working"],"articleSection":["Excel Errors"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.repairmsexcel.com\/blog\/vlookup-not-working","url":"https:\/\/www.repairmsexcel.com\/blog\/vlookup-not-working","name":"Why is VLOOKUP Not Working in Excel? Get Fixes Here!","isPartOf":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/vlookup-not-working#primaryimage"},"image":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/vlookup-not-working#primaryimage"},"thumbnailUrl":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/09\/Why-VLOOKUP-Not-Working-in-excel.png","datePublished":"2025-07-04T07:50:44+00:00","dateModified":"2025-07-08T15:30:55+00:00","description":"Experiencing VLOOKUP not working in Excel? Discover expert tips to troubleshoot the issue fast. Get back into the work hassle-free!","breadcrumb":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/vlookup-not-working#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.repairmsexcel.com\/blog\/vlookup-not-working"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.repairmsexcel.com\/blog\/vlookup-not-working#primaryimage","url":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/09\/Why-VLOOKUP-Not-Working-in-excel.png","contentUrl":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/09\/Why-VLOOKUP-Not-Working-in-excel.png","width":550,"height":300,"caption":"Why VLOOKUP Not Working in excel"},{"@type":"BreadcrumbList","@id":"https:\/\/www.repairmsexcel.com\/blog\/vlookup-not-working#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.repairmsexcel.com\/blog"},{"@type":"ListItem","position":2,"name":"Why is VLOOKUP Not Working in Excel? Get Fixes Here!"}]},{"@type":"WebSite","@id":"https:\/\/www.repairmsexcel.com\/blog\/#website","url":"https:\/\/www.repairmsexcel.com\/blog\/","name":"Repair MS Excel","description":"Get Tips, Tricks and Fixes of MS Excel Issues","publisher":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.repairmsexcel.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.repairmsexcel.com\/blog\/#organization","name":"Repair MS Excel","url":"https:\/\/www.repairmsexcel.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.repairmsexcel.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/06\/repairmsexcel.com-logo.png","contentUrl":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/06\/repairmsexcel.com-logo.png","width":350,"height":70,"caption":"Repair MS Excel"},"image":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.repairmsexcel.com\/blog\/#\/schema\/person\/ab2250dcc6b25c12e617748b1fc166e3","name":"Priyanka Sahu","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.repairmsexcel.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/7e53e98dbd92755427e57013018cbed29ee3ae27e0a21f434dbd1ee1ce867558?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/7e53e98dbd92755427e57013018cbed29ee3ae27e0a21f434dbd1ee1ce867558?s=96&d=mm&r=g","caption":"Priyanka Sahu"},"description":"Priyanka is a content marketing expert. She writes tech blogs and has expertise in MS Office, Excel, and other tech subjects. Her distinctive art of presenting tech information in the easy-to-understand language is very impressive. When not writing, she loves unplanned travels.","sameAs":["https:\/\/www.repairmsexcel.com\/","https:\/\/www.linkedin.com\/in\/priyanka-sahu-2794a1242"],"url":"https:\/\/www.repairmsexcel.com\/blog\/author\/priyanka"}]}},"_links":{"self":[{"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/posts\/5857","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/comments?post=5857"}],"version-history":[{"count":4,"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/posts\/5857\/revisions"}],"predecessor-version":[{"id":9091,"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/posts\/5857\/revisions\/9091"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/media\/5863"}],"wp:attachment":[{"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/media?parent=5857"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/categories?post=5857"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/tags?post=5857"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}