{"id":1799,"date":"2020-02-12T10:37:00","date_gmt":"2020-02-12T10:37:00","guid":{"rendered":"https:\/\/hippotechgroup.com\/xlookup-a-new-function-now-available-in-excel\/"},"modified":"2025-12-04T14:05:37","modified_gmt":"2025-12-04T14:05:37","slug":"xlookup-a-new-function-now-available-in-excel","status":"publish","type":"post","link":"https:\/\/hippotechgroup.com\/ro\/xlookup-a-new-function-now-available-in-excel\/","title":{"rendered":"XLOOKUP a New Function Now Available in Excel"},"content":{"rendered":"<div class=\"hippo-before-content\" id=\"hippo-1328437639\"><script async src=\"\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js?client=ca-pub-8362125513622191\" crossorigin=\"anonymous\"><\/script><ins class=\"adsbygoogle\" style=\"display:block;\" data-ad-client=\"ca-pub-8362125513622191\" \ndata-ad-slot=\"7257236543\" \ndata-ad-format=\"auto\"><\/ins>\n<script> \n(adsbygoogle = window.adsbygoogle || []).push({}); \n<\/script>\n<\/div><div class=\"separator\" data-amp-style=\"clear: both; text-align: center;\">\n<\/div>\n<div class=\"separator\" data-amp-style=\"clear: both; text-align: center;\">\n<\/div>\n<div class=\"separator\" data-amp-style=\"clear: both; text-align: center;\">\n<a data-amp-imageanchor=\"1\" data-amp-style=\"margin-left: 1em; margin-right: 1em;\" href=\"https:\/\/hippotechgroup.com\/wp-content\/uploads\/2020\/02\/microsoft-office-365-excel.jpg\"><span data-amp-style=\"font-family: &quot;helvetica neue&quot; , &quot;arial&quot; , &quot;helvetica&quot; , sans-serif;\"><\/span><\/a><\/div>\n<div class=\"separator\" data-amp-style=\"clear: both; text-align: center;\">\n<\/div>\n<div data-amp-style=\"background-color: white; line-height: 1.7999999999999998; margin-bottom: 0pt; margin-top: 0pt; padding: 0pt 0pt 18pt 0pt; text-align: justify;\" dir=\"ltr\">\n<h3>\n<div data-amp-style=\"text-align: center;\">\n<span data-amp-style=\"font-family: &quot;helvetica neue&quot;, arial, helvetica, sans-serif;\">XLOOKUP A NEW FUNCTION ON EXCEL<\/span><\/div>\n<p><span data-amp-style=\"font-family: &quot;helvetica neue&quot; , &quot;arial&quot; , &quot;helvetica&quot; , sans-serif;\"><\/p>\n<div class=\"separator\" data-amp-style=\"clear: both; text-align: center;\">\n<a data-amp-imageanchor=\"1\" data-amp-style=\"margin-left: 1em; margin-right: 1em;\" href=\"https:\/\/hippotechgroup.com\/wp-content\/uploads\/2020\/02\/xlookup-function-ms-office.jpg\"><img decoding=\"async\" alt=\"XLOOKUP a New Function\" border=\"0\" data-original-height=\"800\" data-original-width=\"1422\" src=\"https:\/\/hippotechgroup.com\/wp-content\/uploads\/2020\/02\/xlookup-function-ms-office.jpg\" title=\"XLOOKUP a New Function\"><\/a><\/div>\n<p><\/span><\/h3>\n<\/div>\n<div data-amp-style=\"background-color: white; line-height: 1.7999999999999998; margin-bottom: 0pt; margin-top: 0pt; padding: 0pt 0pt 18pt 0pt; text-align: justify;\" dir=\"ltr\">\n<span data-amp-style=\"font-family: &quot;helvetica neue&quot; , &quot;arial&quot; , &quot;helvetica&quot; , sans-serif;\">Back in August of last year, Microsoft introduced a major new function for Microsoft Excel. The company introduced the world to XLOOKUP, a new Excel function that is succeeding Excel\u2019s iconic VLOOKUP function.<\/span><\/div>\n<div data-amp-style=\"background-color: white; line-height: 1.7999999999999998; margin-bottom: 0pt; margin-top: 0pt; padding: 0pt 0pt 18pt 0pt; text-align: justify;\" dir=\"ltr\">\n<span data-amp-style=\"font-family: &quot;helvetica neue&quot; , &quot;arial&quot; , &quot;helvetica&quot; , sans-serif;\">At the time, Microsoft said VLOOKUP was one of the most popular Excel functions used worldwide, existing in the app for 35 years. Microsoft is now <a href=\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2020\/02\/10\/find-what-you-need-faster-xlookup-now-generally-available\/\" rel=\"nofollow\" target=\"_blank\">introducing<\/a> the new XLOOKUP function that will succeed VLOOKUP, which was first in testing with Insiders, and is now generally available.<\/span><br \/>\n<span data-amp-style=\"font-family: &quot;helvetica neue&quot; , &quot;arial&quot; , &quot;helvetica&quot; , sans-serif;\"><span data-amp-style=\"font-family: &quot;helvetica neue&quot; , &quot;arial&quot; , &quot;helvetica&quot; , sans-serif;\"><br \/>\n<\/span> <\/span><\/p>\n<div class=\"separator\" data-amp-style=\"clear: both; text-align: center;\">\n<a data-amp-imageanchor=\"1\" data-amp-style=\"margin-left: 1em; margin-right: 1em;\" href=\"https:\/\/hippotechgroup.com\/wp-content\/uploads\/2020\/02\/excel-xlookup.jpg\"><span data-amp-style=\"font-family: &quot;helvetica neue&quot; , &quot;arial&quot; , &quot;helvetica&quot; , sans-serif;\"><img loading=\"lazy\" decoding=\"async\" alt=\"XLOOKUP a New Function1\" border=\"0\" data-original-height=\"405\" data-original-width=\"1065\" height=\"241\" src=\"https:\/\/blogger.googleusercontent.com\/img\/b\/R29vZ2xl\/AVvXsEgOU7kxuia5DGSG93gOZZrAuNI4fkY_fQsvVnv5WT-YycXifsN9bPyI8w7_6URcaJbSVHVepPyhw7tPyJfkjyNPsFAvC5RNmQ56bmOuU5mPQiA3dWXGLRPzuqAxtT3RoQN2dljxxTgnYfYW\/s640\/excel-xlookup.jpg\" title=\"XLOOKUP a New Function1\" width=\"640\"><\/span><\/a><\/div>\n<p><span data-amp-style=\"font-family: &quot;helvetica neue&quot; , &quot;arial&quot; , &quot;helvetica&quot; , sans-serif;\"><br \/>\n<\/span><\/div>\n<div data-amp-style=\"background-color: white; line-height: 1.7999999999999998; margin-bottom: 0pt; margin-top: 0pt; padding: 0pt 0pt 18pt 0pt; text-align: justify;\" dir=\"ltr\">\n<span data-amp-style=\"font-family: &quot;helvetica neue&quot; , &quot;arial&quot; , &quot;helvetica&quot; , sans-serif;\">XLOOKUP allows users to look for values both vertically and horizontally, removing the need for the HLOOKUP function as well. \u201cXLOOKUP helps users find what they need more efficiently with fewer limitations, from being able to look up a value vertically and horizontally (and to the left!) to supporting column insertions and deletions and more,\u201d said Microsoft.<\/span><\/div>\n<div data-amp-style=\"background-color: white; line-height: 1.7999999999999998; margin-bottom: 0pt; margin-top: 0pt; padding: 0pt 0pt 18pt 0pt; text-align: justify;\" dir=\"ltr\">\n<span data-amp-style=\"font-family: &quot;helvetica neue&quot; , &quot;arial&quot; , &quot;helvetica&quot; , sans-serif;\">XLOOKUP does look like a very handy function much like its predecessors VLOOKUP and HLOOKUP. If you use Excel at all, you will probably want to check out the full features and commands available for the function <a href=\"https:\/\/support.office.com\/en-us\/article\/xlookup-function-b7fd680e-6d10-43e6-84f9-88eae8bf5929\" rel=\"nofollow\" target=\"_blank\">here<\/a>.&nbsp;<\/span><\/p>\n<p><span data-amp-style=\"font-family: Helvetica Neue, Arial, Helvetica, sans-serif;\">For other related articles click <a href=\"https:\/\/hippotechgroup.com\/ro\/search\/label\/How-To\/\" target=\"_blank\">here<\/a>.<\/span><\/div>\n<div data-amp-style=\"text-align: justify;\">\n<\/div>","protected":false},"excerpt":{"rendered":"<p>XLOOKUP A NEW FUNCTION ON EXCEL Back in August of last year, Microsoft introduced a major new function for Microsoft Excel. The company introduced the world to XLOOKUP, a new Excel function that is succeeding Excel\u2019s iconic VLOOKUP function. At the time, Microsoft said VLOOKUP was one of the most popular Excel functions used worldwide, [&hellip;]<\/p>","protected":false},"author":1,"featured_media":1800,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_gspb_post_css":"","footnotes":""},"categories":[40],"tags":[],"class_list":["post-1799","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-windows"],"blocksy_meta":[],"_links":{"self":[{"href":"https:\/\/hippotechgroup.com\/ro\/wp-json\/wp\/v2\/posts\/1799","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hippotechgroup.com\/ro\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hippotechgroup.com\/ro\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hippotechgroup.com\/ro\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/hippotechgroup.com\/ro\/wp-json\/wp\/v2\/comments?post=1799"}],"version-history":[{"count":1,"href":"https:\/\/hippotechgroup.com\/ro\/wp-json\/wp\/v2\/posts\/1799\/revisions"}],"predecessor-version":[{"id":1803,"href":"https:\/\/hippotechgroup.com\/ro\/wp-json\/wp\/v2\/posts\/1799\/revisions\/1803"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/hippotechgroup.com\/ro\/wp-json\/wp\/v2\/media\/1800"}],"wp:attachment":[{"href":"https:\/\/hippotechgroup.com\/ro\/wp-json\/wp\/v2\/media?parent=1799"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hippotechgroup.com\/ro\/wp-json\/wp\/v2\/categories?post=1799"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hippotechgroup.com\/ro\/wp-json\/wp\/v2\/tags?post=1799"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}