VLOOKUP alternative Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/vlookup-alternative/ Bestselling Excel and Power BI Courses Mon, 05 May 2025 09:06:19 +0000 en-US hourly 1 https://www.xelplus.com/wp-content/uploads/2022/10/cropped-site-icon-32x32.png VLOOKUP alternative Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/vlookup-alternative/ 32 32 Excel DGET Function Solves Two of Your VLOOKUP Problems https://www.xelplus.com/excel-dget-function/ Thu, 16 Jan 2020 10:00:00 +0000 https://www.xelplus.com/?p=11580 Quickly learn how to use Excel's DGET Function to lookup one or more criteria. DGET can also do a left lookup (unlike VLOOKUP). It's a forgotten Excel database function. Can you apply DGET to a range of cells? Find out in this article.

The post Excel DGET Function Solves Two of Your VLOOKUP Problems appeared first on Xelplus - Leila Gharani.

]]> How to Use the Excel FILTER Function https://www.xelplus.com/excel-filter-function/ Thu, 09 Jan 2020 10:00:00 +0000 https://www.xelplus.com/?p=11591 Excel's new FILTER Function will save you a ton of time! It's like doing a VLOOKUP but returning all matches instead of the first match. You can even match for multiple criteria AND return all match results in Excel.

The post How to Use the Excel FILTER Function appeared first on Xelplus - Leila Gharani.

]]> Top 5 Excel Interview Questions https://www.xelplus.com/top-5-excel-interview-questions/ Thu, 10 Oct 2019 09:00:00 +0000 https://www.xelplus.com/?p=12068 Make sure you know the answers to these Excel Interview questions before you go to your next interview. These are asked specially if you're applying for data analyst jobs.

The post Top 5 Excel Interview Questions appeared first on Xelplus - Leila Gharani.

]]> Excel XLOOKUP Function https://www.xelplus.com/excel-xlookup/ Thu, 12 Sep 2019 09:00:00 +0000 https://www.xelplus.com/?p=12219 Discover what Excel's NEW XLOOKUP Function can do for you and how it can help you with your Excel lookup problem. In this example we use XLOOKUP to lookup values on another sheet (Yes - No more VLOOKUP for these tasks!)

The post Excel XLOOKUP Function appeared first on Xelplus - Leila Gharani.

]]>