{"id":249,"date":"2009-11-24T21:05:04","date_gmt":"2009-11-24T15:35:04","guid":{"rendered":"http:\/\/kedar.nitty-witty.com\/?p=249"},"modified":"2016-01-16T14:26:43","modified_gmt":"2016-01-16T14:26:43","slug":"usingvlookup-and-batch-script-to-compare-two-excel-csv-and-retrive-result","status":"publish","type":"post","link":"https:\/\/kedar.nitty-witty.com\/blog\/usingvlookup-and-batch-script-to-compare-two-excel-csv-and-retrive-result","title":{"rendered":"Using VLookup like Batch script to compare two excel \/ csv"},"content":{"rendered":"<p><strong>Using Vlookup:<\/strong><\/p>\n<p>I have two csv files; File1 has Id and Value Columns and File2 has Id.<\/p>\n<p>Problem: I need to compare both files and put respective values to File2 from File1.<\/p>\n<p>Solution: VLookup in excel<\/p>\n<p>Steps:<\/p>\n<ul>\n<li>Open both files in Excel &amp; arrange it vertically (Window &gt;&gt; Arrange; for ease)<\/li>\n<\/ul>\n<p style=\"text-align: center;\"><a href=\"http:\/\/kedar.nitty-witty.com\/wp-content\/uploads\/2009\/11\/vlookup-1.JPG\"><img decoding=\"async\" class=\"alignnone size-medium wp-image-250\" title=\"vlookup-1\" src=\"http:\/\/kedar.nitty-witty.com\/wp-content\/uploads\/2009\/11\/vlookup-1-299x199.jpg\" alt=\"vlookup-1\" width=\"299\" height=\"199\" \/><\/a><\/p>\n<ul>\n<li>Click on cell where you want to put compared value: B2<\/li>\n<li>Click on fx button and select VLOOKUP function.<\/li>\n<\/ul>\n<p style=\"text-align: center;\"><a href=\"http:\/\/kedar.nitty-witty.com\/wp-content\/uploads\/2009\/11\/vlookup-2.JPG\"><img decoding=\"async\" class=\"alignnone size-medium wp-image-251\" title=\"vlookup-2\" src=\"http:\/\/kedar.nitty-witty.com\/wp-content\/uploads\/2009\/11\/vlookup-2-300x201.jpg\" alt=\"vlookup-2\" width=\"300\" height=\"201\" \/><\/a><\/p>\n<ul>\n<li>Under lookup_value, click first search field: A2.<\/li>\n<li>Click back in Table_array text field, and click on button to select range. Select two column for comparison starting from second row, i.e. A2 to B9.<\/li>\n<li>Put 2 in Col_index_num. If lookup succeeds in finding lookup_value in Table_array it will return 2nd value as result.<\/li>\n<li>Put FALSE in Range_lookup to do exact match.<\/li>\n<li>Click ok, and you will find B2 will be filled with respective value.<\/li>\n<li>You may drag the command to other rows and values will get filled. Optionally you may copy and paste it from rows B3 to B9 to lookup and fill all values.<\/li>\n<\/ul>\n<p style=\"text-align: center;\"><a href=\"http:\/\/kedar.nitty-witty.com\/wp-content\/uploads\/2009\/11\/vlookup-3.JPG\"><img decoding=\"async\" class=\"aligncenter\" style=\"border: 0px initial initial;\" title=\"vlookup-3\" src=\"http:\/\/kedar.nitty-witty.com\/wp-content\/uploads\/2009\/11\/vlookup-3-300x212.jpg\" alt=\"vlookup-3\" width=\"300\" height=\"212\" \/><\/a><\/p>\n<ul>\n<li>You can observer in output here, if I change the value of ID in File2 which doesn\u2019t exist, VLookup returns #N\/A.<\/li>\n<\/ul>\n<p>Descriptions in details for this function and each respected field are easily available in excel help.<\/p>\n<p>Download Files: <a href=\"http:\/\/kedar.nitty-witty.com\/wp-content\/uploads\/2009\/11\/File1.csv\">File1<\/a>, <a href=\"http:\/\/kedar.nitty-witty.com\/wp-content\/uploads\/2009\/11\/File2.csv\">File2<\/a><\/p>\n<p><strong>Batch script to compare and assign value-simulate vlookup:<\/strong><\/p>\n<p>Further I came up with a batch script to compare field value, simulate vlookup.\u00a0After doinglittle testing, I managed to fix it.<\/p>\n<p><em>for \/f &#8220;tokens=1 delims=, skip=1&#8221; %%i in (File2.csv) do @findstr \u00a0&#8220;%%i,&#8221; File1.csv &gt;nul &amp; If errorlevel 0 if not errorlevel 1 (for \/f &#8220;tokens=1,2 delims=,&#8221; %%m in (&#8216;findstr \/i \/L &#8220;%%i,&#8221; File1.csv&#8217;) do (@echo %%m,%%n&gt;&gt;output.csv\u00a0echo %%i)) else (echo %%i,NA&gt;&gt;output.csv) <\/em><\/p>\n<p>Please consider this batch script is written specifically for these csv and prove my understanding.<br \/>\nThis script will compare file2 with file1, extract similar data from file1 and put it in output.csv.<\/p>\n<p><strong>Download batch file: <a href=\"http:\/\/kedar.nitty-witty.com\/wp-content\/uploads\/2009\/11\/vlukup.bat\">vlookup-batch.bat<\/a><br \/>\n<\/strong><\/p>\n<p>If you find any difficulty or don&#8217;t yield required results by following above process or using script, comment.<\/p>\n","protected":false},"excerpt":{"rendered":"Using Vlookup: I have two csv files; File1 has Id and Value Columns and File2 has Id. Problem: I need to compare both files and put respective values to File2&hellip;\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[6],"tags":[18,290,24,288,291,426,292,289,125],"class_list":["post-249","post","type-post","status-publish","format-standard","category-technical","tag-batch","tag-batch-script","tag-code","tag-compare-csv","tag-csv-compare","tag-technical","tag-using-vlookup","tag-vlookup","tag-windows"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 4.9.10 - aioseo.com -->\n\t<meta name=\"description\" content=\"Using VLookup like Batch script to compare two excel \/ csv and extract output in other file\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"Kedar\"\/>\n\t<meta name=\"google-site-verification\" content=\"_Bu1h5r0PxIC0D2jBVdmYN45RTeG9ogcX85XLkbG1qA\" \/>\n\t<meta name=\"msvalidate.01\" content=\"116B62074CBCA1BA99B8CCE09CCF2FB8\" \/>\n\t<meta name=\"keywords\" content=\"compare csv,vlookup,batch script,csv compare,using vlookup,batch,code,technical,windows\" \/>\n\t<link rel=\"canonical\" href=\"https:\/\/kedar.nitty-witty.com\/blog\/usingvlookup-and-batch-script-to-compare-two-excel-csv-and-retrive-result\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 4.9.10\" \/>\n\t\t<meta property=\"og:locale\" content=\"en_US\" \/>\n\t\t<meta property=\"og:site_name\" content=\"Change Is Inevitable | Kedar Vaijanapurkar&#039;s Blog for MySQL, technology and various subjects\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"Using VLookup like Batch script to compare two excel \/ csv | Change Is Inevitable\" \/>\n\t\t<meta property=\"og:description\" content=\"Using VLookup like Batch script to compare two excel \/ csv and extract output in other file\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/kedar.nitty-witty.com\/blog\/usingvlookup-and-batch-script-to-compare-two-excel-csv-and-retrive-result\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2009-11-24T15:35:04+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2016-01-16T14:26:43+00:00\" \/>\n\t\t<meta name=\"twitter:card\" content=\"summary\" \/>\n\t\t<meta name=\"twitter:title\" content=\"Using VLookup like Batch script to compare two excel \/ csv | Change Is Inevitable\" \/>\n\t\t<meta name=\"twitter:description\" content=\"Using VLookup like Batch script to compare two excel \/ csv and extract output in other file\" \/>\n\t\t<script type=\"application\/ld+json\" class=\"aioseo-schema\">\n\t\t\t{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/usingvlookup-and-batch-script-to-compare-two-excel-csv-and-retrive-result#article\",\"name\":\"Using VLookup like Batch script to compare two excel \\\/ csv | Change Is Inevitable\",\"headline\":\"Using VLookup like Batch script to compare two excel \\\/ csv\",\"author\":{\"@id\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/author\\\/admin#author\"},\"publisher\":{\"@id\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/#person\"},\"image\":{\"@type\":\"ImageObject\",\"url\":\"http:\\\/\\\/kedar.nitty-witty.com\\\/wp-content\\\/uploads\\\/2009\\\/11\\\/vlookup-1-299x199.jpg\",\"@id\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/usingvlookup-and-batch-script-to-compare-two-excel-csv-and-retrive-result\\\/#articleImage\"},\"datePublished\":\"2009-11-24T21:05:04+00:00\",\"dateModified\":\"2016-01-16T14:26:43+00:00\",\"inLanguage\":\"en-US\",\"commentCount\":2,\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/usingvlookup-and-batch-script-to-compare-two-excel-csv-and-retrive-result#webpage\"},\"isPartOf\":{\"@id\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/usingvlookup-and-batch-script-to-compare-two-excel-csv-and-retrive-result#webpage\"},\"articleSection\":\"Technical, batch, batch script, code, compare csv, csv compare, Technical, using vlookup, vlookup, windows\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/usingvlookup-and-batch-script-to-compare-two-excel-csv-and-retrive-result#breadcrumblist\",\"itemListElement\":[{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog#listItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/category\\\/technical#listItem\",\"name\":\"Technical\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/category\\\/technical#listItem\",\"position\":2,\"name\":\"Technical\",\"item\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/category\\\/technical\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/usingvlookup-and-batch-script-to-compare-two-excel-csv-and-retrive-result#listItem\",\"name\":\"Using VLookup like Batch script to compare two excel \\\/ csv\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog#listItem\",\"name\":\"Home\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/usingvlookup-and-batch-script-to-compare-two-excel-csv-and-retrive-result#listItem\",\"position\":3,\"name\":\"Using VLookup like Batch script to compare two excel \\\/ csv\",\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/category\\\/technical#listItem\",\"name\":\"Technical\"}}]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/#person\",\"name\":\"Kedar\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/usingvlookup-and-batch-script-to-compare-two-excel-csv-and-retrive-result#personImage\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/be1f7021485c325d92cc4c5d961accb9c1af72b1b11281a790f7f4f066ef10d3?s=96&d=mm&r=g\",\"width\":96,\"height\":96,\"caption\":\"Kedar\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/author\\\/admin#author\",\"url\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/author\\\/admin\",\"name\":\"Kedar\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/usingvlookup-and-batch-script-to-compare-two-excel-csv-and-retrive-result#authorImage\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/be1f7021485c325d92cc4c5d961accb9c1af72b1b11281a790f7f4f066ef10d3?s=96&d=mm&r=g\",\"width\":96,\"height\":96,\"caption\":\"Kedar\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/usingvlookup-and-batch-script-to-compare-two-excel-csv-and-retrive-result#webpage\",\"url\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/usingvlookup-and-batch-script-to-compare-two-excel-csv-and-retrive-result\",\"name\":\"Using VLookup like Batch script to compare two excel \\\/ csv | Change Is Inevitable\",\"description\":\"Using VLookup like Batch script to compare two excel \\\/ csv and extract output in other file\",\"inLanguage\":\"en-US\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/#website\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/usingvlookup-and-batch-script-to-compare-two-excel-csv-and-retrive-result#breadcrumblist\"},\"author\":{\"@id\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/author\\\/admin#author\"},\"creator\":{\"@id\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/author\\\/admin#author\"},\"datePublished\":\"2009-11-24T21:05:04+00:00\",\"dateModified\":\"2016-01-16T14:26:43+00:00\"},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/\",\"name\":\"..::CHANGE is INEVITABLE::..\",\"description\":\"Kedar Vaijanapurkar's Blog for MySQL, technology and various subjects\",\"inLanguage\":\"en-US\",\"publisher\":{\"@id\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/#person\"}}]}\n\t\t<\/script>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"Using VLookup like Batch script to compare two excel \/ csv | Change Is Inevitable","description":"Using VLookup like Batch script to compare two excel \/ csv and extract output in other file","canonical_url":"https:\/\/kedar.nitty-witty.com\/blog\/usingvlookup-and-batch-script-to-compare-two-excel-csv-and-retrive-result","robots":"max-image-preview:large","keywords":"compare csv,vlookup,batch script,csv compare,using vlookup,batch,code,technical,windows","webmasterTools":{"google-site-verification":"_Bu1h5r0PxIC0D2jBVdmYN45RTeG9ogcX85XLkbG1qA","msvalidate.01":"116B62074CBCA1BA99B8CCE09CCF2FB8","miscellaneous":""},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/kedar.nitty-witty.com\/blog\/usingvlookup-and-batch-script-to-compare-two-excel-csv-and-retrive-result#article","name":"Using VLookup like Batch script to compare two excel \/ csv | Change Is Inevitable","headline":"Using VLookup like Batch script to compare two excel \/ csv","author":{"@id":"https:\/\/kedar.nitty-witty.com\/blog\/author\/admin#author"},"publisher":{"@id":"https:\/\/kedar.nitty-witty.com\/blog\/#person"},"image":{"@type":"ImageObject","url":"http:\/\/kedar.nitty-witty.com\/wp-content\/uploads\/2009\/11\/vlookup-1-299x199.jpg","@id":"https:\/\/kedar.nitty-witty.com\/blog\/usingvlookup-and-batch-script-to-compare-two-excel-csv-and-retrive-result\/#articleImage"},"datePublished":"2009-11-24T21:05:04+00:00","dateModified":"2016-01-16T14:26:43+00:00","inLanguage":"en-US","commentCount":2,"mainEntityOfPage":{"@id":"https:\/\/kedar.nitty-witty.com\/blog\/usingvlookup-and-batch-script-to-compare-two-excel-csv-and-retrive-result#webpage"},"isPartOf":{"@id":"https:\/\/kedar.nitty-witty.com\/blog\/usingvlookup-and-batch-script-to-compare-two-excel-csv-and-retrive-result#webpage"},"articleSection":"Technical, batch, batch script, code, compare csv, csv compare, Technical, using vlookup, vlookup, windows"},{"@type":"BreadcrumbList","@id":"https:\/\/kedar.nitty-witty.com\/blog\/usingvlookup-and-batch-script-to-compare-two-excel-csv-and-retrive-result#breadcrumblist","itemListElement":[{"@type":"ListItem","@id":"https:\/\/kedar.nitty-witty.com\/blog#listItem","position":1,"name":"Home","item":"https:\/\/kedar.nitty-witty.com\/blog","nextItem":{"@type":"ListItem","@id":"https:\/\/kedar.nitty-witty.com\/blog\/category\/technical#listItem","name":"Technical"}},{"@type":"ListItem","@id":"https:\/\/kedar.nitty-witty.com\/blog\/category\/technical#listItem","position":2,"name":"Technical","item":"https:\/\/kedar.nitty-witty.com\/blog\/category\/technical","nextItem":{"@type":"ListItem","@id":"https:\/\/kedar.nitty-witty.com\/blog\/usingvlookup-and-batch-script-to-compare-two-excel-csv-and-retrive-result#listItem","name":"Using VLookup like Batch script to compare two excel \/ csv"},"previousItem":{"@type":"ListItem","@id":"https:\/\/kedar.nitty-witty.com\/blog#listItem","name":"Home"}},{"@type":"ListItem","@id":"https:\/\/kedar.nitty-witty.com\/blog\/usingvlookup-and-batch-script-to-compare-two-excel-csv-and-retrive-result#listItem","position":3,"name":"Using VLookup like Batch script to compare two excel \/ csv","previousItem":{"@type":"ListItem","@id":"https:\/\/kedar.nitty-witty.com\/blog\/category\/technical#listItem","name":"Technical"}}]},{"@type":"Person","@id":"https:\/\/kedar.nitty-witty.com\/blog\/#person","name":"Kedar","image":{"@type":"ImageObject","@id":"https:\/\/kedar.nitty-witty.com\/blog\/usingvlookup-and-batch-script-to-compare-two-excel-csv-and-retrive-result#personImage","url":"https:\/\/secure.gravatar.com\/avatar\/be1f7021485c325d92cc4c5d961accb9c1af72b1b11281a790f7f4f066ef10d3?s=96&d=mm&r=g","width":96,"height":96,"caption":"Kedar"}},{"@type":"Person","@id":"https:\/\/kedar.nitty-witty.com\/blog\/author\/admin#author","url":"https:\/\/kedar.nitty-witty.com\/blog\/author\/admin","name":"Kedar","image":{"@type":"ImageObject","@id":"https:\/\/kedar.nitty-witty.com\/blog\/usingvlookup-and-batch-script-to-compare-two-excel-csv-and-retrive-result#authorImage","url":"https:\/\/secure.gravatar.com\/avatar\/be1f7021485c325d92cc4c5d961accb9c1af72b1b11281a790f7f4f066ef10d3?s=96&d=mm&r=g","width":96,"height":96,"caption":"Kedar"}},{"@type":"WebPage","@id":"https:\/\/kedar.nitty-witty.com\/blog\/usingvlookup-and-batch-script-to-compare-two-excel-csv-and-retrive-result#webpage","url":"https:\/\/kedar.nitty-witty.com\/blog\/usingvlookup-and-batch-script-to-compare-two-excel-csv-and-retrive-result","name":"Using VLookup like Batch script to compare two excel \/ csv | Change Is Inevitable","description":"Using VLookup like Batch script to compare two excel \/ csv and extract output in other file","inLanguage":"en-US","isPartOf":{"@id":"https:\/\/kedar.nitty-witty.com\/blog\/#website"},"breadcrumb":{"@id":"https:\/\/kedar.nitty-witty.com\/blog\/usingvlookup-and-batch-script-to-compare-two-excel-csv-and-retrive-result#breadcrumblist"},"author":{"@id":"https:\/\/kedar.nitty-witty.com\/blog\/author\/admin#author"},"creator":{"@id":"https:\/\/kedar.nitty-witty.com\/blog\/author\/admin#author"},"datePublished":"2009-11-24T21:05:04+00:00","dateModified":"2016-01-16T14:26:43+00:00"},{"@type":"WebSite","@id":"https:\/\/kedar.nitty-witty.com\/blog\/#website","url":"https:\/\/kedar.nitty-witty.com\/blog\/","name":"..::CHANGE is INEVITABLE::..","description":"Kedar Vaijanapurkar's Blog for MySQL, technology and various subjects","inLanguage":"en-US","publisher":{"@id":"https:\/\/kedar.nitty-witty.com\/blog\/#person"}}]},"og:locale":"en_US","og:site_name":"Change Is Inevitable | Kedar Vaijanapurkar's Blog for MySQL, technology and various subjects","og:type":"article","og:title":"Using VLookup like Batch script to compare two excel \/ csv | Change Is Inevitable","og:description":"Using VLookup like Batch script to compare two excel \/ csv and extract output in other file","og:url":"https:\/\/kedar.nitty-witty.com\/blog\/usingvlookup-and-batch-script-to-compare-two-excel-csv-and-retrive-result","article:published_time":"2009-11-24T15:35:04+00:00","article:modified_time":"2016-01-16T14:26:43+00:00","twitter:card":"summary","twitter:title":"Using VLookup like Batch script to compare two excel \/ csv | Change Is Inevitable","twitter:description":"Using VLookup like Batch script to compare two excel \/ csv and extract output in other file"},"aioseo_meta_data":{"post_id":"249","title":"Using VLookup like Batch script to compare two excel \/ csv | #site_title","description":"Using VLookup like Batch script to compare two excel \/ csv and extract output in other file","keywords":[{"label":"compare csv","value":"compare csv"},{"label":"vlookup","value":"vlookup"},{"label":"batch script","value":"batch script"},{"label":"csv compare","value":"csv compare"},{"label":"using vlookup","value":"using vlookup"}],"keyphrases":null,"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":null,"og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"","isEnabled":true},"graphs":[]},"schema_type":null,"schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":null,"robots_max_videopreview":null,"robots_max_imagepreview":"large","priority":null,"frequency":null,"location":null,"local_seo":null,"breadcrumb_settings":null,"limit_modified_date":false,"ai":null,"created":"2021-03-24 17:44:00","updated":"2025-08-16 19:01:23","seo_analyzer_scan_date":null},"aioseo_breadcrumb":"<div class=\"aioseo-breadcrumbs\"><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/kedar.nitty-witty.com\/blog\" title=\"Home\">Home<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">\u00bb<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/kedar.nitty-witty.com\/blog\/category\/technical\" title=\"Technical\">Technical<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">\u00bb<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\tUsing VLookup like Batch script to compare two excel \/ csv\n\t\t<\/span><\/div>","aioseo_breadcrumb_json":[{"label":"Home","link":"https:\/\/kedar.nitty-witty.com\/blog"},{"label":"Technical","link":"https:\/\/kedar.nitty-witty.com\/blog\/category\/technical"},{"label":"Using VLookup like Batch script to compare two excel \/ csv","link":"https:\/\/kedar.nitty-witty.com\/blog\/usingvlookup-and-batch-script-to-compare-two-excel-csv-and-retrive-result"}],"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/kedar.nitty-witty.com\/blog\/wp-json\/wp\/v2\/posts\/249","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kedar.nitty-witty.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kedar.nitty-witty.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kedar.nitty-witty.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kedar.nitty-witty.com\/blog\/wp-json\/wp\/v2\/comments?post=249"}],"version-history":[{"count":5,"href":"https:\/\/kedar.nitty-witty.com\/blog\/wp-json\/wp\/v2\/posts\/249\/revisions"}],"predecessor-version":[{"id":1683,"href":"https:\/\/kedar.nitty-witty.com\/blog\/wp-json\/wp\/v2\/posts\/249\/revisions\/1683"}],"wp:attachment":[{"href":"https:\/\/kedar.nitty-witty.com\/blog\/wp-json\/wp\/v2\/media?parent=249"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kedar.nitty-witty.com\/blog\/wp-json\/wp\/v2\/categories?post=249"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kedar.nitty-witty.com\/blog\/wp-json\/wp\/v2\/tags?post=249"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}