02-12-2020, 01:58 AM
Now in Excel: Find what you need faster with XLOOKUP
<div><p>The highly anticipated XLOOKUP function in Excel is generally available for all users across Windows, Mac, and Excel on the web. XLOOKUP is the successor to the iconic VLOOKUP function, which has been one of the most used functions in Excel.</p>
<p>XLOOKUP helps users find what they need more efficiently with fewer limitations, from being able to look up a value vertically <em>and</em> horizontally (and to the left!) to supporting column insertions and deletions and more.</p>
<p><a href="https://www.sickgaming.net/blog/wp-content/uploads/2020/02/now-in-excel-find-what-you-need-faster-with-xlookup.gif" target="_blank" rel="noopener noreferrer"><img class="alignnone wp-image-233877 size-full" src="https://www.sickgaming.net/blog/wp-content/uploads/2020/02/now-in-excel-find-what-you-need-faster-with-xlookup.gif" alt="An animated image of Excel's XLOOKUP function being used on a tablet. The user is looking up offices, names, and roles." width="900" height="622"></a></p>
<p>Previously, <a href="https://techcommunity.microsoft.com/t5/excel-blog/announcing-xlookup/ba-p/811376" target="_blank" rel="noopener noreferrer">we released XLOOKUP to Office Insiders</a> and received lots of excitement and feedback on the feature. While you can still perform VLOOKUP functions, we encourage you to try XLOOKUP for better and faster results. For more information on XLOOKUP, read our <a href="https://support.office.com/en-us/article/xlookup-function-b7fd680e-6d10-43e6-84f9-88eae8bf5929" target="_blank" rel="noopener noreferrer">help article</a> and our <a href="https://techcommunity.microsoft.com/t5/excel-blog/announcing-xlookup/ba-p/811376" target="_blank" rel="noopener noreferrer">previous announcement</a> of XLOOKUP’s Office Insiders release.</p>
<h3>Stay updated</h3>
<p>To stay updated on the latest Excel news, follow the <a href="https://techcommunity.microsoft.com/t5/excel-blog/bg-p/ExcelBlog" target="_blank" rel="noopener noreferrer">Excel blog on Tech Community</a> and Excel on <a href="https://www.facebook.com/microsoftexcel/" target="_blank" rel="noopener noreferrer">Facebook</a> and <a href="https://twitter.com/msexcel" target="_blank" rel="noopener noreferrer">Twitter</a>. Also, to try XLOOKUP and other new features in Excel, make sure you have the <a href="https://products.office.com/en-us/excel?wt.mc_id=AID2409697_QSG_BLOG_404327&ocid=AID2409697_QSG_BLOG_404327" target="_blank" rel="noopener noreferrer">latest version of Excel</a>.</p>
<nav class="c-link-navigation f-align-left custom-link-navigation custom-taxonomy-navigation" aria-labelledby="category-header">
<h3 id="category-header" class="x-screen-reader"> Categories </h3>
</nav>
</div>
https://www.sickgaming.net/blog/2020/02/...h-xlookup/
<div><p>The highly anticipated XLOOKUP function in Excel is generally available for all users across Windows, Mac, and Excel on the web. XLOOKUP is the successor to the iconic VLOOKUP function, which has been one of the most used functions in Excel.</p>
<p>XLOOKUP helps users find what they need more efficiently with fewer limitations, from being able to look up a value vertically <em>and</em> horizontally (and to the left!) to supporting column insertions and deletions and more.</p>
<p><a href="https://www.sickgaming.net/blog/wp-content/uploads/2020/02/now-in-excel-find-what-you-need-faster-with-xlookup.gif" target="_blank" rel="noopener noreferrer"><img class="alignnone wp-image-233877 size-full" src="https://www.sickgaming.net/blog/wp-content/uploads/2020/02/now-in-excel-find-what-you-need-faster-with-xlookup.gif" alt="An animated image of Excel's XLOOKUP function being used on a tablet. The user is looking up offices, names, and roles." width="900" height="622"></a></p>
<p>Previously, <a href="https://techcommunity.microsoft.com/t5/excel-blog/announcing-xlookup/ba-p/811376" target="_blank" rel="noopener noreferrer">we released XLOOKUP to Office Insiders</a> and received lots of excitement and feedback on the feature. While you can still perform VLOOKUP functions, we encourage you to try XLOOKUP for better and faster results. For more information on XLOOKUP, read our <a href="https://support.office.com/en-us/article/xlookup-function-b7fd680e-6d10-43e6-84f9-88eae8bf5929" target="_blank" rel="noopener noreferrer">help article</a> and our <a href="https://techcommunity.microsoft.com/t5/excel-blog/announcing-xlookup/ba-p/811376" target="_blank" rel="noopener noreferrer">previous announcement</a> of XLOOKUP’s Office Insiders release.</p>
<h3>Stay updated</h3>
<p>To stay updated on the latest Excel news, follow the <a href="https://techcommunity.microsoft.com/t5/excel-blog/bg-p/ExcelBlog" target="_blank" rel="noopener noreferrer">Excel blog on Tech Community</a> and Excel on <a href="https://www.facebook.com/microsoftexcel/" target="_blank" rel="noopener noreferrer">Facebook</a> and <a href="https://twitter.com/msexcel" target="_blank" rel="noopener noreferrer">Twitter</a>. Also, to try XLOOKUP and other new features in Excel, make sure you have the <a href="https://products.office.com/en-us/excel?wt.mc_id=AID2409697_QSG_BLOG_404327&ocid=AID2409697_QSG_BLOG_404327" target="_blank" rel="noopener noreferrer">latest version of Excel</a>.</p>
<nav class="c-link-navigation f-align-left custom-link-navigation custom-taxonomy-navigation" aria-labelledby="category-header">
<h3 id="category-header" class="x-screen-reader"> Categories </h3>
</nav>
</div>
https://www.sickgaming.net/blog/2020/02/...h-xlookup/