LOOKUP Archives - Xelplus - Leila Gharani

How to use Excel’s LOOKUP Function

Leila Gharani — Thu, 05 May 2022 08:00:00 +0000

The lookup function is the simplest function in Excel. It can return exact or approximate matches and it's super easy to write. Yet many people prefer VLOOKUP because it's easier to understand. In this tutorial, I'll explain the LOOKUP function by using a simple, followed by a more complex example.

The post How to use Excel’s LOOKUP Function appeared first on Xelplus - Leila Gharani.

Top Excel Functions for Engineers

Leila Gharani — Thu, 23 Dec 2021 10:00:00 +0000

If you're a Mechanical Engineer, make sure you know these 10 Excel functions. Your work-life will become much easier once you learn these Excel formula combinations.

The post Top Excel Functions for Engineers appeared first on Xelplus - Leila Gharani.

How to Use the Excel FILTER Function

Leila Gharani — Thu, 09 Jan 2020 10:00:00 +0000

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.

Excel XLOOKUP Explained

Leila Gharani — Thu, 12 Sep 2019 09:00:00 +0000

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 Explained appeared first on Xelplus - Leila Gharani.

Lookup Within Boundaries

Leila Gharani — Sun, 12 Feb 2017 10:20:00 +0000

This tutorial takes you through three powerful Excel formulas that lookup values in ranges that include lower bound and upper bound values. They are SUMIFS, SUMPRODUCT and INDEX/MATCH. Find the one that works best for your scenario.

The post Lookup Within Boundaries appeared first on Xelplus - Leila Gharani.